SELECT DISTINCT PBD.AE_EVENT_ID, PBD.HEADER_ID, PBD.REFERENCE1, PBD.SEGMENT1, PBD.PO_RELEASE_ID, PBD.ENCUMBRANCE_TYPE_ID, PBD.GL_DATE FROM PO_BC_DISTRIBUTIONS PBD, XLA_EVENTS_GT XEG WHERE XEG.EVENT_ID = PBD.AE_EVENT_ID AND PBD.MAIN_OR_BACKING_CODE = 'M'
SELECT DISTINCT PBD.AE_EVENT_ID
, PBD.HEADER_ID
, PBD.REFERENCE1
, PBD.SEGMENT1
, PBD.PO_RELEASE_ID
, PBD.ENCUMBRANCE_TYPE_ID
, PBD.GL_DATE
FROM PO_BC_DISTRIBUTIONS PBD
, XLA_EVENTS_GT XEG
WHERE XEG.EVENT_ID = PBD.AE_EVENT_ID
AND PBD.MAIN_OR_BACKING_CODE = 'M'
|
|
|