eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_PROJ_BILLING_STATUS_VIEW_O

Product:	PA - Projects
Description:	View to report billing status of projects
Implementation/DBA Data:	Not implemented in this database

View Text

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)
FROM PA_PROJ_BILLING_DETAIL_VIEW GROUP BY PROJECT_ID

Columns

Name
BILLING_METHOD
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
RETN_ACCOUNTING_FLAG
LAST_RELEASED_INVOICE_NUM
LAST_RELEASED_INVOICE_DATE
LAST_RELEASED_BILL_THRU_DATE
DAYS_SINCE_LAST_RELEASE
NEXT_BILLING_DATE
NEXT_EVENT_AMOUNT
PENDING_INVOICE_AMOUNT
REVENUE_AMOUNT
INVOICE_AMOUNT
UNBILLED_RECEIVABLE_AMOUNT
NEXT_EVENT_PROJFUNC_AMOUNT
PENDING_PROJFUNC_INV_AMOUNT
PROJFUNC_REVENUE_AMOUNT
PROJFUNC_INVOICE_AMOUNT
PROJFUNC_UBR_AMOUNT
PROJFUNC_UNBILLED_RETENTION
ENABLE_TOP_TASK_INV_MTH_FLAG