Product: | PA - Projects |
---|---|
Description: | 10SC Only -- This was set create False on 8.30.96 as these views are re- created by paxgddc3.sql during autoinstall . |
Implementation/DBA Data: | APPS.PA_STATUS_RSRC_GENERIC_V |
SELECT PAH.PROJECT_ID
, PAH.RESOURCE_LIST_MEMBER_ID
, RLM.PARENT_MEMBER_ID
, RLM.MEMBER_LEVEL
, RLM.SORT_ORDER
, PAH.TASK_ID
, PAH.RESOURCE_LIST_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, DECODE(PAH.TASK_ID
, 0
, 'Y'
, 'N')
, DECODE(PA_GET_RESOURCE.CHILD_RESOURCE_EXISTS(PAH.RESOURCE_LIST_MEMBER_ID
, PAH.TASK_ID
, PAH.PROJECT_ID)
, 'Y'
, '+'
, 'N'
, ' ')
, RLM.ALIAS
, RES.NAME
, DECODE((SIGN((NVL(C.BASELINE_BURDENED_COST_ITD
, 0) * 1.1)-(NVL(A.BURDENED_COST_ITD
, 0) + NVL(M.CMT_BURDENED_COST_PTD
, 0))))
, -1
, '*'
, NULL)
, ROUND(NVL(R.BASELINE_REVENUE_ITD
, 0))
, ROUND(NVL(A.REVENUE_ITD
, 0))
, ROUND(NVL(C.BASELINE_BURDENED_COST_ITD
, 0))
, ROUND(NVL(A.BURDENED_COST_ITD
, 0))
, ROUND(NVL(M.CMT_BURDENED_COST_PTD
, 0))
, ROUND(NVL(C.BASELINE_BURDENED_COST_PTD
, 0))
, ROUND(NVL(A.BURDENED_COST_PTD
, 0))
, ROUND(NVL(C.BASELINE_LABOR_HOURS_ITD
, 0))
, ROUND(NVL(A.ACTUALS_LABOR_HOURS_ITD
, 0))
, ROUND(NVL(C.BASELINE_LABOR_HOURS_PTD
, 0))
, ROUND(NVL(A.ACTUALS_LABOR_HOURS_PTD
, 0))
, ROUND(NVL(R.BASELINE_REVENUE_TOT
, 0))
, ROUND(NVL(C.BASELINE_BURDENED_COST_TOT
, 0))
, ROUND(NVL(C.BASELINE_LABOR_HOURS_TOT
, 0))
, ROUND(NVL(R.ORIGINAL_REVENUE_TOT
, 0))
, ROUND(NVL(C.ORIGINAL_BURDENED_COST_TOT
, 0))
, ROUND(NVL(C.ORIGINAL_LABOR_HOURS_TOT
, 0))
, ROUND(NVL(R.ORIGINAL_REVENUE_ITD
, 0))
, ROUND(NVL(A.ACTUALS_QUANTITY_ITD
, 0))
, ROUND(NVL(C.BASELINE_QUANTITY_TOT
, 0))
, ROUND(DECODE(C.BASELINE_BURDENED_COST_TOT
, 0
, 0
, (A.BURDENED_COST_ITD/ C.BASELINE_BURDENED_COST_TOT) * 100))
, ROUND(DECODE(C.BASELINE_LABOR_HOURS_TOT
, 0
, 0
, (A.ACTUALS_LABOR_HOURS_ITD/ C.BASELINE_LABOR_HOURS_TOT) * 100))
, ROUND(NVL(C.BASELINE_BURDENED_COST_TOT
, 0) - NVL(M.CMT_BURDENED_COST_PTD
, 0) - NVL(A.BURDENED_COST_ITD
, 0))
, ROUND(NVL(A.BURDENED_COST_ITD
, 0) + NVL(M.CMT_BURDENED_COST_PTD
, 0))
, ROUND(NVL(R.BASELINE_REVENUE_TOT
, 0) - NVL(C.BASELINE_BURDENED_COST_TOT
, 0))
, ROUND(NVL(A.REVENUE_ITD
, 0) - NVL(A.BURDENED_COST_ITD
, 0))
, 0
, 0
, 0
, 0
FROM PA_STATUS_PROJ_ACCUM_HEADERS_V PAH
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCES RES
, PA_STATUS_RSRC_ACT_HIGH_V A
, PA_STATUS_RSRC_CMT_HIGH_V M
, PA_STATUS_RSRC_BGT_COST_HIGH_V C
, PA_STATUS_RSRC_BGT_REV_HIGH_V R
WHERE PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID
AND PAH.TASK_ID = PA_STATUS.GETTASKID
AND PAH.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND RLM.RESOURCE_ID = RES.RESOURCE_ID
AND NVL(RLM.MIGRATION_CODE
, '-99') <> 'N'
AND PAH.RESOURCE_LIST_MEMBER_ID = A.RESOURCE_LIST_MEMBER_ID (+)
AND PAH.RESOURCE_LIST_MEMBER_ID = M.RESOURCE_LIST_MEMBER_ID (+)
AND PAH.RESOURCE_LIST_MEMBER_ID = C.RESOURCE_LIST_MEMBER_ID (+)
AND PAH.RESOURCE_LIST_MEMBER_ID = R.RESOURCE_LIST_MEMBER_ID (+)