Product: | PA - Projects |
---|---|
Description: | This view displays commitment burden components for each transaction |
Implementation/DBA Data: | APPS.PA_BURDEN_COMPONENT_CMT_V |
SELECT RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_ID
, RL.NAME
, RAD.RESOURCE_LIST_MEMBER_ID
, RLM.ALIAS
, TA.ORGANIZATION_ID
, BDB.EXPENDITURE_ORGANIZATION
, TA.PA_PERIOD
, TA.CMT_IND_COMPILED_SET_ID
, BDB.COST_BASE
, BDB.BCC_PRECEDENCE
, BDB.BURDEN_COST_CODE
, BDB.INPUT_MULTIPLIER
, BDB.COMPILED_MULTIPLIER
, SUM(NVL(TA.TOT_CMT_RAW_COST
, 0))
, PA_CURRENCY.ROUND_CURRENCY_AMT(SUM( NVL(TA.TOT_CMT_RAW_COST
, 0) * BDB.COMPILED_MULTIPLIER) )
FROM PA_RESOURCE_ACCUM_DETAILS RAD
, PA_TXN_ACCUM TA
, PA_BURDEN_DETAILS_BASE_V BDB
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_LISTS RL
WHERE RAD.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND RAD.RESOURCE_LIST_ID = RL.RESOURCE_LIST_ID
AND RAD.TXN_ACCUM_ID = TA.TXN_ACCUM_ID
AND TA.ORGANIZATION_ID = BDB.EXPENDITURE_ORGANIZATION_ID
AND TA.EXPENDITURE_TYPE = BDB.EXPENDITURE_TYPE
AND TA.CMT_IND_COMPILED_SET_ID = BDB.COMPILED_SET_ID GROUP BY RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_ID
, RL.NAME
, RAD.RESOURCE_LIST_MEMBER_ID
, RLM.ALIAS
, TA.ORGANIZATION_ID
, BDB.EXPENDITURE_ORGANIZATION
, TA.PA_PERIOD
, TA.CMT_IND_COMPILED_SET_ID
, BDB.COST_BASE
, BDB.BCC_PRECEDENCE
, BDB.BURDEN_COST_CODE
, BDB.INPUT_MULTIPLIER
, BDB.COMPILED_MULTIPLIER