VIEW: APPS.PA_PROJ_BILLING_STATUS_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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