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.

[Home] [Help]

View: PA_PROJECT_ACCUM_BUDGETS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECT_ACCUM_BUDGETS_V

View Text

SELECT PAB.PROJECT_ACCUM_ID
, PAB.BUDGET_TYPE_CODE
, NVL(PAB.BASE_RAW_COST_ITD
, 0)
, NVL(PAB.BASE_RAW_COST_YTD
, 0)
, NVL(PAB.BASE_RAW_COST_PP
, 0)
, NVL(PAB.BASE_RAW_COST_PTD
, 0)
, NVL(PAB.BASE_BURDENED_COST_ITD
, 0)
, NVL(PAB.BASE_BURDENED_COST_YTD
, 0)
, NVL(PAB.BASE_BURDENED_COST_PP
, 0)
, NVL(PAB.BASE_BURDENED_COST_PTD
, 0)
, NVL(PAB.ORIG_RAW_COST_ITD
, 0)
, NVL(PAB.ORIG_RAW_COST_YTD
, 0)
, NVL(PAB.ORIG_RAW_COST_PP
, 0)
, NVL(PAB.ORIG_RAW_COST_PTD
, 0)
, NVL(PAB.ORIG_BURDENED_COST_ITD
, 0)
, NVL(PAB.ORIG_BURDENED_COST_YTD
, 0)
, NVL(PAB.ORIG_BURDENED_COST_PP
, 0)
, NVL(PAB.ORIG_BURDENED_COST_PTD
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_ITD
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_YTD
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_PP
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_PTD
, 0)
, NVL(PAB.BASE_LABOR_HOURS_ITD
, 0)
, NVL(PAB.BASE_LABOR_HOURS_YTD
, 0)
, NVL(PAB.BASE_LABOR_HOURS_PP
, 0)
, NVL(PAB.BASE_LABOR_HOURS_PTD
, 0)
, NVL(PAB.BASE_RAW_COST_TOT
, 0)
, NVL(PAB.BASE_BURDENED_COST_TOT
, 0)
, NVL(PAB.ORIG_RAW_COST_TOT
, 0)
, NVL(PAB.ORIG_BURDENED_COST_TOT
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_TOT
, 0)
, NVL(PAB.BASE_LABOR_HOURS_TOT
, 0)
, NVL(PAB.BASE_REVENUE_ITD
, 0)
, NVL(PAB.BASE_REVENUE_YTD
, 0)
, NVL(PAB.BASE_REVENUE_PP
, 0)
, NVL(PAB.BASE_REVENUE_PTD
, 0)
, NVL(PAB.ORIG_REVENUE_ITD
, 0)
, NVL(PAB.ORIG_REVENUE_YTD
, 0)
, NVL(PAB.ORIG_REVENUE_PP
, 0)
, NVL(PAB.ORIG_REVENUE_PTD
, 0)
, NVL(PAB.BASE_REVENUE_TOT
, 0)
, NVL(PAB.ORIG_REVENUE_TOT
, 0)
FROM PA_PROJECT_ACCUM_BUDGETS PAB

Columns

Name
PROJECT_ACCUM_ID
BUDGET_TYPE_CODE
BASELINE_RAW_COST_ITD
BASELINE_RAW_COST_YTD
BASELINE_RAW_COST_PP
BASELINE_RAW_COST_PTD
BASELINE_BURDENED_COST_ITD
BASELINE_BURDENED_COST_YTD
BASELINE_BURDENED_COST_PP
BASELINE_BURDENED_COST_PTD
ORIGINAL_RAW_COST_ITD
ORIGINAL_RAW_COST_YTD
ORIGINAL_RAW_COST_PP
ORIGINAL_RAW_COST_PTD
ORIGINAL_BURDENED_COST_ITD
ORIGINAL_BURDENED_COST_YTD
ORIGINAL_BURDENED_COST_PP
ORIGINAL_BURDENED_COST_PTD
ORIGINAL_LABOR_HOURS_ITD
ORIGINAL_LABOR_HOURS_YTD
ORIGINAL_LABOR_HOURS_PP
ORIGINAL_LABOR_HOURS_PTD
BASELINE_LABOR_HOURS_ITD
BASELINE_LABOR_HOURS_YTD
BASELINE_LABOR_HOURS_PP
BASELINE_LABOR_HOURS_PTD
BASELINE_RAW_COST_TOT
BASELINE_BURDENED_COST_TOT
ORIGINAL_RAW_COST_TOT
ORIGINAL_BURDENED_COST_TOT
ORIGINAL_LABOR_HOURS_TOT
BASELINE_LABOR_HOURS_TOT
BASELINE_REVENUE_ITD
BASELINE_REVENUE_YTD
BASELINE_REVENUE_PP
BASELINE_REVENUE_PTD
ORIGINAL_REVENUE_ITD
ORIGINAL_REVENUE_YTD
ORIGINAL_REVENUE_PP
ORIGINAL_REVENUE_PTD
BASELINE_REVENUE_TOT
ORIGINAL_REVENUE_TOT