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.

VIEW: APPS.PA_RPT_CUST_SUMMARY

Source

View Text - Preformatted


SELECT project_id, project_accum_id, accum_period, customer_id, sum(raw_cost_itd), sum(raw_cost_ytd), sum(raw_cost_ptd), sum(billable_raw_cost_itd), sum(billable_raw_cost_ytd), sum(billable_raw_cost_ptd), sum(burdened_cost_itd), sum(burdened_cost_ytd), sum(burdened_cost_ptd), sum(billable_burdened_cost_itd), sum(billable_burdened_cost_ytd), sum(billable_burdened_cost_ptd), sum(revenue_itd), sum(revenue_ytd), sum(revenue_ptd), sum(labor_hours_itd), sum(labor_hours_ytd), sum(labor_hours_ptd), sum(billable_labor_hours_itd), sum(billable_labor_hours_ytd), sum(billable_labor_hours_ptd), budget_type_code1, budget_type1, sum(base_raw_cost_itd1), sum(base_raw_cost_ytd1), sum(base_raw_cost_ptd1), sum(base_raw_cost_tot1), sum(orig_raw_cost_itd1), sum(orig_raw_cost_ytd1), sum(orig_raw_cost_ptd1), sum(orig_raw_cost_tot1), sum(base_burdened_cost_itd1), sum(base_burdened_cost_ytd1), sum(base_burdened_cost_ptd1), sum(base_burdened_cost_tot1), sum(orig_burdened_cost_itd1), sum(orig_burdened_cost_ytd1), sum(orig_burdened_cost_ptd1), sum(orig_burdened_cost_tot1), sum(orig_labor_hours_itd1), sum(orig_labor_hours_ytd1), sum(orig_labor_hours_ptd1), sum(orig_labor_hours_tot1), sum(base_labor_hours_itd1), sum(base_labor_hours_ytd1), sum(base_labor_hours_ptd1), sum(base_labor_hours_tot1), budget_type_code2, budget_type2, sum(base_raw_cost_itd2), sum(base_raw_cost_ytd2), sum(base_raw_cost_ptd2), sum(base_raw_cost_tot2), sum(orig_raw_cost_itd2), sum(orig_raw_cost_ytd2), sum(orig_raw_cost_ptd2), sum(orig_raw_cost_tot2), sum(base_burdened_cost_itd2), sum(base_burdened_cost_ytd2), sum(base_burdened_cost_ptd2), sum(base_burdened_cost_tot2), sum(orig_burdened_cost_itd2), sum(orig_burdened_cost_ytd2), sum(orig_burdened_cost_ptd2), sum(orig_burdened_cost_tot2), sum(orig_labor_hours_itd2), sum(orig_labor_hours_ytd2), sum(orig_labor_hours_ptd2), sum(orig_labor_hours_tot2), sum(base_labor_hours_itd2), sum(base_labor_hours_ytd2), sum(base_labor_hours_ptd2), sum(base_labor_hours_tot2), budget_type_code3, budget_type3, sum(base_revenue_itd3), sum(base_revenue_ytd3), sum(base_revenue_ptd3), sum(base_revenue_tot3), sum(orig_revenue_itd3), sum(orig_revenue_ytd3), sum(orig_revenue_ptd3), sum(orig_revenue_tot3), sum(orig_labor_hours_itd3), sum(orig_labor_hours_ytd3), sum(orig_labor_hours_ptd3), sum(orig_labor_hours_tot3), sum(base_labor_hours_itd3), sum(base_labor_hours_ytd3), sum(base_labor_hours_ptd3), sum(base_labor_hours_tot3), budget_type_code4, budget_type4, sum(base_revenue_itd4), sum(base_revenue_ytd4), sum(base_revenue_ptd4), sum(base_revenue_tot4), sum(orig_revenue_itd4), sum(orig_revenue_ytd4), sum(orig_revenue_ptd4), sum(orig_revenue_tot4), sum(orig_labor_hours_itd4), sum(orig_labor_hours_ytd4), sum(orig_labor_hours_ptd4), sum(orig_labor_hours_tot4), sum(base_labor_hours_itd4), sum(base_labor_hours_ytd4), sum(base_labor_hours_ptd4), sum(base_labor_hours_tot4) FROM pa_rpt_cust_summary_base_v Group by project_id, project_accum_id, accum_period, customer_id, budget_type_code1, budget_type1, budget_type_code2, budget_type2, budget_type_code3, budget_type3, budget_type_code4, budget_type4

View Text - HTML Formatted

