VIEW: APPS.PA_STATUS_RSRC_V

Source

View Text - Preformatted

SELECT SPAH.PROJECT_ID , SPAH.RESOURCE_LIST_MEMBER_ID , RLM.ALIAS , RLM.PARENT_MEMBER_ID , RLM.MEMBER_LEVEL , RLM.SORT_ORDER , SPAH.TASK_ID , SPAH.RESOURCE_LIST_ID , SPAH.RESOURCE_LIST_ASSIGNMENT_ID , DECODE(SPAH.TASK_ID, 0, 'Y','N') , SRA.RAW_COST_ITD , SRA.RAW_COST_YTD , SRA.RAW_COST_PP , SRA.RAW_COST_PTD , SRA.BILLABLE_RAW_COST_ITD , SRA.BILLABLE_RAW_COST_YTD , SRA.BILLABLE_RAW_COST_PP , SRA.BILLABLE_RAW_COST_PTD , SRA.BILLABLE_RAW_COST_ITD , SRA.BILLABLE_RAW_COST_YTD , SRA.BILLABLE_RAW_COST_PP , SRA.BILLABLE_RAW_COST_PTD , SRA.BURDENED_COST_ITD , SRA.BURDENED_COST_YTD , SRA.BURDENED_COST_PP , SRA.BURDENED_COST_PTD , SRA.BILLABLE_BURDENED_COST_ITD , SRA.BILLABLE_BURDENED_COST_YTD , SRA.BILLABLE_BURDENED_COST_PP , SRA.BILLABLE_BURDENED_COST_PTD , SRA.BILLABLE_BURDENED_COST_ITD , SRA.BILLABLE_BURDENED_COST_YTD , SRA.BILLABLE_BURDENED_COST_PP , SRA.BILLABLE_BURDENED_COST_PTD , SRA.ACTUALS_QUANTITY_ITD , SRA.ACTUALS_QUANTITY_YTD , SRA.ACTUALS_QUANTITY_PP , SRA.ACTUALS_QUANTITY_PTD , SRA.BILLABLE_QUANTITY_ITD , SRA.BILLABLE_QUANTITY_YTD , SRA.BILLABLE_QUANTITY_PP , SRA.BILLABLE_QUANTITY_PTD , SRA.ACTUALS_LABOR_HOURS_ITD , SRA.ACTUALS_LABOR_HOURS_YTD , SRA.ACTUALS_LABOR_HOURS_PP , SRA.ACTUALS_LABOR_HOURS_PTD , SRA.BILLABLE_LABOR_HOURS_ITD , SRA.BILLABLE_LABOR_HOURS_YTD , SRA.BILLABLE_LABOR_HOURS_PP , SRA.BILLABLE_LABOR_HOURS_PTD , SRA.REVENUE_ITD , SRA.REVENUE_YTD , SRA.REVENUE_PP , SRA.REVENUE_PTD , SRC.CMT_RAW_COST_ITD , SRC.CMT_RAW_COST_YTD , SRC.CMT_RAW_COST_PP , SRC.CMT_RAW_COST_PTD , SRC.CMT_BURDENED_COST_ITD , SRC.CMT_BURDENED_COST_YTD , SRC.CMT_BURDENED_COST_PP , SRC.CMT_BURDENED_COST_PTD , SRC.CMT_QUANTITY_ITD , SRC.CMT_QUANTITY_YTD , SRC.CMT_QUANTITY_PP , SRC.CMT_QUANTITY_PTD , SRBC.BASELINE_RAW_COST_ITD , SRBC.BASELINE_RAW_COST_YTD , SRBC.BASELINE_RAW_COST_PP , SRBC.BASELINE_RAW_COST_PTD , SRBC.BASELINE_BURDENED_COST_ITD , SRBC.BASELINE_BURDENED_COST_YTD , SRBC.BASELINE_BURDENED_COST_PP , SRBC.BASELINE_BURDENED_COST_PTD , SRBC.ORIGINAL_RAW_COST_ITD , SRBC.ORIGINAL_RAW_COST_YTD , SRBC.ORIGINAL_RAW_COST_PP , SRBC.ORIGINAL_RAW_COST_PTD , SRBC.ORIGINAL_BURDENED_COST_ITD , SRBC.ORIGINAL_BURDENED_COST_YTD , SRBC.ORIGINAL_BURDENED_COST_PP , SRBC.ORIGINAL_BURDENED_COST_PTD , SRBC.BASELINE_QUANTITY_ITD , SRBC.BASELINE_QUANTITY_YTD , SRBC.BASELINE_QUANTITY_PP , SRBC.BASELINE_QUANTITY_PTD , SRBC.ORIGINAL_QUANTITY_ITD , SRBC.ORIGINAL_QUANTITY_YTD , SRBC.ORIGINAL_QUANTITY_PP , SRBC.ORIGINAL_QUANTITY_PTD , SRBC.ORIGINAL_LABOR_HOURS_ITD , SRBC.ORIGINAL_LABOR_HOURS_YTD , SRBC.ORIGINAL_LABOR_HOURS_PP , SRBC.ORIGINAL_LABOR_HOURS_PTD , SRBC.BASELINE_LABOR_HOURS_ITD , SRBC.BASELINE_LABOR_HOURS_YTD , SRBC.BASELINE_LABOR_HOURS_PP , SRBC.BASELINE_LABOR_HOURS_PTD , SRBC.BASELINE_RAW_COST_TOT , SRBC.BASELINE_BURDENED_COST_TOT , SRBC.ORIGINAL_RAW_COST_TOT , SRBC.ORIGINAL_BURDENED_COST_TOT , SRBC.ORIGINAL_LABOR_HOURS_TOT , SRBC.BASELINE_LABOR_HOURS_TOT , SRBC.BASELINE_QUANTITY_TOT , SRBC.ORIGINAL_QUANTITY_TOT , SRBR.BASELINE_REVENUE_ITD , SRBR.BASELINE_REVENUE_YTD , SRBR.BASELINE_REVENUE_PP , SRBR.BASELINE_REVENUE_PTD , SRBR.ORIGINAL_REVENUE_ITD , SRBR.ORIGINAL_REVENUE_YTD , SRBR.ORIGINAL_REVENUE_PP , SRBR.ORIGINAL_REVENUE_PTD , SRBR.BASELINE_QUANTITY_ITD , SRBR.BASELINE_QUANTITY_YTD , SRBR.BASELINE_QUANTITY_PP , SRBR.BASELINE_QUANTITY_PTD , SRBR.ORIGINAL_QUANTITY_ITD , SRBR.ORIGINAL_QUANTITY_YTD , SRBR.ORIGINAL_QUANTITY_PP , SRBR.ORIGINAL_QUANTITY_PTD , SRBR.ORIGINAL_LABOR_HOURS_ITD , SRBR.ORIGINAL_LABOR_HOURS_YTD , SRBR.ORIGINAL_LABOR_HOURS_PP , SRBR.ORIGINAL_LABOR_HOURS_PTD , SRBR.BASELINE_LABOR_HOURS_ITD , SRBR.BASELINE_LABOR_HOURS_YTD , SRBR.BASELINE_LABOR_HOURS_PP , SRBR.BASELINE_LABOR_HOURS_PTD , SRBR.BASELINE_REVENUE_TOT , SRBR.ORIGINAL_REVENUE_TOT , SRBR.ORIGINAL_LABOR_HOURS_TOT , SRBR.BASELINE_LABOR_HOURS_TOT , SRBR.BASELINE_QUANTITY_TOT , SRBR.ORIGINAL_QUANTITY_TOT FROM PA_STATUS_PROJ_ACCUM_HEADERS_V SPAH , PA_RESOURCE_LIST_MEMBERS RLM , PA_STATUS_RSRC_ACT_HIGH_V SRA , PA_STATUS_RSRC_CMT_HIGH_V SRC , PA_STATUS_RSRC_BGT_COST_HIGH_V SRBC , PA_STATUS_RSRC_BGT_REV_HIGH_V SRBR WHERE SPAH.PROJECT_ID = PA_STATUS.GETPROJID AND SPAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID AND SPAH.TASK_ID = PA_STATUS.GETTASKID AND SPAH.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID AND SPAH.RESOURCE_LIST_MEMBER_ID = SRA.RESOURCE_LIST_MEMBER_ID (+) AND SPAH.RESOURCE_LIST_MEMBER_ID = SRC.RESOURCE_LIST_MEMBER_ID (+) AND SPAH.RESOURCE_LIST_MEMBER_ID = SRBC.RESOURCE_LIST_MEMBER_ID (+) AND SPAH.RESOURCE_LIST_MEMBER_ID = SRBR.RESOURCE_LIST_MEMBER_ID (+)

