Thursday, September 29, 2011

Validate Transaction Nature


SELECT prkcoo, prdcto, pjbnop, pjbsop, COUNT(*) FROM qadta.F43121, qadta.F76432 WHERE
prdoco = pjdoco AND
prdcto = pjdcto AND
prkcoo = pjkcoo AND
prsfxo = pjsfxo AND
prlnid = pjlnid AND
prdgl <= 111243 AND
prmatc = 1 AND
pjbnop||pjbsop IN (SELECT trim(drky) FROM qactl.F0005 WHERE drsy = '55' AND drrt IN ('FA'))
--prlitm IN ( 'F194548', 'F194524', 'F194643','F194700')
GROUP BY prkcoo, prdcto, pjbnop, pjbsop

No comments:

Post a Comment