View: PA_PROJ_UNBILLED_SUMMARY_VIEW

Product:	PA - Projects
Description:	Summary unbilled and billing hold amounts for projects
Implementation/DBA Data:	APPS.PA_PROJ_UNBILLED_SUMMARY_VIEW

View Text

SELECT PROJECT_ID
, SUM(UNBILLED_ITEM_AMOUNT)
, SUM(UNBILLED_ITEM_QUANTITY)
, SUM(ON_HOLD_AMOUNT)
, SUM(ON_HOLD_QUANTITY)
, SUM(ONE_TIME_HOLD_AMOUNT)
, SUM(ONE_TIME_HOLD_QUANTITY)
, SUM(UNBILLED_EVENT_AMOUNT)
, SUM(ITEM_CURRENCY_COUNT)
, MAX(ITEM_CURRENCY_CODE)
, SUM(UB_ITEM_BILL_TRANS_AMOUNT)
, SUM(ON_HOLD_BILL_TRANS_AMOUNT)
, SUM(ONETIME_HLD_BILL_TRANS_AMOUNT)
FROM PA_PROJ_UNBILLED_BASE_VIEW GROUP BY PROJECT_ID

Columns