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)

Identify Purchased Items with Inventory Completion in Cardex

SELECT * FROM proddta.F4102 WHERE
ibstkt = 'P' AND
 EXISTS
(SELECT * FROM proddta.F4111 WHERE ilmcu = ibmcu AND ilitm = ibitm AND ildct = 'IC' AND ildgl <=111304)

Load F5541052 based on F554105

INSERT INTO proddta.F5541052
(SELECT c2ctry, c2fy, c2pn, c2ledg, c2itm, c2litm, c2aitm, c2mcu, c2locn, c2lotn, 0,c2uncs, 0, 0, 0, 0, 0, 0, ' ', 0, 0, 0, 'SQLSYNC', 'SQLFIX', 'SQL', 'SQL', 111273, 63700  FROM proddta.F554105 WHERE
c2litm = 'C2118220' AND
c2pn = 7 AND
NOT EXISTS (SELECT * FROM proddta.F5541052 WHERE c2itm = miitm AND c2mcu = mimmcu AND c2pn = mipn AND c2ctry = mictry AND c2fy = mify))

Compare F554105 Vs F5541052

SELECT * FROM proddta.F554105 WHERE c2pn = 8 AND c2litm = 'F204020' AND NOT EXISTS (SELECT * FROM proddta.F5541052 WHERE mipn = 8 AND miitm = c2itm AND mimmcu = c2mcu)

Negative Inventory in As of

SELECT initm, inmcu, ((SUM(incmqt)+SUM(innq01)+SUM(innq02)+SUM(innq03)+SUM(innq04)+SUM(innq05)+SUM(innq06)+SUM(innq07)+SUM(innq08)+SUM(innq09))/1000) Balance_QTY
FROM qadta.F41112
WHERE indct = 'BF' AND
infy = 11 AND
inctry = 20
GROUP BY initm, inmcu
HAVING (SUM(incmqt)+SUM(innq01)+SUM(innq02)+SUM(innq03)+SUM(innq04)+SUM(innq05)+SUM(innq06)+SUM(innq07)+SUM(innq08)+SUM(innq09)) <0

Identify Reval Records by DCTO

SELECT ilitm, illitm, ilaitm, ilmcu, illocn, illotn, ilkco, ildoc, ildct, ilicu, ildgl, ilglpt, iltrex, ilrcd, iluncs, ilpaid, ilukid  FROM  proddta.F4111, proddta.F554114
WHERE
ilukid = pcukid AND
pcev07 = 'A' AND
--ildgl >= 111244 AND
ildgl = 111273 AND
--ilitm = 300000 AND
pcuk01 IN (SELECT DISTINCT(pcuk01) FROM proddta.F554114, proddta.F554113 WHERE
rauk01 = pcuk01 AND pcev07 = 'D' AND
radcto = 'O7')

REVAL Join of Cardex with Control Tables

SELECT ilkco, pcev07, COUNT(*) FROM proddta.F554113, proddta.F554114, proddta.F4111
WHERE
rauk01 = pcuk01 AND
raukid = pcukid AND
raukid = ilukid AND
--raitm = 349869 AND
pcev07 = 'E'
GROUP BY ilkco, pcev07