VIEW: APPS.PA_STATUS_TASK_V

Source

View Text - Preformatted

SELECT T.PROJECT_ID , T.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , T.PARENT_TASK_ID , T.WBS_LEVEL , STBC.BUDGET_TYPE_CODE , STBR.BUDGET_TYPE_CODE , NVL(STA.RAW_COST_ITD, 0) , NVL(STA.RAW_COST_YTD, 0) , NVL(STA.RAW_COST_PP, 0) , NVL(STA.RAW_COST_PTD, 0) , NVL(STA.BILLABLE_RAW_COST_ITD, 0) , NVL(STA.BILLABLE_RAW_COST_YTD, 0) , NVL(STA.BILLABLE_RAW_COST_PP, 0) , NVL(STA.BILLABLE_RAW_COST_PTD, 0) , NVL(STA.BILLABLE_RAW_COST_ITD, 0) , NVL(STA.BILLABLE_RAW_COST_YTD, 0) , NVL(STA.BILLABLE_RAW_COST_PP, 0) , NVL(STA.BILLABLE_RAW_COST_PTD, 0) , NVL(STA.BURDENED_COST_ITD, 0) , NVL(STA.BURDENED_COST_YTD, 0) , NVL(STA.BURDENED_COST_PP, 0) , NVL(STA.BURDENED_COST_PTD, 0) , NVL(STA.BILLABLE_BURDENED_COST_ITD, 0) , NVL(STA.BILLABLE_BURDENED_COST_YTD, 0) , NVL(STA.BILLABLE_BURDENED_COST_PP, 0) , NVL(STA.BILLABLE_BURDENED_COST_PTD, 0) , NVL(STA.BILLABLE_BURDENED_COST_ITD, 0) , NVL(STA.BILLABLE_BURDENED_COST_YTD, 0) , NVL(STA.BILLABLE_BURDENED_COST_PP, 0) , NVL(STA.BILLABLE_BURDENED_COST_PTD, 0) , NVL(STA.ACTUALS_LABOR_HOURS_ITD, 0) , NVL(STA.ACTUALS_LABOR_HOURS_YTD, 0) , NVL(STA.ACTUALS_LABOR_HOURS_PP, 0) , NVL(STA.ACTUALS_LABOR_HOURS_PTD, 0) , NVL(STA.BILLABLE_LABOR_HOURS_ITD, 0) , NVL(STA.BILLABLE_LABOR_HOURS_YTD, 0) , NVL(STA.BILLABLE_LABOR_HOURS_PP, 0) , NVL(STA.BILLABLE_LABOR_HOURS_PTD, 0) , NVL(STA.REVENUE_ITD, 0) , NVL(STA.REVENUE_YTD, 0) , NVL(STA.REVENUE_PP, 0) , NVL(STA.REVENUE_PTD, 0) , NVL(STC.CMT_RAW_COST_ITD, 0) , NVL(STC.CMT_RAW_COST_YTD, 0) , NVL(STC.CMT_RAW_COST_PP, 0) , NVL(STC.CMT_RAW_COST_PTD, 0) , NVL(STC.CMT_BURDENED_COST_ITD, 0) , NVL(STC.CMT_BURDENED_COST_YTD, 0) , NVL(STC.CMT_BURDENED_COST_PP, 0) , NVL(STC.CMT_BURDENED_COST_PTD, 0) , NVL(STBC.BASELINE_RAW_COST_ITD, 0) , NVL(STBC.BASELINE_RAW_COST_YTD, 0) , NVL(STBC.BASELINE_RAW_COST_PP, 0) , NVL(STBC.BASELINE_RAW_COST_PTD, 0) , NVL(STBC.BASELINE_BURDENED_COST_ITD, 0) , NVL(STBC.BASELINE_BURDENED_COST_YTD, 0) , NVL(STBC.BASELINE_BURDENED_COST_PP, 0) , NVL(STBC.BASELINE_BURDENED_COST_PTD, 0) , NVL(STBC.ORIGINAL_RAW_COST_ITD, 0) , NVL(STBC.ORIGINAL_RAW_COST_YTD, 0) , NVL(STBC.ORIGINAL_RAW_COST_PP, 0) , NVL(STBC.ORIGINAL_RAW_COST_PTD, 0) , NVL(STBC.ORIGINAL_BURDENED_COST_ITD, 0) , NVL(STBC.ORIGINAL_BURDENED_COST_YTD, 0) , NVL(STBC.ORIGINAL_BURDENED_COST_PP, 0) , NVL(STBC.ORIGINAL_BURDENED_COST_PTD, 0) , NVL(STBC.ORIGINAL_LABOR_HOURS_ITD, 0) , NVL(STBC.ORIGINAL_LABOR_HOURS_YTD, 0) , NVL(STBC.ORIGINAL_LABOR_HOURS_PP, 0) , NVL(STBC.ORIGINAL_LABOR_HOURS_PTD, 0) , NVL(STBC.BASELINE_LABOR_HOURS_ITD, 0) , NVL(STBC.BASELINE_LABOR_HOURS_YTD, 0) , NVL(STBC.BASELINE_LABOR_HOURS_PP, 0) , NVL(STBC.BASELINE_LABOR_HOURS_PTD, 0) , NVL(STBC.BASELINE_RAW_COST_TOT, 0) , NVL(STBC.BASELINE_BURDENED_COST_TOT, 0) , NVL(STBC.ORIGINAL_RAW_COST_TOT, 0) , NVL(STBC.ORIGINAL_BURDENED_COST_TOT, 0) , NVL(STBC.ORIGINAL_LABOR_HOURS_TOT, 0) , NVL(STBC.BASELINE_LABOR_HOURS_TOT, 0) , NVL(STBR.BASELINE_REVENUE_ITD, 0) , NVL(STBR.BASELINE_REVENUE_YTD, 0) , NVL(STBR.BASELINE_REVENUE_PP, 0) , NVL(STBR.BASELINE_REVENUE_PTD, 0) , NVL(STBR.ORIGINAL_REVENUE_ITD, 0) , NVL(STBR.ORIGINAL_REVENUE_YTD, 0) , NVL(STBR.ORIGINAL_REVENUE_PP, 0) , NVL(STBR.ORIGINAL_REVENUE_PTD, 0) , NVL(STBR.ORIGINAL_LABOR_HOURS_ITD, 0) , NVL(STBR.ORIGINAL_LABOR_HOURS_YTD, 0) , NVL(STBR.ORIGINAL_LABOR_HOURS_PP, 0) , NVL(STBR.ORIGINAL_LABOR_HOURS_PTD, 0) , NVL(STBR.BASELINE_LABOR_HOURS_ITD, 0) , NVL(STBR.BASELINE_LABOR_HOURS_YTD, 0) , NVL(STBR.BASELINE_LABOR_HOURS_PP, 0) , NVL(STBR.BASELINE_LABOR_HOURS_PTD, 0) , NVL(STBR.BASELINE_REVENUE_TOT, 0) , NVL(STBR.ORIGINAL_REVENUE_TOT, 0) , NVL(STBC.ORIGINAL_LABOR_HOURS_TOT, 0) , NVL(STBC.BASELINE_LABOR_HOURS_TOT, 0) FROM PA_TASKS T , PA_STATUS_TASK_ACT_V STA , PA_STATUS_TASK_CMT_V STC , PA_STATUS_TASK_BGT_COST_HIGH_V STBC , PA_STATUS_TASK_BGT_REV_HIGH_V STBR WHERE T.PROJECT_ID = PA_STATUS.GETPROJID AND T.TASK_ID = STA.TASK_ID (+) AND T.TASK_ID = STC.TASK_ID (+) AND T.TASK_ID = STBC.TASK_ID (+) AND T.TASK_ID = STBR.TASK_ID (+)

