VIEW: APPS.PA_PROJ_UNBILLED_SUMMARY_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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