View: PA_STATUS_RSRC_ACT_LOW_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_STATUS_RSRC_ACT_LOW_V

View Text

SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.RESOURCE_LIST_MEMBER_ID
, RLM.PARENT_MEMBER_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, NVL(PAA.RAW_COST_ITD
, 0)
, NVL(PAA.RAW_COST_YTD
, 0)
, NVL(PAA.RAW_COST_PP
, 0)
, NVL(PAA.RAW_COST_PTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PP
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(PAA.BURDENED_COST_ITD
, 0)
, NVL(PAA.BURDENED_COST_YTD
, 0)
, NVL(PAA.BURDENED_COST_PP
, 0)
, NVL(PAA.BURDENED_COST_PTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(PAA.QUANTITY_ITD
, 0)
, NVL(PAA.QUANTITY_YTD
, 0)
, NVL(PAA.QUANTITY_PP
, 0)
, NVL(PAA.QUANTITY_PTD
, 0)
, NVL(PAA.BILLABLE_QUANTITY_ITD
, 0)
, NVL(PAA.BILLABLE_QUANTITY_YTD
, 0)
, NVL(PAA.BILLABLE_QUANTITY_PP
, 0)
, NVL(PAA.BILLABLE_QUANTITY_PTD
, 0)
, NVL(PAA.LABOR_HOURS_ITD
, 0)
, NVL(PAA.LABOR_HOURS_YTD
, 0)
, NVL(PAA.LABOR_HOURS_PP
, 0)
, NVL(PAA.LABOR_HOURS_PTD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_ITD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_YTD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_PP
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_PTD
, 0)
, NVL(PAA.REVENUE_ITD
, 0)
, NVL(PAA.REVENUE_YTD
, 0)
, NVL(PAA.REVENUE_PP
, 0)
, NVL(PAA.REVENUE_PTD
, 0)
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_PROJECT_ACCUM_ACTUALS PAA
WHERE RLM.RESOURCE_LIST_MEMBER_ID = PAH.RESOURCE_LIST_MEMBER_ID
AND PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID
AND PAH.TASK_ID = PA_STATUS.GETTASKID
AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID UNION SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.PARENT_MEMBER_ID
, NULL+0
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(PAA.RAW_COST_ITD
, 0))
, SUM(NVL(PAA.RAW_COST_YTD
, 0))
, SUM(NVL(PAA.RAW_COST_PP
, 0))
, SUM(NVL(PAA.RAW_COST_PTD
, 0))
, SUM(NVL(PAA.BILLABLE_RAW_COST_ITD
, 0))
, SUM(NVL(PAA.BILLABLE_RAW_COST_YTD
, 0))
, SUM(NVL(PAA.BILLABLE_RAW_COST_PP
, 0))
, SUM(NVL(PAA.BILLABLE_RAW_COST_PTD
, 0))
, SUM(NVL(PAA.BURDENED_COST_ITD
, 0))
, SUM(NVL(PAA.BURDENED_COST_YTD
, 0))
, SUM(NVL(PAA.BURDENED_COST_PP
, 0))
, SUM(NVL(PAA.BURDENED_COST_PTD
, 0))
, SUM(NVL(PAA.BILLABLE_BURDENED_COST_ITD
, 0))
, SUM(NVL(PAA.BILLABLE_BURDENED_COST_YTD
, 0))
, SUM(NVL(PAA.BILLABLE_BURDENED_COST_PP
, 0))
, SUM(NVL(PAA.BILLABLE_BURDENED_COST_PTD
, 0))
, SUM(NVL(PAA.QUANTITY_ITD
, 0))
, SUM(NVL(PAA.QUANTITY_YTD
, 0))
, SUM(NVL(PAA.QUANTITY_PP
, 0))
, SUM(NVL(PAA.QUANTITY_PTD
, 0))
, SUM(NVL(PAA.BILLABLE_QUANTITY_ITD
, 0))
, SUM(NVL(PAA.BILLABLE_QUANTITY_YTD
, 0))
, SUM(NVL(PAA.BILLABLE_QUANTITY_PP
, 0))
, SUM(NVL(PAA.BILLABLE_QUANTITY_PTD
, 0))
, SUM(NVL(PAA.LABOR_HOURS_ITD
, 0))
, SUM(NVL(PAA.LABOR_HOURS_YTD
, 0))
, SUM(NVL(PAA.LABOR_HOURS_PP
, 0))
, SUM(NVL(PAA.LABOR_HOURS_PTD
, 0))
, SUM(NVL(PAA.BILLABLE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(PAA.BILLABLE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(PAA.BILLABLE_LABOR_HOURS_PP
, 0))
, SUM(NVL(PAA.BILLABLE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(PAA.REVENUE_ITD
, 0))
, SUM(NVL(PAA.REVENUE_YTD
, 0))
, SUM(NVL(PAA.REVENUE_PP
, 0))
, SUM(NVL(PAA.REVENUE_PTD
, 0))
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_PROJECT_ACCUM_ACTUALS PAA
WHERE RLM.PARENT_MEMBER_ID IS NOT NULL
AND RLM.RESOURCE_LIST_MEMBER_ID = PAH.RESOURCE_LIST_MEMBER_ID
AND PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID
AND PAH.TASK_ID = PA_STATUS.GETTASKID
AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID GROUP BY PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.PARENT_MEMBER_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID

Columns