compare as off with cardex for FY 15 transactions

-- compare as off with cardex for FY 15 transactions
SELECT ILITM "Short Item", ILLITM "Item", ILMCU "Branch", ILLOCN "Location", ILLOTN "Lot Number", ILGLPT "GL Class", ibglpt "item gl class", IMUOM1 "Primary UOM" , ILTRUM "Transaction UOM",
SUM(ILTRQT)/100000 "Ledger Qty", (SUM(ILTRQT)/100000)/(nvl((SELECT umconv/10000000 FROM uspddta.F41002 where umitm = ilitm and umum = imuom1 and umrum = iltrum),1)) "CS Conv",
(SELECT  ( t2.incmqt+t2.innq01+t2.innq02+t2.innq03+t2.innq04+t2.innq05+t2.innq06+t2.innq07+t2.innq08+t2.innq09+t2.innq10+t2.innq11+t2.innq12+t2.innq13)  /100000 FROM uspddta.f41112 t2
WHERE t2.infy = 15 AND t2.inctry = 20 AND t2.indct = 'BF' AND t2.initm = ilitm AND t2.inmcu = ilmcu AND t2.inlocn = illocn AND t2.inlotn = illotn AND t2.inglpt = ilglpt ) "As of Qty FY15"
FROM uspddta.f4111, uspddta.f4101, uspddta.f4102
WHERE /*ilitm IN(173345) AND*/ imitm = ilitm AND ibitm = ilitm AND ibmcu = ilmcu
AND ildgl <= 116182 /* ILMCU LIKE '          B%'  /*and illocn = 'HOLD'*/
GROUP BY ILITM, ILLITM, ILMCU, ILLOCN, ILLOTN, ILGLPT,IBGLPT,  ILTRUM, IMUOM1;