VIEW: APPS.PA_STATUS_PROJ_V

Source

View Text - Preformatted

SELECT P.PROJECT_ID , P.SEGMENT1 , P.NAME , SPBC.BUDGET_TYPE_CODE , SPBR.BUDGET_TYPE_CODE , NVL(PAA.RAW_COST_ITD, 0) , NVL(PAA.RAW_COST_YTD, 0) , NVL(PAA.RAW_COST_PP, 0) , NVL(PAA.RAW_COST_PTD, 0) , NVL(PAA.BILLABLE_RAW_COST_ITD, 0) , NVL(PAA.BILLABLE_RAW_COST_YTD, 0) , NVL(PAA.BILLABLE_RAW_COST_PP, 0) , NVL(PAA.BILLABLE_RAW_COST_PTD, 0) , NVL(PAA.BILLABLE_RAW_COST_ITD, 0) , NVL(PAA.BILLABLE_RAW_COST_YTD, 0) , NVL(PAA.BILLABLE_RAW_COST_PP, 0) , NVL(PAA.BILLABLE_RAW_COST_PTD, 0) , NVL(PAA.BURDENED_COST_ITD, 0) , NVL(PAA.BURDENED_COST_YTD, 0) , NVL(PAA.BURDENED_COST_PP, 0) , NVL(PAA.BURDENED_COST_PTD, 0) , NVL(PAA.BILLABLE_BURDENED_COST_ITD, 0) , NVL(PAA.BILLABLE_BURDENED_COST_YTD, 0) , NVL(PAA.BILLABLE_BURDENED_COST_PP, 0) , NVL(PAA.BILLABLE_BURDENED_COST_PTD, 0) , NVL(PAA.BILLABLE_BURDENED_COST_ITD, 0) , NVL(PAA.BILLABLE_BURDENED_COST_YTD, 0) , NVL(PAA.BILLABLE_BURDENED_COST_PP, 0) , NVL(PAA.BILLABLE_BURDENED_COST_PTD, 0) , NVL(PAA.LABOR_HOURS_ITD, 0) , NVL(PAA.LABOR_HOURS_YTD, 0) , NVL(PAA.LABOR_HOURS_PP, 0) , NVL(PAA.LABOR_HOURS_PTD, 0) , NVL(PAA.BILLABLE_LABOR_HOURS_ITD, 0) , NVL(PAA.BILLABLE_LABOR_HOURS_YTD, 0) , NVL(PAA.BILLABLE_LABOR_HOURS_PP, 0) , NVL(PAA.BILLABLE_LABOR_HOURS_PTD, 0) , NVL(PAA.REVENUE_ITD, 0) , NVL(PAA.REVENUE_YTD, 0) , NVL(PAA.REVENUE_PP, 0) , NVL(PAA.REVENUE_PTD, 0) , NVL(PAC.CMT_RAW_COST_ITD, 0) , NVL(PAC.CMT_RAW_COST_YTD, 0) , NVL(PAC.CMT_RAW_COST_PP, 0) , NVL(PAC.CMT_RAW_COST_PTD, 0) , NVL(PAC.CMT_BURDENED_COST_ITD, 0) , NVL(PAC.CMT_BURDENED_COST_YTD, 0) , NVL(PAC.CMT_BURDENED_COST_PP, 0) , NVL(PAC.CMT_BURDENED_COST_PTD, 0) , NVL(SPBC.BASELINE_RAW_COST_ITD, 0) , NVL(SPBC.BASELINE_RAW_COST_YTD, 0) , NVL(SPBC.BASELINE_RAW_COST_PP, 0) , NVL(SPBC.BASELINE_RAW_COST_PTD, 0) , NVL(SPBC.BASELINE_BURDENED_COST_ITD, 0) , NVL(SPBC.BASELINE_BURDENED_COST_YTD, 0) , NVL(SPBC.BASELINE_BURDENED_COST_PP, 0) , NVL(SPBC.BASELINE_BURDENED_COST_PTD, 0) , NVL(SPBC.ORIGINAL_RAW_COST_ITD, 0) , NVL(SPBC.ORIGINAL_RAW_COST_YTD, 0) , NVL(SPBC.ORIGINAL_RAW_COST_PP, 0) , NVL(SPBC.ORIGINAL_RAW_COST_PTD, 0) , NVL(SPBC.ORIGINAL_BURDENED_COST_ITD, 0) , NVL(SPBC.ORIGINAL_BURDENED_COST_YTD, 0) , NVL(SPBC.ORIGINAL_BURDENED_COST_PP, 0) , NVL(SPBC.ORIGINAL_BURDENED_COST_PTD, 0) , NVL(SPBC.ORIGINAL_LABOR_HOURS_ITD, 0) , NVL(SPBC.ORIGINAL_LABOR_HOURS_YTD, 0) , NVL(SPBC.ORIGINAL_LABOR_HOURS_PP, 0) , NVL(SPBC.ORIGINAL_LABOR_HOURS_PTD, 0) , NVL(SPBC.BASELINE_LABOR_HOURS_ITD, 0) , NVL(SPBC.BASELINE_LABOR_HOURS_YTD, 0) , NVL(SPBC.BASELINE_LABOR_HOURS_PP, 0) , NVL(SPBC.BASELINE_LABOR_HOURS_PTD, 0) , NVL(SPBC.BASELINE_RAW_COST_TOT, 0) , NVL(SPBC.BASELINE_BURDENED_COST_TOT, 0) , NVL(SPBC.ORIGINAL_RAW_COST_TOT, 0) , NVL(SPBC.ORIGINAL_BURDENED_COST_TOT, 0) , NVL(SPBC.ORIGINAL_LABOR_HOURS_TOT, 0) , NVL(SPBC.BASELINE_LABOR_HOURS_TOT, 0) , NVL(SPBR.BASELINE_REVENUE_ITD, 0) , NVL(SPBR.BASELINE_REVENUE_YTD, 0) , NVL(SPBR.BASELINE_REVENUE_PP, 0) , NVL(SPBR.BASELINE_REVENUE_PTD, 0) , NVL(SPBR.ORIGINAL_REVENUE_ITD, 0) , NVL(SPBR.ORIGINAL_REVENUE_YTD, 0) , NVL(SPBR.ORIGINAL_REVENUE_PP, 0) , NVL(SPBR.ORIGINAL_REVENUE_PTD, 0) , NVL(SPBR.ORIGINAL_LABOR_HOURS_ITD, 0) , NVL(SPBR.ORIGINAL_LABOR_HOURS_YTD, 0) , NVL(SPBR.ORIGINAL_LABOR_HOURS_PP, 0) , NVL(SPBR.ORIGINAL_LABOR_HOURS_PTD, 0) , NVL(SPBR.BASELINE_LABOR_HOURS_ITD, 0) , NVL(SPBR.BASELINE_LABOR_HOURS_YTD, 0) , NVL(SPBR.BASELINE_LABOR_HOURS_PP, 0) , NVL(SPBR.BASELINE_LABOR_HOURS_PTD, 0) , NVL(SPBR.BASELINE_REVENUE_TOT, 0) , NVL(SPBR.ORIGINAL_REVENUE_TOT, 0) , NVL(SPBC.ORIGINAL_LABOR_HOURS_TOT, 0) , NVL(SPBC.BASELINE_LABOR_HOURS_TOT, 0) FROM PA_PROJECTS P , PA_STATUS_PROJ_BGT_COST_V SPBC , PA_STATUS_PROJ_BGT_REV_V SPBR , PA_PROJECT_ACCUM_HEADERS PAH , PA_PROJECT_ACCUM_ACTUALS PAA , PA_PROJECT_ACCUM_COMMITMENTS PAC WHERE P.PROJECT_ID = PAH.PROJECT_ID AND PAH.TASK_ID = 0 AND PAH.RESOURCE_LIST_ID = 0 AND PAH.PROJECT_ID = SPBR.PROJECT_ID AND PAH.PROJECT_ID = SPBC.PROJECT_ID AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID (+) AND PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID (+)

