select * from USPDDTA.F41112 where INDCT = 'BF' and INFY = 15 and INCTRY = 20 and INMCU like ' FS%' and
(INCMQT+INNQ01+INNQ02+INNQ03+INNQ04+INNQ05+INNQ06+INNQ07+INNQ08+INNQ09+INNQ10+INNQ11+INNQ12+INNQ13+innq14) <> 0 and
not exists (select * from USPDDTA.F4102 where IBITM = INITM and IBMCU = INMCU and IBGLPT = INGLPT)
and INGLPT not like 'FG%'
and exists (select * from uspddta.F4102 T1 where T1.ibitm = initm and T1.ibmcu = inmcu and T1.ibglpt like 'FG%')
order by initm, inmcu,inlocn, inlotn, inglpt;
No comments:
Post a Comment