View: PA_COST_BURDEN_DETAILS_V

Product:	PA - Projects
Description:	View of individual burden cost components of the burdened cost of each expenditure item that is burdened.
Implementation/DBA Data:	APPS.PA_COST_BURDEN_DETAILS_V

View Text

SELECT P.SEGMENT1
, P.NAME
, P.PROJECT_ID
, T.TASK_NUMBER
, T.TASK_NAME
, T.TASK_ID
, BDB.EXPENDITURE_ORGANIZATION
, BDB.EXPENDITURE_ORGANIZATION_ID
, EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_DATE
, CDL.PA_DATE
, CDL.GL_DATE
, CDL.AMOUNT
, CDL.BURDENED_COST
, PA_CURRENCY.ROUND_CURRENCY_AMT(CDL.AMOUNT * BDB.COMPILED_MULTIPLIER)
, BDB.COST_BASE
, BDB.CB_SORT_ORDER
, BDB.BURDEN_COST_CODE
, BDB.BCC_PRECEDENCE
, BDB.INPUT_MULTIPLIER
, BDB.COMPILED_MULTIPLIER
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, BDB.BURDEN_SCHEDULE
, BDB.BURDEN_SCHEDULE_ID
, BDB.BURDEN_SCHEDULE_REVISION
, BDB.BURDEN_SCHEDULE_REVISION_ID
, BDB.BURDEN_STRUCTURE
, BDB.COMPILED_SET_ID
, CDL.DENOM_CURRENCY_CODE
, CDL.DENOM_RAW_COST
, PA_CURRENCY.ROUND_CURRENCY_AMT(CDL.DENOM_RAW_COST * BDB.COMPILED_MULTIPLIER)
, CDL.DENOM_BURDENED_COST
, CDL.ACCT_CURRENCY_CODE
, CDL.ACCT_RAW_COST
, PA_CURRENCY.ROUND_CURRENCY_AMT(CDL.ACCT_RAW_COST * BDB.COMPILED_MULTIPLIER)
, CDL.ACCT_BURDENED_COST
FROM PA_BURDEN_DETAILS_BASE_V BDB
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPENDITURES E
, PA_EXPENDITURE_ITEMS EI
, PA_COST_DISTRIBUTION_LINES CDL
WHERE BDB.COMPILED_SET_ID = CDL.IND_COMPILED_SET_ID
AND BDB.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND BDB.EXPENDITURE_ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND CDL.LINE_TYPE = 'R'
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND T.TASK_ID = EI.TASK_ID
AND P.PROJECT_ID = T.PROJECT_ID

Columns