RI Transactions that were NOT revalued - Missing Avg Cost

SELECT *
  FROM PRODDTA.F4111
 WHERE ILDGL >= 111274
   AND ILDGL <= 111304
   AND ILDCT = 'RI'
AND ilkco = '00311'
   AND ILDCTO IN ('S7',
                  'S9',
                  'SA',
                  'SE',
                  'SF',
                  'SH',
                  'SJ',
                  'SN',
                  'SQ',
                  'ST',
                  'SU',
                  'SV',
                  'SW',
                  'SX',
                  'V1',
                  'V2',
                  'V4',
                  'V7',
                  'V8',
                  'V9',
                  'VA',
                  'VF',
                  'VJ',
                  'VM',
                  'VN',
                  'VQ',
                  'VR',
                  'VS',
                  'VT',
                  'VU',
                  'VV',
                  'VX',
                  'VY')
   AND NOT EXISTS
 (SELECT * FROM PRODDTA.F554113 WHERE RAUKID = ILUKID)
 AND NOT EXISTS
 (SELECT * FROM proddta.F554105 WHERE c2ctry = 20 AND c2fy = 11 AND c2pn = 10 AND c2ledg = '02' AND c2itm = ilitm AND c2mcu = ilmcu)

RI Transactions that were NOT revalued

SELECT * FROM proddta.F4111 WHERE ildgl >= 111274 AND
ildgl <= 111304 AND
ildct = 'RI' AND
ildcto IN ('S7','S9','SA','SE','SF','SH','SJ','SN','SQ','ST','SU','SV','SW','SX','V1','V2','V4','V7','V8','V9','VA','VF','VJ','VM','VN','VQ','VR','VS','VT','VU','VV','VX','VY') AND
NOT EXISTS (SELECT * FROM proddta.F554113 WHERE raukid = ilukid)

Update STKT to M when we have activity

update ${JDE_SCHEMA}.F4102 set ibstkt = 'M'
WHERE ibstkt = 'P'
and exists (SELECT 'X'
            FROM proddta.F4111
            WHERE ilmcu = ibmcu
            AND ilitm = ibitm
            AND ildct = 'IC');

Identify *OP items where QTY <> 0

SELECT * FROM proddta.F4101, proddta.F41021 WHERE lipqoh <> 0 AND liitm = imitm AND imlitm LIKE '%*OP%'

Update IPCD Flag - X for *OP items

UPDATE proddta.F4111 -- 5035 rows
SET ilipcd = 'X'
WHERE ilipcd <> 'X' AND illitm LIKE '%*OP%'

Check REVAL Location for all Branch Plants

SELECT *
  FROM PRODDTA.F0006
 WHERE MCSTYL = 'BP'
   AND MCCO IN ('00310', '00311')
   AND NOT EXISTS (SELECT *
          FROM PRODDTA.F4100
         WHERE LMLOCN = 'REVAL'
           AND LMMCU = MCMCU)