Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.PA_STATUS_TASK_V |
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 (+)