View: PA_XLA_BC_PKT_AP_HEADER_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_BC_PKT_AP_HEADER_V

View Text

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'

Columns