Wednesday, July 4, 2012

Integrity between Cardex Vs As off


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