View: PA_RPT_PRJ_SUMMARY

Product:	PA - Projects
Description:	Reporting view which displays summary project level actuals, commitments and budgets.
Implementation/DBA Data:	APPS.PA_RPT_PRJ_SUMMARY

View Text

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

Columns