View: PAFV_REVENUE_DISTRIBUTIONS

Product:	PA - Projects
Description:	This shows information about revenue distribution lines.
Implementation/DBA Data:	APPS.PAFV_REVENUE_DISTRIBUTIONS

View Text

SELECT PRDL.EXPENDITURE_ITEM_ID
, PRDL.LINE_NUM
, PDR.RELEASED_DATE
, PRDL.AMOUNT
, PRDL.FUNCTION_CODE
, PDR.PA_DATE
, PDR.GL_DATE
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PRDL.PROJECT_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_CHAR(NULL)
, PRDL.ORG_ID
, PRDL.CREATION_DATE
, PRDL.CREATED_BY
, '_LA:ADDITIONAL_REVENUE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
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 ALL SELECT TO_NUMBER(NULL)
, PERDL.LINE_NUM
, PDR.RELEASED_DATE
, PERDL.AMOUNT
, TO_CHAR(NULL)
, PDR.PA_DATE
, PDR.GL_DATE
, PDR.TRANSFERRED_DATE
, PDR.TRANSFER_REJECTION_REASON
, PDR.AGREEMENT_ID
, PERDL.PROJECT_ID
, PERDL.TASK_ID
, PERDL.EVENT_NUM
, PE.DESCRIPTION
, PERDL.ORG_ID
, PERDL.CREATION_DATE
, PERDL.CREATED_BY
, '_LA:TO_CHAR(NULL):FND_LOOKUPS:YES_NO:MEANING'
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFERSTATUS:MEANING'
FROM PA_CUST_EVENT_RDL_ALL PERDL
, PA_DRAFT_REVENUES_ALL PDR
, PA_EVENTS PE
WHERE PDR.PROJECT_ID = PERDL.PROJECT_ID
AND PDR.DRAFT_REVENUE_NUM = PERDL.DRAFT_REVENUE_NUM
AND NVL(PERDL.TASK_ID
, -1) = NVL(PE.TASK_ID
, -1)
AND PERDL.EVENT_NUM = PE.EVENT_NUM
AND PERDL.PROJECT_ID = PE.PROJECT_ID
AND '_SEC:PERDL.ORG_ID' IS NOT NULL WITH READ ONLY

Columns