View Text - HTML Formatted

SELECT P.PROJECT_ID
, P.SEGMENT1
, P.NAME
, SPBC.BUDGET_TYPE_CODE
, SPBR.BUDGET_TYPE_CODE
, NVL(PAA.RAW_COST_ITD
, 0)
, NVL(PAA.RAW_COST_YTD
, 0)
, NVL(PAA.RAW_COST_PP
, 0)
, NVL(PAA.RAW_COST_PTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PP
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_ITD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_YTD
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PP
, 0)
, NVL(PAA.BILLABLE_RAW_COST_PTD
, 0)
, NVL(PAA.BURDENED_COST_ITD
, 0)
, NVL(PAA.BURDENED_COST_YTD
, 0)
, NVL(PAA.BURDENED_COST_PP
, 0)
, NVL(PAA.BURDENED_COST_PTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_ITD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_YTD
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PP
, 0)
, NVL(PAA.BILLABLE_BURDENED_COST_PTD
, 0)
, NVL(PAA.LABOR_HOURS_ITD
, 0)
, NVL(PAA.LABOR_HOURS_YTD
, 0)
, NVL(PAA.LABOR_HOURS_PP
, 0)
, NVL(PAA.LABOR_HOURS_PTD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_ITD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_YTD
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_PP
, 0)
, NVL(PAA.BILLABLE_LABOR_HOURS_PTD
, 0)
, NVL(PAA.REVENUE_ITD
, 0)
, NVL(PAA.REVENUE_YTD
, 0)
, NVL(PAA.REVENUE_PP
, 0)
, NVL(PAA.REVENUE_PTD
, 0)
, NVL(PAC.CMT_RAW_COST_ITD
, 0)
, NVL(PAC.CMT_RAW_COST_YTD
, 0)
, NVL(PAC.CMT_RAW_COST_PP
, 0)
, NVL(PAC.CMT_RAW_COST_PTD
, 0)
, NVL(PAC.CMT_BURDENED_COST_ITD
, 0)
, NVL(PAC.CMT_BURDENED_COST_YTD
, 0)
, NVL(PAC.CMT_BURDENED_COST_PP
, 0)
, NVL(PAC.CMT_BURDENED_COST_PTD
, 0)
, NVL(SPBC.BASELINE_RAW_COST_ITD
, 0)
, NVL(SPBC.BASELINE_RAW_COST_YTD
, 0)
, NVL(SPBC.BASELINE_RAW_COST_PP
, 0)
, NVL(SPBC.BASELINE_RAW_COST_PTD
, 0)
, NVL(SPBC.BASELINE_BURDENED_COST_ITD
, 0)
, NVL(SPBC.BASELINE_BURDENED_COST_YTD
, 0)
, NVL(SPBC.BASELINE_BURDENED_COST_PP
, 0)
, NVL(SPBC.BASELINE_BURDENED_COST_PTD
, 0)
, NVL(SPBC.ORIGINAL_RAW_COST_ITD
, 0)
, NVL(SPBC.ORIGINAL_RAW_COST_YTD
, 0)
, NVL(SPBC.ORIGINAL_RAW_COST_PP
, 0)
, NVL(SPBC.ORIGINAL_RAW_COST_PTD
, 0)
, NVL(SPBC.ORIGINAL_BURDENED_COST_ITD
, 0)
, NVL(SPBC.ORIGINAL_BURDENED_COST_YTD
, 0)
, NVL(SPBC.ORIGINAL_BURDENED_COST_PP
, 0)
, NVL(SPBC.ORIGINAL_BURDENED_COST_PTD
, 0)
, NVL(SPBC.ORIGINAL_LABOR_HOURS_ITD
, 0)
, NVL(SPBC.ORIGINAL_LABOR_HOURS_YTD
, 0)
, NVL(SPBC.ORIGINAL_LABOR_HOURS_PP
, 0)
, NVL(SPBC.ORIGINAL_LABOR_HOURS_PTD
, 0)
, NVL(SPBC.BASELINE_LABOR_HOURS_ITD
, 0)
, NVL(SPBC.BASELINE_LABOR_HOURS_YTD
, 0)
, NVL(SPBC.BASELINE_LABOR_HOURS_PP
, 0)
, NVL(SPBC.BASELINE_LABOR_HOURS_PTD
, 0)
, NVL(SPBC.BASELINE_RAW_COST_TOT
, 0)
, NVL(SPBC.BASELINE_BURDENED_COST_TOT
, 0)
, NVL(SPBC.ORIGINAL_RAW_COST_TOT
, 0)
, NVL(SPBC.ORIGINAL_BURDENED_COST_TOT
, 0)
, NVL(SPBC.ORIGINAL_LABOR_HOURS_TOT
, 0)
, NVL(SPBC.BASELINE_LABOR_HOURS_TOT
, 0)
, NVL(SPBR.BASELINE_REVENUE_ITD
, 0)
, NVL(SPBR.BASELINE_REVENUE_YTD
, 0)
, NVL(SPBR.BASELINE_REVENUE_PP
, 0)
, NVL(SPBR.BASELINE_REVENUE_PTD
, 0)
, NVL(SPBR.ORIGINAL_REVENUE_ITD
, 0)
, NVL(SPBR.ORIGINAL_REVENUE_YTD
, 0)
, NVL(SPBR.ORIGINAL_REVENUE_PP
, 0)
, NVL(SPBR.ORIGINAL_REVENUE_PTD
, 0)
, NVL(SPBR.ORIGINAL_LABOR_HOURS_ITD
, 0)
, NVL(SPBR.ORIGINAL_LABOR_HOURS_YTD
, 0)
, NVL(SPBR.ORIGINAL_LABOR_HOURS_PP
, 0)
, NVL(SPBR.ORIGINAL_LABOR_HOURS_PTD
, 0)
, NVL(SPBR.BASELINE_LABOR_HOURS_ITD
, 0)
, NVL(SPBR.BASELINE_LABOR_HOURS_YTD
, 0)
, NVL(SPBR.BASELINE_LABOR_HOURS_PP
, 0)
, NVL(SPBR.BASELINE_LABOR_HOURS_PTD
, 0)
, NVL(SPBR.BASELINE_REVENUE_TOT
, 0)
, NVL(SPBR.ORIGINAL_REVENUE_TOT
, 0)
, NVL(SPBC.ORIGINAL_LABOR_HOURS_TOT
, 0)
, NVL(SPBC.BASELINE_LABOR_HOURS_TOT
, 0)
FROM PA_PROJECTS P
, PA_STATUS_PROJ_BGT_COST_V SPBC
, PA_STATUS_PROJ_BGT_REV_V SPBR
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_ACTUALS PAA
, PA_PROJECT_ACCUM_COMMITMENTS PAC
WHERE P.PROJECT_ID = PAH.PROJECT_ID
AND PAH.TASK_ID = 0
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.PROJECT_ID = SPBR.PROJECT_ID
AND PAH.PROJECT_ID = SPBC.PROJECT_ID
AND PAH.PROJECT_ACCUM_ID = PAA.PROJECT_ACCUM_ID (+)
AND PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID (+)