SELECT PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, SUM(RAW_COST_ITD)
, SUM(RAW_COST_YTD)
, SUM(RAW_COST_PTD)
, SUM(BILLABLE_RAW_COST_ITD)
, SUM(BILLABLE_RAW_COST_YTD)
, SUM(BILLABLE_RAW_COST_PTD)
, SUM(BURDENED_COST_ITD)
, SUM(BURDENED_COST_YTD)
, SUM(BURDENED_COST_PTD)
, SUM(BILLABLE_BURDENED_COST_ITD)
, SUM(BILLABLE_BURDENED_COST_YTD)
, SUM(BILLABLE_BURDENED_COST_PTD)
, SUM(REVENUE_ITD)
, SUM(REVENUE_YTD)
, SUM(REVENUE_PTD)
, SUM(LABOR_HOURS_ITD)
, SUM(LABOR_HOURS_YTD)
, SUM(LABOR_HOURS_PTD)
, SUM(BILLABLE_LABOR_HOURS_ITD)
, SUM(BILLABLE_LABOR_HOURS_YTD)
, SUM(BILLABLE_LABOR_HOURS_PTD)
, BUDGET_TYPE_CODE1
, BUDGET_TYPE1
, SUM(BASE_RAW_COST_ITD1)
, SUM(BASE_RAW_COST_YTD1)
, SUM(BASE_RAW_COST_PTD1)
, SUM(BASE_RAW_COST_TOT1)
, SUM(ORIG_RAW_COST_ITD1)
, SUM(ORIG_RAW_COST_YTD1)
, SUM(ORIG_RAW_COST_PTD1)
, SUM(ORIG_RAW_COST_TOT1)
, SUM(BASE_BURDENED_COST_ITD1)
, SUM(BASE_BURDENED_COST_YTD1)
, SUM(BASE_BURDENED_COST_PTD1)
, SUM(BASE_BURDENED_COST_TOT1)
, SUM(ORIG_BURDENED_COST_ITD1)
, SUM(ORIG_BURDENED_COST_YTD1)
, SUM(ORIG_BURDENED_COST_PTD1)
, SUM(ORIG_BURDENED_COST_TOT1)
, SUM(ORIG_LABOR_HOURS_ITD1)
, SUM(ORIG_LABOR_HOURS_YTD1)
, SUM(ORIG_LABOR_HOURS_PTD1)
, SUM(ORIG_LABOR_HOURS_TOT1)
, SUM(BASE_LABOR_HOURS_ITD1)
, SUM(BASE_LABOR_HOURS_YTD1)
, SUM(BASE_LABOR_HOURS_PTD1)
, SUM(BASE_LABOR_HOURS_TOT1)
, BUDGET_TYPE_CODE2
, BUDGET_TYPE2
, SUM(BASE_RAW_COST_ITD2)
, SUM(BASE_RAW_COST_YTD2)
, SUM(BASE_RAW_COST_PTD2)
, SUM(BASE_RAW_COST_TOT2)
, SUM(ORIG_RAW_COST_ITD2)
, SUM(ORIG_RAW_COST_YTD2)
, SUM(ORIG_RAW_COST_PTD2)
, SUM(ORIG_RAW_COST_TOT2)
, SUM(BASE_BURDENED_COST_ITD2)
, SUM(BASE_BURDENED_COST_YTD2)
, SUM(BASE_BURDENED_COST_PTD2)
, SUM(BASE_BURDENED_COST_TOT2)
, SUM(ORIG_BURDENED_COST_ITD2)
, SUM(ORIG_BURDENED_COST_YTD2)
, SUM(ORIG_BURDENED_COST_PTD2)
, SUM(ORIG_BURDENED_COST_TOT2)
, SUM(ORIG_LABOR_HOURS_ITD2)
, SUM(ORIG_LABOR_HOURS_YTD2)
, SUM(ORIG_LABOR_HOURS_PTD2)
, SUM(ORIG_LABOR_HOURS_TOT2)
, SUM(BASE_LABOR_HOURS_ITD2)
, SUM(BASE_LABOR_HOURS_YTD2)
, SUM(BASE_LABOR_HOURS_PTD2)
, SUM(BASE_LABOR_HOURS_TOT2)
, BUDGET_TYPE_CODE3
, BUDGET_TYPE3
, SUM(BASE_REVENUE_ITD3)
, SUM(BASE_REVENUE_YTD3)
, SUM(BASE_REVENUE_PTD3)
, SUM(BASE_REVENUE_TOT3)
, SUM(ORIG_REVENUE_ITD3)
, SUM(ORIG_REVENUE_YTD3)
, SUM(ORIG_REVENUE_PTD3)
, SUM(ORIG_REVENUE_TOT3)
, SUM(ORIG_LABOR_HOURS_ITD3)
, SUM(ORIG_LABOR_HOURS_YTD3)
, SUM(ORIG_LABOR_HOURS_PTD3)
, SUM(ORIG_LABOR_HOURS_TOT3)
, SUM(BASE_LABOR_HOURS_ITD3)
, SUM(BASE_LABOR_HOURS_YTD3)
, SUM(BASE_LABOR_HOURS_PTD3)
, SUM(BASE_LABOR_HOURS_TOT3)
, BUDGET_TYPE_CODE4
, BUDGET_TYPE4
, SUM(BASE_REVENUE_ITD4)
, SUM(BASE_REVENUE_YTD4)
, SUM(BASE_REVENUE_PTD4)
, SUM(BASE_REVENUE_TOT4)
, SUM(ORIG_REVENUE_ITD4)
, SUM(ORIG_REVENUE_YTD4)
, SUM(ORIG_REVENUE_PTD4)
, SUM(ORIG_REVENUE_TOT4)
, SUM(ORIG_LABOR_HOURS_ITD4)
, SUM(ORIG_LABOR_HOURS_YTD4)
, SUM(ORIG_LABOR_HOURS_PTD4)
, SUM(ORIG_LABOR_HOURS_TOT4)
, SUM(BASE_LABOR_HOURS_ITD4)
, SUM(BASE_LABOR_HOURS_YTD4)
, SUM(BASE_LABOR_HOURS_PTD4)
, SUM(BASE_LABOR_HOURS_TOT4)
FROM PA_RPT_CUST_SUMMARY_BASE_V GROUP BY PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, BUDGET_TYPE_CODE1
, BUDGET_TYPE1
, BUDGET_TYPE_CODE2
, BUDGET_TYPE2
, BUDGET_TYPE_CODE3
, BUDGET_TYPE3
, BUDGET_TYPE_CODE4
, BUDGET_TYPE4