Product: | PA - Projects |
---|---|
Description: | View to report billing status of projects. Full Description: is a view to report the billing status of projects. This view displays the project billing status as reported in the MGT: Project Billing Status report. |
Implementation/DBA Data: | APPS.PA_PROJ_BILLING_STATUS_VIEW |
SELECT MAX(BILLING_METHOD)
, PROJECT_ID
, MAX(PROJECT_NUMBER)
, MAX(PROJECT_NAME)
, MAX(RETN_ACCOUNTING_FLAG)
, MAX(LAST_RELEASED_INVOICE_NUM)
, MAX(LAST_RELEASED_INVOICE_DATE)
, MAX(LAST_RELEASED_BILL_THRU_DATE)
, SUM(NVL(DAYS_SINCE_LAST_RELEASE
, 0))
, MAX(NEXT_BILLING_DATE)
, SUM(NVL(NEXT_EVENT_AMOUNT
, 0))
, SUM(PENDING_INVOICE_AMOUNT)
, SUM(REVENUE_AMOUNT)
, SUM(INVOICE_AMOUNT)
, SUM(REVENUE_AMOUNT) - SUM(INVOICE_AMOUNT)
, SUM(NVL(NEXT_EVENT_PROJFUNC_AMOUNT
, 0))
, SUM(PENDING_PROJFUNC_INV_AMOUNT)
, SUM(PROJFUNC_REVENUE_AMOUNT)
, SUM(PROJFUNC_INVOICE_AMOUNT)
, SUM(PROJFUNC_REVENUE_AMOUNT) - SUM(PROJFUNC_TOTAL_INVOICED_AMOUNT) - DECODE(MAX(RETN_ACCOUNTING_FLAG)
, 'Y'
, 0
, SUM(PROJFUNC_UNBILLED_RETENTION))
, DECODE(MAX(RETN_ACCOUNTING_FLAG)
, 'N'
, 0
, -SUM(PROJFUNC_UNBILLED_RETENTION))
, MAX(ENABLE_TOP_TASK_INV_MTH_FLAG)
, MAX(EVENT_ID)
FROM PA_PROJ_BILLING_DETAIL_VIEW GROUP BY PROJECT_ID