View: PA_BILLING_REV_TRANSACTIONS_V

Product:	PA - Projects
Description:	Returns detail information for amounts processed in the current run of revenue generation.
Implementation/DBA Data:	APPS.PA_BILLING_REV_TRANSACTIONS_V

View Text

SELECT T.PROJECT_ID
, T.TASK_ID
, T.TOP_TASK_ID
, EI.EXPENDITURE_TYPE
, EI.SYSTEM_LINKAGE_FUNCTION
, EXP.EXPENDITURE_ID
, EXP.INCURRED_BY_PERSON_ID
, EI.EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE
, EI.QUANTITY
, EI.RAW_COST
, EI.BURDEN_COST
, SUM(RDL.BILL_AMOUNT)
, SUM(RDL.AMOUNT)
, EI.PROJECT_CURRENCY_CODE
FROM PA_EXPENDITURES_ALL EXP
, PA_TASKS T
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_CUST_REV_DIST_LINES_ALL RDL
, PA_DRAFT_REVENUE_ITEMS DRI
, PA_DRAFT_REVENUES DR
WHERE EI.EXPENDITURE_ID = EXP.EXPENDITURE_ID
AND EI.TASK_ID = T.TASK_ID
AND DR.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, T.PROJECT_ID)
AND T.PROJECT_ID = RDL.PROJECT_ID
AND T.TOP_TASK_ID = NVL(PA_BILLING.GETTASKID
, T.TOP_TASK_ID)
AND DRI.REQUEST_ID = NVL(PA_BILLING.GETREQID
, DRI.REQUEST_ID)
AND EI.EXPENDITURE_ITEM_ID = RDL.EXPENDITURE_ITEM_ID
AND DRI.PROJECT_ID = DR.PROJECT_ID
AND DRI.DRAFT_REVENUE_NUM = DR.DRAFT_REVENUE_NUM
AND DRI.PROJECT_ID = RDL.PROJECT_ID
AND DRI.DRAFT_REVENUE_NUM = RDL.DRAFT_REVENUE_NUM
AND DRI.LINE_NUM = RDL.DRAFT_REVENUE_ITEM_LINE_NUM
AND ((PA_BILLING.GETCALLPLACE = 'ADJ'
AND DR.DRAFT_REVENUE_NUM_CREDITED IS NOT NULL) OR (NVL(PA_BILLING.GETCALLPLACE
, 'REG') = 'REG'
AND DR.DRAFT_REVENUE_NUM_CREDITED IS NULL)) GROUP BY T.PROJECT_ID
, T.TASK_ID
, T.TOP_TASK_ID
, EI.EXPENDITURE_TYPE
, EI.SYSTEM_LINKAGE_FUNCTION
, EXP.EXPENDITURE_ID
, EXP.INCURRED_BY_PERSON_ID
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_ITEM_ID
, EI.QUANTITY
, EI.RAW_COST
, EI.BURDEN_COST
, EI.PROJECT_CURRENCY_CODE

Columns