SELECT ILITM, ILLITM, ILMCU, ILLOCN, ILLOTN, ILGLPT, INNQ06, SUM(ILTRQT)
FROM PRODDTA.F4111, PRODDTA.F41112
WHERE ILITM = INITM
AND ILMCU = INMCU
AND ILLOCN = INLOCN
AND ILLOTN = INLOTN
AND ILGLPT = INGLPT
AND INDCT = 'BF'
AND INCTRY = 20
AND INFY = 12
AND ILIPCD = 'Y'
--AND ILITM = 405239
AND ILMCU = ' 3110082'
AND ILDGL >= 112153
AND ILDGL <= 112182
AND ILUKID >= 9257279 --AND ROWNUM <=100000
GROUP BY ILITM, ILLITM, ILMCU, ILLOCN, ILLOTN, ILGLPT, INNQ06
HAVING SUM(iltrqt) <> innq06;
No comments:
Post a Comment