View: PA_XLA_REVENUE_HEADERS_V

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

View Text

SELECT DRL.EVENT_ID
, DRL.AGREEMENT_ID
, DRL.ACCRUE_THROUGH_DATE
, DRL.RELEASED_DATE
, DRL.GL_DATE
, DECODE(DRL.DRAFT_REVENUE_NUM_CREDITED
, NULL
, 'N'
, 'Y')
, DRL.UNEARNED_CODE_COMBINATION_ID
, DRL.UNBILLED_CODE_COMBINATION_ID
FROM PA_DRAFT_REVENUES_ALL DRL
, XLA_EVENTS_GT XEV
WHERE XEV.APPLICATION_ID = 275
AND XEV.SOURCE_ID_INT_1 = DRL.PROJECT_ID
AND XEV.SOURCE_ID_INT_2 = DRL.DRAFT_REVENUE_NUM
AND DRL.EVENT_ID IS NOT NULL
AND DRL.TRANSFER_STATUS_CODE = 'A'

Columns