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

AVG Vs Std Cost with Inv from As of

SELECT t1.C2ctry, t1.C2fy, t1.C2itm, t1.C2litm, t1.C2mcu, t3.c0mmcu, t1.C2ledg, t2.Coledg,  t1.C2uncs/10000, t2.Councs/10000 ,t4.inlocn, t4.inlotn, t4.inglpt, t4.innq09/1000 FROM proddta.F554105 t1, proddta.F4105 t2, proddta.F554103 t3, proddta.F41112 t4
WHERE
t1.c2ledg = '02' AND
t2.coledg = '07' AND
t1.c2itm = t2.coitm AND
t1.c2mcu = t2.comcu AND
t1.c2pn = 9 AND
t2.coitm = t4.initm AND
t2.comcu = t4.inmcu AND
t4.innq09 <> 0 AND
--t2.c2pn  = 8 AND
--t1.c2uncs <> t2.c2uncs AND
t1.c2mcu = '     3110022' AND
t1.c2mcu = t3.c0mcu
ORDER BY t1.C2ctry, t1.C2fy, t1.C2itm, t1.C2litm, t3.C0mmcu, t1.c2mcu;