View Text - HTML Formatted

SELECT T.PROJECT_ID
, T.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.PARENT_TASK_ID
, T.WBS_LEVEL
, STBC.BUDGET_TYPE_CODE
, STBR.BUDGET_TYPE_CODE
, NVL(STA.RAW_COST_ITD
, 0)
, NVL(STA.RAW_COST_YTD
, 0)
, NVL(STA.RAW_COST_PP
, 0)
, NVL(STA.RAW_COST_PTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(STA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_PP
, 0)
, NVL(STA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(STA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(STA.BILLABLE_RAW_COST_PP
, 0)
, NVL(STA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(STA.BURDENED_COST_ITD
, 0)
, NVL(STA.BURDENED_COST_YTD
, 0)
, NVL(STA.BURDENED_COST_PP
, 0)
, NVL(STA.BURDENED_COST_PTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(STA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_ITD
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_YTD
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_PP
, 0)
, NVL(STA.ACTUALS_LABOR_HOURS_PTD
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_ITD
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_YTD
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_PP
, 0)
, NVL(STA.BILLABLE_LABOR_HOURS_PTD
, 0)
, NVL(STA.REVENUE_ITD
, 0)
, NVL(STA.REVENUE_YTD
, 0)
, NVL(STA.REVENUE_PP
, 0)
, NVL(STA.REVENUE_PTD
, 0)
, NVL(STC.CMT_RAW_COST_ITD
, 0)
, NVL(STC.CMT_RAW_COST_YTD
, 0)
, NVL(STC.CMT_RAW_COST_PP
, 0)
, NVL(STC.CMT_RAW_COST_PTD
, 0)
, NVL(STC.CMT_BURDENED_COST_ITD
, 0)
, NVL(STC.CMT_BURDENED_COST_YTD
, 0)
, NVL(STC.CMT_BURDENED_COST_PP
, 0)
, NVL(STC.CMT_BURDENED_COST_PTD
, 0)
, NVL(STBC.BASELINE_RAW_COST_ITD
, 0)
, NVL(STBC.BASELINE_RAW_COST_YTD
, 0)
, NVL(STBC.BASELINE_RAW_COST_PP
, 0)
, NVL(STBC.BASELINE_RAW_COST_PTD
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_ITD
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_YTD
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_PP
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_PTD
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_ITD
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_YTD
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_PP
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_PTD
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_ITD
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_YTD
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_PP
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_PTD
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_ITD
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_YTD
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_PP
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_PTD
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_ITD
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_YTD
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_PP
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_PTD
, 0)
, NVL(STBC.BASELINE_RAW_COST_TOT
, 0)
, NVL(STBC.BASELINE_BURDENED_COST_TOT
, 0)
, NVL(STBC.ORIGINAL_RAW_COST_TOT
, 0)
, NVL(STBC.ORIGINAL_BURDENED_COST_TOT
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_TOT
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_TOT
, 0)
, NVL(STBR.BASELINE_REVENUE_ITD
, 0)
, NVL(STBR.BASELINE_REVENUE_YTD
, 0)
, NVL(STBR.BASELINE_REVENUE_PP
, 0)
, NVL(STBR.BASELINE_REVENUE_PTD
, 0)
, NVL(STBR.ORIGINAL_REVENUE_ITD
, 0)
, NVL(STBR.ORIGINAL_REVENUE_YTD
, 0)
, NVL(STBR.ORIGINAL_REVENUE_PP
, 0)
, NVL(STBR.ORIGINAL_REVENUE_PTD
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_ITD
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_YTD
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_PP
, 0)
, NVL(STBR.ORIGINAL_LABOR_HOURS_PTD
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_ITD
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_YTD
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_PP
, 0)
, NVL(STBR.BASELINE_LABOR_HOURS_PTD
, 0)
, NVL(STBR.BASELINE_REVENUE_TOT
, 0)
, NVL(STBR.ORIGINAL_REVENUE_TOT
, 0)
, NVL(STBC.ORIGINAL_LABOR_HOURS_TOT
, 0)
, NVL(STBC.BASELINE_LABOR_HOURS_TOT
, 0)
FROM PA_TASKS T
, PA_STATUS_TASK_ACT_V STA
, PA_STATUS_TASK_CMT_V STC
, PA_STATUS_TASK_BGT_COST_HIGH_V STBC
, PA_STATUS_TASK_BGT_REV_HIGH_V STBR
WHERE T.PROJECT_ID = PA_STATUS.GETPROJID
AND T.TASK_ID = STA.TASK_ID (+)
AND T.TASK_ID = STC.TASK_ID (+)
AND T.TASK_ID = STBC.TASK_ID (+)
AND T.TASK_ID = STBR.TASK_ID (+)