View: PA_PROJ_INVOICE_SUMMARY_VIEW

Product:	PA - Projects
Description:	Summary revenue and invoice amounts for projects
Implementation/DBA Data:	APPS.PA_PROJ_INVOICE_SUMMARY_VIEW

View Text

SELECT A.PROJECT_ID
, SUM(NVL(A.BUDGET_REVENUE_AMOUNT
, 0))
, SUM(NVL(A.TOTAL_REVENUE_AMOUNT
, 0))
, SUM(NVL(A.WRITE_ON_REVENUE_AMOUNT
, 0))
, SUM(NVL(A.WRITE_OFF_REVENUE_AMOUNT
, 0))
, SUM(NVL(A.TOTAL_INVOICE_AMOUNT
, 0))
, SUM(NVL(A.TOTAL_RETENTION_AMOUNT
, 0))
, SUM(NVL(A.INVOICED_AMOUNT
, 0))
, SUM(NVL(A.ON_HOLD_AMOUNT
, 0))
, SUM(NVL(A.ON_HOLD_QUANTITY
, 0))
, SUM(NVL(A.TOTAL_REVENUE_AMOUNT
, 0)) - SUM(NVL(A.TOTAL_INVOICE_AMOUNT
, 0))
, SUM(NVL(A.WRITE_OFF_INVOICE_AMOUNT
, 0))
, SUM(NVL(A.PFC_INVOICED_AMOUNT
, 0))
, SUM(NVL(A.PFC_TOTAL_INVOICE_AMOUNT
, 0))
, SUM(NVL(A.PFC_WRITE_OFF_INVOICE_AMOUNT
, 0))
, SUM(NVL(A.UNBILLED_RETENTION
, 0))
FROM PA_PROJ_INVOICE_BASE_VIEW A GROUP BY A.PROJECT_ID

Columns