Wednesday, April 11, 2012

Transaction Nature not in UDC 55|FA


SELECT *
  FROM proddta.f43121, proddta.f76432
 WHERE prdoco = pjdoco
   AND prdcto = pjdcto
   AND prkcoo = pjkcoo
   AND prlnid = pjlnid
   AND prsfxo = pjsfxo
   AND prmatc IN ('1', '2')
   and not exists (select * from prodctl.F0005 where drsy = '55' and drrt = 'FA' and trim(drky) = (trim(pjbnop)||trim(pjbsop)))

No comments:

Post a Comment