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_ACCUM_RSRC_COST_BGT_BASE_V

Product:	PA - Projects
Description:	A base view that shows project and task level resource amounts
Implementation/DBA Data:	APPS.PA_ACCUM_RSRC_COST_BGT_BASE_V

View Text

SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.RESOURCE_LIST_MEMBER_ID
, RLM.PARENT_MEMBER_ID
, PAB.BUDGET_TYPE_CODE
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, 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.BASE_QUANTITY_ITD
, 0)
, NVL(PAB.BASE_QUANTITY_YTD
, 0)
, NVL(PAB.BASE_QUANTITY_PP
, 0)
, NVL(PAB.BASE_QUANTITY_PTD
, 0)
, NVL(PAB.ORIG_QUANTITY_ITD
, 0)
, NVL(PAB.ORIG_QUANTITY_YTD
, 0)
, NVL(PAB.ORIG_QUANTITY_PP
, 0)
, NVL(PAB.ORIG_QUANTITY_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_QUANTITY_TOT
, 0)
, NVL(PAB.ORIG_QUANTITY_TOT
, 0)
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_PROJECT_ACCUM_BUDGETS PAB
, PA_BUDGET_TYPES BT
WHERE RLM.RESOURCE_LIST_MEMBER_ID = PAH.RESOURCE_LIST_MEMBER_ID
AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
AND PAB.BUDGET_TYPE_CODE = BT.BUDGET_TYPE_CODE
AND BT.BUDGET_AMOUNT_CODE = 'C'
AND PAB.FIN_PLAN_TYPE_ID IS NULL UNION SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.PARENT_MEMBER_ID
, NULL+0
, PAB.BUDGET_TYPE_CODE
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(PAB.BASE_RAW_COST_ITD
, 0))
, SUM(NVL(PAB.BASE_RAW_COST_YTD
, 0))
, SUM(NVL(PAB.BASE_RAW_COST_PP
, 0))
, SUM(NVL(PAB.BASE_RAW_COST_PTD
, 0))
, SUM(NVL(PAB.BASE_BURDENED_COST_ITD
, 0))
, SUM(NVL(PAB.BASE_BURDENED_COST_YTD
, 0))
, SUM(NVL(PAB.BASE_BURDENED_COST_PP
, 0))
, SUM(NVL(PAB.BASE_BURDENED_COST_PTD
, 0))
, SUM(NVL(PAB.ORIG_RAW_COST_ITD
, 0))
, SUM(NVL(PAB.ORIG_RAW_COST_YTD
, 0))
, SUM(NVL(PAB.ORIG_RAW_COST_PP
, 0))
, SUM(NVL(PAB.ORIG_RAW_COST_PTD
, 0))
, SUM(NVL(PAB.ORIG_BURDENED_COST_ITD
, 0))
, SUM(NVL(PAB.ORIG_BURDENED_COST_YTD
, 0))
, SUM(NVL(PAB.ORIG_BURDENED_COST_PP
, 0))
, SUM(NVL(PAB.ORIG_BURDENED_COST_PTD
, 0))
, SUM(NVL(PAB.BASE_QUANTITY_ITD
, 0))
, SUM(NVL(PAB.BASE_QUANTITY_YTD
, 0))
, SUM(NVL(PAB.BASE_QUANTITY_PP
, 0))
, SUM(NVL(PAB.BASE_QUANTITY_PTD
, 0))
, SUM(NVL(PAB.ORIG_QUANTITY_ITD
, 0))
, SUM(NVL(PAB.ORIG_QUANTITY_YTD
, 0))
, SUM(NVL(PAB.ORIG_QUANTITY_PP
, 0))
, SUM(NVL(PAB.ORIG_QUANTITY_PTD
, 0))
, SUM(NVL(PAB.ORIG_LABOR_HOURS_ITD
, 0))
, SUM(NVL(PAB.ORIG_LABOR_HOURS_YTD
, 0))
, SUM(NVL(PAB.ORIG_LABOR_HOURS_PP
, 0))
, SUM(NVL(PAB.ORIG_LABOR_HOURS_PTD
, 0))
, SUM(NVL(PAB.BASE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(PAB.BASE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(PAB.BASE_LABOR_HOURS_PP
, 0))
, SUM(NVL(PAB.BASE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(PAB.BASE_RAW_COST_TOT
, 0))
, SUM(NVL(PAB.BASE_BURDENED_COST_TOT
, 0))
, SUM(NVL(PAB.ORIG_RAW_COST_TOT
, 0))
, SUM(NVL(PAB.ORIG_BURDENED_COST_TOT
, 0))
, SUM(NVL(PAB.ORIG_LABOR_HOURS_TOT
, 0))
, SUM(NVL(PAB.BASE_LABOR_HOURS_TOT
, 0))
, SUM(NVL(PAB.BASE_QUANTITY_TOT
, 0))
, SUM(NVL(PAB.ORIG_QUANTITY_TOT
, 0))
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_PROJECT_ACCUM_BUDGETS PAB
, PA_BUDGET_TYPES BT
WHERE RLM.PARENT_MEMBER_ID IS NOT NULL
AND RLM.RESOURCE_LIST_MEMBER_ID = PAH.RESOURCE_LIST_MEMBER_ID
AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
AND PAB.BUDGET_TYPE_CODE = BT.BUDGET_TYPE_CODE
AND BT.BUDGET_AMOUNT_CODE = 'C'
AND PAB.FIN_PLAN_TYPE_ID IS NULL GROUP BY PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.PARENT_MEMBER_ID
, PAB.BUDGET_TYPE_CODE
, PAH.RESOURCE_LIST_ASSIGNMENT_ID

Columns

Name
PROJECT_ID
TASK_ID
RESOURCE_LIST_MEMBER_ID
PARENT_MEMBER_ID
BUDGET_TYPE_CODE
RESOURCE_LIST_ASSIGNMENT_ID
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
BASELINE_QUANTITY_ITD
BASELINE_QUANTITY_YTD
BASELINE_QUANTITY_PP
BASELINE_QUANTITY_PTD
ORIGINAL_QUANTITY_ITD
ORIGINAL_QUANTITY_YTD
ORIGINAL_QUANTITY_PP
ORIGINAL_QUANTITY_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_QUANTITY_TOT
ORIGINAL_QUANTITY_TOT