VIEW: APPS.PA_RPT_PRJ_SUMMARY

Source

View Text - Preformatted

SELECT project_id, project_accum_id, accum_period, 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), max(budget_type_code1), max(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), max(budget_type_code2), max(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), max(budget_type_code3), max(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), max(budget_type_code4), max(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), sum(cmt_raw_cost), sum(cmt_burdened_cost) FROM pa_rpt_prj_summary_base_v Group by project_id, project_accum_id, accum_period

View Text - HTML Formatted

SELECT PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, 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)
, MAX(BUDGET_TYPE_CODE1)
, MAX(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)
, MAX(BUDGET_TYPE_CODE2)
, MAX(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)
, MAX(BUDGET_TYPE_CODE3)
, MAX(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)
, MAX(BUDGET_TYPE_CODE4)
, MAX(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)
, SUM(CMT_RAW_COST)
, SUM(CMT_BURDENED_COST)
FROM PA_RPT_PRJ_SUMMARY_BASE_V GROUP BY PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD