View: PA_RPT_CUST_SUMMARY

Product:	PA - Projects
Description:	Reporting view which displays summary project level actuals and budgets by customers.
Implementation/DBA Data:	APPS.PA_RPT_CUST_SUMMARY

View Text

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

Columns