Product: | IPA - Capital Resource Logistics - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_CDL_BURDEN_DETAIL_V |
SELECT P.PROJECT_ID
, T.TASK_ID
, PT.BURDEN_SUM_DEST_PROJECT_ID DEST_PROJECT_ID
, PT.BURDEN_SUM_DEST_TASK_ID DEST_TASK_ID
, ICS.ORGANIZATION_ID
, CDL.PA_DATE
, EI.ATTRIBUTE1
, CM.IND_COST_CODE
, EI.EXPENDITURE_TYPE EI_EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, CB.COST_BASE
, CM.COMPILED_MULTIPLIER
, IRS.IND_RATE_SCH_ID
, IRSR.IND_RATE_SCH_REVISION_ID
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, EI.EXPENDITURE_ITEM_DATE
, ROUND(CDL.AMOUNT * CM.COMPILED_MULTIPLIER
, 2) BURDEN_COST
, ROUND(CDL.DENOM_RAW_COST * CM.COMPILED_MULTIPLIER
, 2) DENOM_BURDENED_COST
, ROUND(CDL.ACCT_RAW_COST * CM.COMPILED_MULTIPLIER
, 2) ACCT_BURDENED_COST
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, EI.DENOM_CURRENCY_CODE
, EI.ACCT_CURRENCY_CODE
, EI.PROJECT_CURRENCY_CODE
FROM PA_COMPILED_MULTIPLIERS CM
, PA_COST_BASE_EXP_TYPES CBET
, PA_IND_COST_CODES ICC
, PA_COST_BASES CB
, PA_IND_COMPILED_SETS ICS
, PA_IND_RATE_SCH_REVISIONS IRSR
, PA_IND_RATE_SCHEDULES_ALL_BG IRS
, PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_ITEMS EI
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_PROJECT_TYPES_ALL PT
, PA_TASKS T
, PA_PROJECTS_ALL P
WHERE ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND IRS.IND_RATE_SCH_ID = IRSR.IND_RATE_SCH_ID
AND IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CBET.COST_BASE = CM.COST_BASE
AND CB.COST_BASE = CBET.COST_BASE
AND CB.COST_BASE_TYPE = CBET.COST_BASE_TYPE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = EI.EXPENDITURE_TYPE
AND ICS.ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
AND ICS.IND_COMPILED_SET_ID = CDL.IND_COMPILED_SET_ID
AND ICS.STATUS = 'A'
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CM.IND_COMPILED_SET_ID = CDL.IND_COMPILED_SET_ID
AND CDL.BURDEN_SUM_REJECTION_CODE IS NULL
AND CDL.LINE_TYPE = 'R'
AND CDL.BURDEN_SUM_SOURCE_RUN_ID +0 = - 9999
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EI.TASK_ID = T.TASK_ID
AND T.PROJECT_ID = P.PROJECT_ID
AND NVL(PT.ORG_ID
, -99) = NVL(P.ORG_ID
, -99)
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND P.PROJECT_ID = PA_BURDEN_COSTING.GET_CURRENT_PROJECT_ID()