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_TASK_GENERIC_V |
SELECT T.PROJECT_ID
, T.TASK_ID
, T.PARENT_TASK_ID
, T.WBS_LEVEL
, C.BUDGET_TYPE_CODE
, R.BUDGET_TYPE_CODE
, DECODE(PA_TASK_UTILS.CHECK_CHILD_EXISTS(T.TASK_ID)
, 1
, '+'
, 0
, ' ')
, T.TASK_NUMBER
, T.TASK_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(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
, 0
, 0
FROM PA_TASKS T
, PA_STATUS_TASK_BGT_COST_HIGH_V C
, PA_STATUS_TASK_BGT_REV_HIGH_V R
, PA_STATUS_TASK_ACT_V A
, PA_STATUS_TASK_CMT_V M
WHERE T.PROJECT_ID = PA_STATUS.GETPROJID
AND T.TASK_ID = C.TASK_ID (+)
AND T.TASK_ID = R.TASK_ID (+)
AND T.TASK_ID = A.TASK_ID (+)
AND T.TASK_ID = M.TASK_ID (+)