View: PA_ACCUM_RSRC_REV_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_REV_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_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_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_REVENUE_TOT
, 0)
, NVL(PAB.ORIG_REVENUE_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 = 'R'
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_REVENUE_ITD
, 0))
, SUM(NVL(PAB.BASE_REVENUE_YTD
, 0))
, SUM(NVL(PAB.BASE_REVENUE_PP
, 0))
, SUM(NVL(PAB.BASE_REVENUE_PTD
, 0))
, SUM(NVL(PAB.ORIG_REVENUE_ITD
, 0))
, SUM(NVL(PAB.ORIG_REVENUE_YTD
, 0))
, SUM(NVL(PAB.ORIG_REVENUE_PP
, 0))
, SUM(NVL(PAB.ORIG_REVENUE_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_REVENUE_TOT
, 0))
, SUM(NVL(PAB.ORIG_REVENUE_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 = 'R'
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