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