VIEW: APPS.PA_ACCUM_WBS_COST_BGT_V

Source

View Text - Preformatted

SELECT PAH.PROJECT_ID , P.SEGMENT1 , P.NAME , PAH.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , LPAD(' ',2 * (T.WBS_LEVEL - 1))||T.TASK_NUMBER , LPAD(' ',2 * (T.WBS_LEVEL - 1))||T.TASK_NAME , T.WBS_LEVEL , T.START_DATE , T.COMPLETION_DATE , T.TASK_MANAGER_PERSON_ID , PER.FULL_NAME , PAB.BUDGET_TYPE_CODE , NVL(PAB.BASE_RAW_COST_ITD, 0) , NVL(PAB.BASE_RAW_COST_YTD, 0) , NVL(PAB.BASE_RAW_COST_PP, 0) , NVL(PAB.BASE_RAW_COST_PTD, 0) , NVL(PAB.BASE_BURDENED_COST_ITD, 0) , NVL(PAB.BASE_BURDENED_COST_YTD, 0) , NVL(PAB.BASE_BURDENED_COST_PP, 0) , NVL(PAB.BASE_BURDENED_COST_PTD, 0) , NVL(PAB.ORIG_RAW_COST_ITD, 0) , NVL(PAB.ORIG_RAW_COST_YTD, 0) , NVL(PAB.ORIG_RAW_COST_PP, 0) , NVL(PAB.ORIG_RAW_COST_PTD, 0) , NVL(PAB.ORIG_BURDENED_COST_ITD, 0) , NVL(PAB.ORIG_BURDENED_COST_YTD, 0) , NVL(PAB.ORIG_BURDENED_COST_PP, 0) , NVL(PAB.ORIG_BURDENED_COST_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_RAW_COST_TOT, 0) , NVL(PAB.BASE_BURDENED_COST_TOT, 0) , NVL(PAB.ORIG_RAW_COST_TOT, 0) , NVL(PAB.ORIG_BURDENED_COST_TOT, 0) , NVL(PAB.ORIG_LABOR_HOURS_TOT, 0) , NVL(PAB.BASE_LABOR_HOURS_TOT, 0) FROM PA_PROJECTS P , PA_TASKS T , PER_PEOPLE_F PER , PA_PROJECT_ACCUM_HEADERS PAH , PA_PROJECT_ACCUM_BUDGETS PAB , PA_BUDGET_TYPES BT WHERE P.PROJECT_ID = PAH.PROJECT_ID AND PAH.TASK_ID >= 0 AND PAH.RESOURCE_LIST_ID = 0 AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID AND PAB.BUDGET_TYPE_CODE = BT.BUDGET_TYPE_CODE AND BT.BUDGET_AMOUNT_CODE = 'C' AND PAH.TASK_ID = T.TASK_ID (+) AND T.TASK_MANAGER_PERSON_ID = PER.PERSON_ID (+) AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+) AND PER.EFFECTIVE_END_DATE (+) and pab.fin_plan_type_id is null

View Text - HTML Formatted

SELECT PAH.PROJECT_ID
, P.SEGMENT1
, P.NAME
, PAH.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, LPAD(' '
, 2 * (T.WBS_LEVEL - 1))||T.TASK_NUMBER
, LPAD(' '
, 2 * (T.WBS_LEVEL - 1))||T.TASK_NAME
, T.WBS_LEVEL
, T.START_DATE
, T.COMPLETION_DATE
, T.TASK_MANAGER_PERSON_ID
, PER.FULL_NAME
, PAB.BUDGET_TYPE_CODE
, NVL(PAB.BASE_RAW_COST_ITD
, 0)
, NVL(PAB.BASE_RAW_COST_YTD
, 0)
, NVL(PAB.BASE_RAW_COST_PP
, 0)
, NVL(PAB.BASE_RAW_COST_PTD
, 0)
, NVL(PAB.BASE_BURDENED_COST_ITD
, 0)
, NVL(PAB.BASE_BURDENED_COST_YTD
, 0)
, NVL(PAB.BASE_BURDENED_COST_PP
, 0)
, NVL(PAB.BASE_BURDENED_COST_PTD
, 0)
, NVL(PAB.ORIG_RAW_COST_ITD
, 0)
, NVL(PAB.ORIG_RAW_COST_YTD
, 0)
, NVL(PAB.ORIG_RAW_COST_PP
, 0)
, NVL(PAB.ORIG_RAW_COST_PTD
, 0)
, NVL(PAB.ORIG_BURDENED_COST_ITD
, 0)
, NVL(PAB.ORIG_BURDENED_COST_YTD
, 0)
, NVL(PAB.ORIG_BURDENED_COST_PP
, 0)
, NVL(PAB.ORIG_BURDENED_COST_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_RAW_COST_TOT
, 0)
, NVL(PAB.BASE_BURDENED_COST_TOT
, 0)
, NVL(PAB.ORIG_RAW_COST_TOT
, 0)
, NVL(PAB.ORIG_BURDENED_COST_TOT
, 0)
, NVL(PAB.ORIG_LABOR_HOURS_TOT
, 0)
, NVL(PAB.BASE_LABOR_HOURS_TOT
, 0)
FROM PA_PROJECTS P
, PA_TASKS T
, PER_PEOPLE_F PER
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_BUDGETS PAB
, PA_BUDGET_TYPES BT
WHERE P.PROJECT_ID = PAH.PROJECT_ID
AND PAH.TASK_ID >= 0
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
AND PAB.BUDGET_TYPE_CODE = BT.BUDGET_TYPE_CODE
AND BT.BUDGET_AMOUNT_CODE = 'C'
AND PAH.TASK_ID = T.TASK_ID (+)
AND T.TASK_MANAGER_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND PER.EFFECTIVE_END_DATE (+)
AND PAB.FIN_PLAN_TYPE_ID IS NULL