VIEW: APPS.PA_STATUS_TASK_GENERIC_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)