Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.PA_STATUS_RSRC_ACT_HIGH_V |
SELECT SRAL.PROJECT_ID
, SRAL.TASK_ID
, SRAL.RESOURCE_LIST_MEMBER_ID
, SRAL.PARENT_MEMBER_ID
, SRAL.RESOURCE_LIST_ASSIGNMENT_ID
, SUM(NVL(SRAL.RAW_COST_ITD
, 0))
, SUM(NVL(SRAL.RAW_COST_YTD
, 0))
, SUM(NVL(SRAL.RAW_COST_PP
, 0))
, SUM(NVL(SRAL.RAW_COST_PTD
, 0))
, SUM(NVL(SRAL.BILLABLE_RAW_COST_ITD
, 0))
, SUM(NVL(SRAL.BILLABLE_RAW_COST_YTD
, 0))
, SUM(NVL(SRAL.BILLABLE_RAW_COST_PP
, 0))
, SUM(NVL(SRAL.BILLABLE_RAW_COST_PTD
, 0))
, SUM(NVL(SRAL.BURDENED_COST_ITD
, 0))
, SUM(NVL(SRAL.BURDENED_COST_YTD
, 0))
, SUM(NVL(SRAL.BURDENED_COST_PP
, 0))
, SUM(NVL(SRAL.BURDENED_COST_PTD
, 0))
, SUM(NVL(SRAL.BILLABLE_BURDENED_COST_ITD
, 0))
, SUM(NVL(SRAL.BILLABLE_BURDENED_COST_YTD
, 0))
, SUM(NVL(SRAL.BILLABLE_BURDENED_COST_PP
, 0))
, SUM(NVL(SRAL.BILLABLE_BURDENED_COST_PTD
, 0))
, SUM(NVL(SRAL.ACTUALS_QUANTITY_ITD
, 0))
, SUM(NVL(SRAL.ACTUALS_QUANTITY_YTD
, 0))
, SUM(NVL(SRAL.ACTUALS_QUANTITY_PP
, 0))
, SUM(NVL(SRAL.ACTUALS_QUANTITY_PTD
, 0))
, SUM(NVL(SRAL.BILLABLE_QUANTITY_ITD
, 0))
, SUM(NVL(SRAL.BILLABLE_QUANTITY_YTD
, 0))
, SUM(NVL(SRAL.BILLABLE_QUANTITY_PP
, 0))
, SUM(NVL(SRAL.BILLABLE_QUANTITY_PTD
, 0))
, SUM(NVL(SRAL.ACTUALS_LABOR_HOURS_ITD
, 0))
, SUM(NVL(SRAL.ACTUALS_LABOR_HOURS_YTD
, 0))
, SUM(NVL(SRAL.ACTUALS_LABOR_HOURS_PP
, 0))
, SUM(NVL(SRAL.ACTUALS_LABOR_HOURS_PTD
, 0))
, SUM(NVL(SRAL.BILLABLE_LABOR_HOURS_ITD
, 0))
, SUM(NVL(SRAL.BILLABLE_LABOR_HOURS_YTD
, 0))
, SUM(NVL(SRAL.BILLABLE_LABOR_HOURS_PP
, 0))
, SUM(NVL(SRAL.BILLABLE_LABOR_HOURS_PTD
, 0))
, SUM(NVL(SRAL.REVENUE_ITD
, 0))
, SUM(NVL(SRAL.REVENUE_YTD
, 0))
, SUM(NVL(SRAL.REVENUE_PP
, 0))
, SUM(NVL(SRAL.REVENUE_PTD
, 0))
FROM PA_STATUS_RSRC_ACT_LOW_V SRAL GROUP BY SRAL.PROJECT_ID
, SRAL.TASK_ID
, SRAL.RESOURCE_LIST_MEMBER_ID
, SRAL.PARENT_MEMBER_ID
, SRAL.RESOURCE_LIST_ASSIGNMENT_ID