SELECT T0.CMITM,
T0.CMLITM,
T0.CMAITM,
T0.CMMCU,
T0.CMSRCCNTMJ,
T0.CMSRCCNTMI,
T1.IEITM,
T1.IELITM,
T1.IEAITM,
T1.IEMMCU,
T1.IELOCN,
T1.IELOTN,
T1.IELEDG,
T1.IECOST,
T1.IELOTG,
T1.IESTDC,
T1.IEXSMC,
T1.IECSL,
T1.IEXSCR,
T1.IESCTC,
T1.IEXSFC,
T1.IESTFC,
T1.IEXSF,
T1.IERATS,
T1.IEXSRC,
T1.IERTSD,
T1.IEXSR,
T1.IEPFLG,
T1.IEUSER,
T1.IEPID,
T1.IEJOBN,
T1.IEUPMJ,
T1.IETDAY,
T1.IEOPSQ,
T1.IEMCUL,
T1.IEWMCU,
T1.IELDA,
T1.IETBM,
T1.IEACQ,
T1.IEF,
T2.COITM,
T2.COLITM,
T2.COAITM,
T2.COMCU,
T2.COLOCN,
T2.COLOTN,
T2.COLOTG,
T2.COLEDG,
T2.COUNCS,
T2.COCSPO,
T2.COCSIN,
T2.COURCD,
T2.COURDT,
T2.COURAT,
T2.COURAB,
T2.COURRF,
T2.COUSER,
T2.COPID,
T2.COJOBN,
T2.COUPMJ,
T2.COTDAY,
T2.COCCFL,
T2.COCRCS,
T2.COOSTC,
T2.COSTOC,
T3.MCMCU,
T3.MCSTYL,
T3.MCCO
FROM TESTDTA.F554101T T0,
TESTDTA.F30026 T1,
TESTDTA.F4105 T2,
TESTDTA.F0006 T3
WHERE ((T1.IEUPMJ >= 112160 AND T1.IELEDG = '07' AND T1.IECOST = 'A1' AND
T3.MCCO = '00100' OR T3.MCSTYL = 'BP' AND T3.MCSTYL = 'VP'))
AND (T0.CMITM = T1.IEITM AND T0.CMMCU = T1.IEMMCU AND
T1.IEITM = T2.COITM AND T1.IEMMCU = T2.COMCU AND
T1.IELEDG = T2.COLEDG AND T0.CMMCU = T3.MCMCU)
ORDER BY T2.COITM ASC, T2.COMCU ASC
T0.CMLITM,
T0.CMAITM,
T0.CMMCU,
T0.CMSRCCNTMJ,
T0.CMSRCCNTMI,
T1.IEITM,
T1.IELITM,
T1.IEAITM,
T1.IEMMCU,
T1.IELOCN,
T1.IELOTN,
T1.IELEDG,
T1.IECOST,
T1.IELOTG,
T1.IESTDC,
T1.IEXSMC,
T1.IECSL,
T1.IEXSCR,
T1.IESCTC,
T1.IEXSFC,
T1.IESTFC,
T1.IEXSF,
T1.IERATS,
T1.IEXSRC,
T1.IERTSD,
T1.IEXSR,
T1.IEPFLG,
T1.IEUSER,
T1.IEPID,
T1.IEJOBN,
T1.IEUPMJ,
T1.IETDAY,
T1.IEOPSQ,
T1.IEMCUL,
T1.IEWMCU,
T1.IELDA,
T1.IETBM,
T1.IEACQ,
T1.IEF,
T2.COITM,
T2.COLITM,
T2.COAITM,
T2.COMCU,
T2.COLOCN,
T2.COLOTN,
T2.COLOTG,
T2.COLEDG,
T2.COUNCS,
T2.COCSPO,
T2.COCSIN,
T2.COURCD,
T2.COURDT,
T2.COURAT,
T2.COURAB,
T2.COURRF,
T2.COUSER,
T2.COPID,
T2.COJOBN,
T2.COUPMJ,
T2.COTDAY,
T2.COCCFL,
T2.COCRCS,
T2.COOSTC,
T2.COSTOC,
T3.MCMCU,
T3.MCSTYL,
T3.MCCO
FROM TESTDTA.F554101T T0,
TESTDTA.F30026 T1,
TESTDTA.F4105 T2,
TESTDTA.F0006 T3
WHERE ((T1.IEUPMJ >= 112160 AND T1.IELEDG = '07' AND T1.IECOST = 'A1' AND
T3.MCCO = '00100' OR T3.MCSTYL = 'BP' AND T3.MCSTYL = 'VP'))
AND (T0.CMITM = T1.IEITM AND T0.CMMCU = T1.IEMMCU AND
T1.IEITM = T2.COITM AND T1.IEMMCU = T2.COMCU AND
T1.IELEDG = T2.COLEDG AND T0.CMMCU = T3.MCMCU)
ORDER BY T2.COITM ASC, T2.COMCU ASC
No comments:
Post a Comment