VIEW: APPS.PA_CMT_BY_PA_PERIOD_V

Source

View Text - Preformatted

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_CMT_QUANTITY, 0)) , SUM(NVL(TA.TOT_CMT_RAW_COST, 0)) , SUM(NVL(TA.TOT_CMT_BURDENED_COST, 0)) , PER.ORG_ID 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,PER.ORG_ID

View Text - HTML Formatted

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_CMT_QUANTITY
, 0))
, SUM(NVL(TA.TOT_CMT_RAW_COST
, 0))
, SUM(NVL(TA.TOT_CMT_BURDENED_COST
, 0))
, PER.ORG_ID
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
, PER.ORG_ID