View: PABV_REVENUE_DISTRIBUTIONS

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

View Text

SELECT PRDL.EXPENDITURE_ITEM_ID
, PRDL.LINE_NUM
, PDR.RELEASED_DATE
, PRDL.AMOUNT
, '_LA:ADDITIONAL_REVENUE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PRDL.FUNCTION_CODE
, PDR.PA_DATE
, PDR.GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PRDL.PROJECT_ID
, TO_NUMBER(NULL) /* TASK ID */
, TO_NUMBER(NULL) /* EVENT NUMBER*/
, PRDL.ORG_ID /* OPERATING UNIT */
, PRDL.CREATION_DATE
, PRDL.CREATED_BY
FROM PA_CUST_REV_DIST_LINES_ALL PRDL
, PA_DRAFT_REVENUES_ALL PDR
WHERE PDR.PROJECT_ID = PRDL.PROJECT_ID
AND PDR.DRAFT_REVENUE_NUM = PRDL.DRAFT_REVENUE_NUM
AND '_SEC:PRDL.ORG_ID' IS NOT NULL UNION SELECT TO_NUMBER(NULL) /* EXPENDITURE ITEM ID */
, PERDL.LINE_NUM
, PDR.RELEASED_DATE
, PERDL.AMOUNT
, '_LA:TO_CHAR(NULL):FND_LOOKUPS:YES_NO:MEANING'
, TO_CHAR(NULL) /* FUNCTION CODE */
, PDR.PA_DATE
, PDR.GL_DATE
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFERSTATUS:MEANING'
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PERDL.PROJECT_ID
, PERDL.TASK_ID
, PERDL.EVENT_NUM
, PERDL.ORG_ID /* OPERATING UNIT */
, PERDL.CREATION_DATE
, PERDL.CREATED_BY
FROM PA_CUST_EVENT_RDL_ALL PERDL
, PA_DRAFT_REVENUES_ALL PDR
WHERE PDR.PROJECT_ID = PERDL.PROJECT_ID
AND PDR.DRAFT_REVENUE_NUM = PERDL.DRAFT_REVENUE_NUM
AND '_SEC:PERDL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns