View: PA_XLA_BC_PKT_PO_HEADER_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_BC_PKT_PO_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 = 201
AND XEV.SOURCE_ID_INT_1 = DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, PBC.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, PBC.DOCUMENT_HEADER_ID_2
, PBC.DOCUMENT_HEADER_ID)
AND XEV.EVENT_ID = PBC.BC_EVENT_ID
AND PBC.BURDEN_COST_FLAG = 'N'
AND PBC.DOCUMENT_TYPE = 'PO'
AND PBC.STATUS_CODE = 'I'

Columns