View: PA_BILLING_INV_TRANSACTIONS_V

Product:	PA - Projects
Description:	Returns detail information for amount processed in the current run
Implementation/DBA Data:	APPS.PA_BILLING_INV_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_INVOICE_ITEMS PDII
, PA_DRAFT_INVOICES PDI
WHERE EI.TASK_ID = T.TASK_ID
AND EI.EXPENDITURE_ID = EXP.EXPENDITURE_ID
AND T.TOP_TASK_ID = NVL(PA_BILLING.GETTASKID
, T.TOP_TASK_ID)
AND PDI.PROJECT_ID = NVL(PA_BILLING.GETPROJID
, PDI.PROJECT_ID)
AND PDII.PROJECT_ID = RDL.PROJECT_ID
AND PDII.DRAFT_INVOICE_NUM = RDL.DRAFT_INVOICE_NUM
AND PDII.LINE_NUM = RDL.DRAFT_INVOICE_ITEM_LINE_NUM
AND PDII.INVOICE_LINE_TYPE <> 'NET ZERO ADJUSTMENT'
AND PDII.PROJECT_ID = PDI.PROJECT_ID
AND PDII.DRAFT_INVOICE_NUM = PDI.DRAFT_INVOICE_NUM
AND PDI.REQUEST_ID = NVL(PA_BILLING.GETREQID
, PDI.REQUEST_ID)
AND EI.EXPENDITURE_ITEM_ID = RDL.EXPENDITURE_ITEM_ID
AND ((PA_BILLING.GETCALLPLACE = 'ADJ'
AND PDI.DRAFT_INVOICE_NUM_CREDITED IS NOT NULL) OR (NVL(PA_BILLING.GETCALLPLACE
, 'REG') = 'REG'
AND PDI.DRAFT_INVOICE_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