[Home] [Help]
View: PA_CMT_BY_PA_PERIOD_V
Product: | PA - Projects |
Description: | This view displays current commitment totals for lowest level tasks and resources by PA periods. |
Implementation/DBA Data: |
APPS.PA_CMT_BY_PA_PERIOD_V
|
View Text
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
Columns
Name |
PROJECT_ID |
TASK_ID |
RESOURCE_LIST_MEMBER_ID |
RESOURCE_LIST_ID |
PA_PERIOD_NAME |
PERIOD_START_DATE |
PERIOD_END_DATE |
CMT_QUANTITY |
CMT_RAW_COST |
CMT_BURDENED_COST |
ORG_ID |