VIEW: APPS.PA_XLA_BC_PKT_AP_HEADER_V

Source

View Text - Preformatted

SELECT distinct Xev.event_id, Xev.source_id_int_1, Xev.event_date From Xla_Events_GT xev, pa_bc_packets pbc WHERE Xev.application_id = 200 And Xev.source_id_int_1 = Pbc.document_header_id And Xev.event_id = pbc.bc_event_id And Pbc.burden_cost_flag = 'N' And Pbc.document_type = 'AP' And Pbc.Status_Code = 'I'

View Text - HTML Formatted

SELECT DISTINCT XEV.EVENT_ID
, XEV.SOURCE_ID_INT_1
, XEV.EVENT_DATE
FROM XLA_EVENTS_GT XEV
, PA_BC_PACKETS PBC
WHERE XEV.APPLICATION_ID = 200
AND XEV.SOURCE_ID_INT_1 = PBC.DOCUMENT_HEADER_ID
AND XEV.EVENT_ID = PBC.BC_EVENT_ID
AND PBC.BURDEN_COST_FLAG = 'N'
AND PBC.DOCUMENT_TYPE = 'AP'
AND PBC.STATUS_CODE = 'I'