View Text - HTML Formatted

SELECT SPAH.PROJECT_ID
, SPAH.RESOURCE_LIST_MEMBER_ID
, RLM.ALIAS
, RLM.PARENT_MEMBER_ID
, RLM.MEMBER_LEVEL
, RLM.SORT_ORDER
, SPAH.TASK_ID
, SPAH.RESOURCE_LIST_ID
, SPAH.RESOURCE_LIST_ASSIGNMENT_ID
, DECODE(SPAH.TASK_ID
, 0
, 'Y'
, 'N')
, SRA.RAW_COST_ITD
, SRA.RAW_COST_YTD
, SRA.RAW_COST_PP
, SRA.RAW_COST_PTD
, SRA.BILLABLE_RAW_COST_ITD
, SRA.BILLABLE_RAW_COST_YTD
, SRA.BILLABLE_RAW_COST_PP
, SRA.BILLABLE_RAW_COST_PTD
, SRA.BILLABLE_RAW_COST_ITD
, SRA.BILLABLE_RAW_COST_YTD
, SRA.BILLABLE_RAW_COST_PP
, SRA.BILLABLE_RAW_COST_PTD
, SRA.BURDENED_COST_ITD
, SRA.BURDENED_COST_YTD
, SRA.BURDENED_COST_PP
, SRA.BURDENED_COST_PTD
, SRA.BILLABLE_BURDENED_COST_ITD
, SRA.BILLABLE_BURDENED_COST_YTD
, SRA.BILLABLE_BURDENED_COST_PP
, SRA.BILLABLE_BURDENED_COST_PTD
, SRA.BILLABLE_BURDENED_COST_ITD
, SRA.BILLABLE_BURDENED_COST_YTD
, SRA.BILLABLE_BURDENED_COST_PP
, SRA.BILLABLE_BURDENED_COST_PTD
, SRA.ACTUALS_QUANTITY_ITD
, SRA.ACTUALS_QUANTITY_YTD
, SRA.ACTUALS_QUANTITY_PP
, SRA.ACTUALS_QUANTITY_PTD
, SRA.BILLABLE_QUANTITY_ITD
, SRA.BILLABLE_QUANTITY_YTD
, SRA.BILLABLE_QUANTITY_PP
, SRA.BILLABLE_QUANTITY_PTD
, SRA.ACTUALS_LABOR_HOURS_ITD
, SRA.ACTUALS_LABOR_HOURS_YTD
, SRA.ACTUALS_LABOR_HOURS_PP
, SRA.ACTUALS_LABOR_HOURS_PTD
, SRA.BILLABLE_LABOR_HOURS_ITD
, SRA.BILLABLE_LABOR_HOURS_YTD
, SRA.BILLABLE_LABOR_HOURS_PP
, SRA.BILLABLE_LABOR_HOURS_PTD
, SRA.REVENUE_ITD
, SRA.REVENUE_YTD
, SRA.REVENUE_PP
, SRA.REVENUE_PTD
, SRC.CMT_RAW_COST_ITD
, SRC.CMT_RAW_COST_YTD
, SRC.CMT_RAW_COST_PP
, SRC.CMT_RAW_COST_PTD
, SRC.CMT_BURDENED_COST_ITD
, SRC.CMT_BURDENED_COST_YTD
, SRC.CMT_BURDENED_COST_PP
, SRC.CMT_BURDENED_COST_PTD
, SRC.CMT_QUANTITY_ITD
, SRC.CMT_QUANTITY_YTD
, SRC.CMT_QUANTITY_PP
, SRC.CMT_QUANTITY_PTD
, SRBC.BASELINE_RAW_COST_ITD
, SRBC.BASELINE_RAW_COST_YTD
, SRBC.BASELINE_RAW_COST_PP
, SRBC.BASELINE_RAW_COST_PTD
, SRBC.BASELINE_BURDENED_COST_ITD
, SRBC.BASELINE_BURDENED_COST_YTD
, SRBC.BASELINE_BURDENED_COST_PP
, SRBC.BASELINE_BURDENED_COST_PTD
, SRBC.ORIGINAL_RAW_COST_ITD
, SRBC.ORIGINAL_RAW_COST_YTD
, SRBC.ORIGINAL_RAW_COST_PP
, SRBC.ORIGINAL_RAW_COST_PTD
, SRBC.ORIGINAL_BURDENED_COST_ITD
, SRBC.ORIGINAL_BURDENED_COST_YTD
, SRBC.ORIGINAL_BURDENED_COST_PP
, SRBC.ORIGINAL_BURDENED_COST_PTD
, SRBC.BASELINE_QUANTITY_ITD
, SRBC.BASELINE_QUANTITY_YTD
, SRBC.BASELINE_QUANTITY_PP
, SRBC.BASELINE_QUANTITY_PTD
, SRBC.ORIGINAL_QUANTITY_ITD
, SRBC.ORIGINAL_QUANTITY_YTD
, SRBC.ORIGINAL_QUANTITY_PP
, SRBC.ORIGINAL_QUANTITY_PTD
, SRBC.ORIGINAL_LABOR_HOURS_ITD
, SRBC.ORIGINAL_LABOR_HOURS_YTD
, SRBC.ORIGINAL_LABOR_HOURS_PP
, SRBC.ORIGINAL_LABOR_HOURS_PTD
, SRBC.BASELINE_LABOR_HOURS_ITD
, SRBC.BASELINE_LABOR_HOURS_YTD
, SRBC.BASELINE_LABOR_HOURS_PP
, SRBC.BASELINE_LABOR_HOURS_PTD
, SRBC.BASELINE_RAW_COST_TOT
, SRBC.BASELINE_BURDENED_COST_TOT
, SRBC.ORIGINAL_RAW_COST_TOT
, SRBC.ORIGINAL_BURDENED_COST_TOT
, SRBC.ORIGINAL_LABOR_HOURS_TOT
, SRBC.BASELINE_LABOR_HOURS_TOT
, SRBC.BASELINE_QUANTITY_TOT
, SRBC.ORIGINAL_QUANTITY_TOT
, SRBR.BASELINE_REVENUE_ITD
, SRBR.BASELINE_REVENUE_YTD
, SRBR.BASELINE_REVENUE_PP
, SRBR.BASELINE_REVENUE_PTD
, SRBR.ORIGINAL_REVENUE_ITD
, SRBR.ORIGINAL_REVENUE_YTD
, SRBR.ORIGINAL_REVENUE_PP
, SRBR.ORIGINAL_REVENUE_PTD
, SRBR.BASELINE_QUANTITY_ITD
, SRBR.BASELINE_QUANTITY_YTD
, SRBR.BASELINE_QUANTITY_PP
, SRBR.BASELINE_QUANTITY_PTD
, SRBR.ORIGINAL_QUANTITY_ITD
, SRBR.ORIGINAL_QUANTITY_YTD
, SRBR.ORIGINAL_QUANTITY_PP
, SRBR.ORIGINAL_QUANTITY_PTD
, SRBR.ORIGINAL_LABOR_HOURS_ITD
, SRBR.ORIGINAL_LABOR_HOURS_YTD
, SRBR.ORIGINAL_LABOR_HOURS_PP
, SRBR.ORIGINAL_LABOR_HOURS_PTD
, SRBR.BASELINE_LABOR_HOURS_ITD
, SRBR.BASELINE_LABOR_HOURS_YTD
, SRBR.BASELINE_LABOR_HOURS_PP
, SRBR.BASELINE_LABOR_HOURS_PTD
, SRBR.BASELINE_REVENUE_TOT
, SRBR.ORIGINAL_REVENUE_TOT
, SRBR.ORIGINAL_LABOR_HOURS_TOT
, SRBR.BASELINE_LABOR_HOURS_TOT
, SRBR.BASELINE_QUANTITY_TOT
, SRBR.ORIGINAL_QUANTITY_TOT
FROM PA_STATUS_PROJ_ACCUM_HEADERS_V SPAH
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_STATUS_RSRC_ACT_HIGH_V SRA
, PA_STATUS_RSRC_CMT_HIGH_V SRC
, PA_STATUS_RSRC_BGT_COST_HIGH_V SRBC
, PA_STATUS_RSRC_BGT_REV_HIGH_V SRBR
WHERE SPAH.PROJECT_ID = PA_STATUS.GETPROJID
AND SPAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID
AND SPAH.TASK_ID = PA_STATUS.GETTASKID
AND SPAH.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND SPAH.RESOURCE_LIST_MEMBER_ID = SRA.RESOURCE_LIST_MEMBER_ID (+)
AND SPAH.RESOURCE_LIST_MEMBER_ID = SRC.RESOURCE_LIST_MEMBER_ID (+)
AND SPAH.RESOURCE_LIST_MEMBER_ID = SRBC.RESOURCE_LIST_MEMBER_ID (+)
AND SPAH.RESOURCE_LIST_MEMBER_ID = SRBR.RESOURCE_LIST_MEMBER_ID (+)