Product: | PA - Projects |
---|---|
Description: | Actual cost and revenue totals for lowest level tasks and resources by PA period. |
Implementation/DBA Data: | APPS.PA_ACT_BY_PA_PERIOD_V |
SELECT RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_MEMBER_ID
, RAD.RESOURCE_LIST_ID
, TA.PA_PERIOD
, PER.START_DATE
, PER.END_DATE
, SUM(NVL(TA.TOT_REVENUE
, 0))
, SUM(NVL(TA.TOT_RAW_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_RAW_COST
, 0))
, SUM(NVL(TA.TOT_BURDENED_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_BURDENED_COST
, 0))
, SUM(NVL(TA.TOT_QUANTITY
, 0))
, SUM(NVL(TA.TOT_LABOR_HOURS
, 0))
, SUM(NVL(TA.TOT_BILLABLE_RAW_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_BURDENED_COST
, 0))
, SUM(NVL(TA.TOT_BILLABLE_QUANTITY
, 0))
, SUM(NVL(TA.TOT_BILLABLE_LABOR_HOURS
, 0))
FROM PA_RESOURCE_ACCUM_DETAILS RAD
, PA_TXN_ACCUM TA
, PA_PERIODS PER
WHERE RAD.TXN_ACCUM_ID = TA.TXN_ACCUM_ID
AND TA.PA_PERIOD = PER.PERIOD_NAME GROUP BY RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_MEMBER_ID
, RAD.RESOURCE_LIST_ID
, TA.PA_PERIOD
, PER.START_DATE
, PER.END_DATE