VIEW: APPS.PA_BURDEN_COMPONENT_COST_V

Source

View Text - Preformatted

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.COST_IND_COMPILED_SET_ID , BDB.COST_BASE , BDB.BCC_PRECEDENCE , BDB.BURDEN_COST_CODE , BDB.INPUT_MULTIPLIER , BDB.COMPILED_MULTIPLIER , SUM(NVL(TA.TOT_RAW_COST,0)) , PA_CURRENCY.ROUND_CURRENCY_AMT(SUM( NVL(TA.TOT_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.COST_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.COST_IND_COMPILED_SET_ID, BDB.COST_BASE, BDB.BCC_PRECEDENCE , BDB.BURDEN_COST_CODE, BDB.INPUT_MULTIPLIER, BDB.COMPILED_MULTIPLIER

View Text - HTML Formatted

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.COST_IND_COMPILED_SET_ID
, BDB.COST_BASE
, BDB.BCC_PRECEDENCE
, BDB.BURDEN_COST_CODE
, BDB.INPUT_MULTIPLIER
, BDB.COMPILED_MULTIPLIER
, SUM(NVL(TA.TOT_RAW_COST
, 0))
, PA_CURRENCY.ROUND_CURRENCY_AMT(SUM( NVL(TA.TOT_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.COST_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.COST_IND_COMPILED_SET_ID
, BDB.COST_BASE
, BDB.BCC_PRECEDENCE
, BDB.BURDEN_COST_CODE
, BDB.INPUT_MULTIPLIER
, BDB.COMPILED_MULTIPLIER