View: PA_RPT_PRJ_BGT_SUMMARY

Product:	PA - Projects
Description:	Displays summary project level budget information for Oracle Discoverer Workbooks.
Implementation/DBA Data:	APPS.PA_RPT_PRJ_BGT_SUMMARY

View Text

SELECT PAH.PROJECT_ACCUM_ID
, PAB.BUDGET_TYPE_CODE
, PAH.ACCUM_PERIOD
, PAB.BASE_RAW_COST_ITD
, PAB.BASE_RAW_COST_YTD
, PAB.BASE_RAW_COST_PP
, PAB.BASE_RAW_COST_PTD
, PAB.BASE_BURDENED_COST_ITD
, PAB.BASE_BURDENED_COST_YTD
, PAB.BASE_BURDENED_COST_PP
, PAB.BASE_BURDENED_COST_PTD
, PAB.ORIG_RAW_COST_ITD
, PAB.ORIG_RAW_COST_YTD
, PAB.ORIG_RAW_COST_PP
, PAB.ORIG_RAW_COST_PTD
, PAB.ORIG_BURDENED_COST_ITD
, PAB.ORIG_BURDENED_COST_YTD
, PAB.ORIG_BURDENED_COST_PP
, PAB.ORIG_BURDENED_COST_PTD
, PAB.BASE_REVENUE_ITD
, PAB.BASE_REVENUE_YTD
, PAB.BASE_REVENUE_PP
, PAB.BASE_REVENUE_PTD
, PAB.ORIG_REVENUE_ITD
, PAB.ORIG_REVENUE_YTD
, PAB.ORIG_REVENUE_PP
, PAB.ORIG_REVENUE_PTD
, PAB.ORIG_LABOR_HOURS_ITD
, PAB.ORIG_LABOR_HOURS_YTD
, PAB.ORIG_LABOR_HOURS_PP
, PAB.ORIG_LABOR_HOURS_PTD
, PAB.BASE_LABOR_HOURS_ITD
, PAB.BASE_LABOR_HOURS_YTD
, PAB.BASE_LABOR_HOURS_PP
, PAB.BASE_LABOR_HOURS_PTD
, PAB.ORIG_LABOR_HOURS_TOT
, PAB.BASE_LABOR_HOURS_TOT
, PAB.BASE_RAW_COST_TOT
, PAB.BASE_BURDENED_COST_TOT
, PAB.ORIG_RAW_COST_TOT
, PAB.ORIG_BURDENED_COST_TOT
, PAB.BASE_REVENUE_TOT
, PAB.ORIG_REVENUE_TOT
, PAH.PROJECT_ID
, PBT.BUDGET_AMOUNT_CODE
, PBT.BUDGET_TYPE
, PPA.ORG_ID
FROM PA_PROJECT_ACCUM_BUDGETS PAB
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECTS PPA
, PA_BUDGET_TYPES PBT
WHERE PAB.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
AND PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PAH.TASK_ID = 0
AND PAH.PROJECT_ID = PPA.PROJECT_ID

Columns