View: GMS_RXI_EXP_DETAILS_V

View Text

SELECT P.SEGMENT1 PROJECT_NUMBER
, T.TASK_NUMBER
, A.AWARD_NUMBER
, A.STATUS
, DECODE(A.STATUS
, 'CLOSED'
, 'N'
, 'Y') STATUS_FLAG
, A.END_DATE_ACTIVE
, O.NAME EXPENDITURE_ORG
, EI.EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, VAR.SOURCE_ID
, CDL.AMOUNT RAW_COST
, ADL.BURDENABLE_RAW_COST BURDENABLE_COST
, CM.COMPILED_MULTIPLIER IDC_MULTIPLIER
, PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1((DECODE(ADL.AWARD_ID
, NULL
, CDL.AMOUNT
, NVL(ADL.BURDENABLE_RAW_COST
, 0)) * CM.COMPILED_MULTIPLIER)
, CDL.PROJFUNC_CURRENCY_CODE) BURDEN_COST
, NULL REQUEST_ID
, CDL.PROJECT_ID
, EI.TASK_ID
, ADL.AWARD_ID
FROM GMS_RXI_BURDEN_VARIANCE VAR
, GMS_AWARDS_ALL A
, PA_PROJECTS_ALL P
, PA_TASKS T
, HR_ORGANIZATION_UNITS O
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS EI
, PA_EXPENDITURES_ALL E
, PA_TRANSACTION_SOURCES PTS
, GMS_AWARD_DISTRIBUTIONS ADL
, PA_IND_COST_CODES ICC
, PA_COMPILED_MULTIPLIERS CM
, PA_IND_COMPILED_SETS ICS
, PA_COST_BASE_EXP_TYPES CBET
, PA_IND_RATE_SCH_REVISIONS IRSR
WHERE ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND CBET.COST_BASE = CM.COST_BASE
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.COST_BASE = CBET.COST_BASE*/
AND ICS.IND_COMPILED_SET_ID = NVL( ADL.IND_COMPILED_SET_ID
, CDL.IND_COMPILED_SET_ID )
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CM.IND_COMPILED_SET_ID = DECODE(CBET.COST_BASE
, NULL
, NULL
, NVL( ADL.IND_COMPILED_SET_ID
, CDL.IND_COMPILED_SET_ID ))
AND ADL.EXPENDITURE_ITEM_ID (+) = CDL.EXPENDITURE_ITEM_ID
AND DECODE(ADL.AWARD_SET_ID
, NULL
, CDL.LINE_NUM
, NVL(ADL.CDL_LINE_NUM
, 0)) = CDL.LINE_NUM
AND NVL(ADL.ADL_STATUS
, 'A') = 'A'
AND NVL(ADL.DOCUMENT_TYPE
, 'EXP') = 'EXP'
AND CDL.BURDEN_SUM_REJECTION_CODE IS NULL
AND CDL.LINE_TYPE = 'R'
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND EI.TRANSACTION_SOURCE = PTS.TRANSACTION_SOURCE (+)
AND NVL(PTS.ALLOW_BURDEN_FLAG
, 'N') <> 'Y'
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND CDL.BURDEN_SUM_SOURCE_RUN_ID <> -9999
AND CM.COMPILED_MULTIPLIER <> 0
AND VAR.SOURCE_ID = CDL.BURDEN_SUM_SOURCE_RUN_ID
AND VAR.PROJECT_ID = CDL.PROJECT_ID
AND VAR.TASK_ID = EI.TASK_ID
AND VAR.AWARD_ID = ADL.AWARD_ID
AND VAR.SOURCE_ORG_ID = ICS.ORGANIZATION_ID
AND VAR.EXPENDITURE_TYPE = ICC.EXPENDITURE_TYPE
AND VAR.DIFF_AMOUNT <> 0
AND VAR.AWARD_ID = A.AWARD_ID
AND VAR.PROJECT_ID = P.PROJECT_ID
AND VAR.TASK_ID = T.TASK_ID
AND VAR.SOURCE_ORG_ID = O.ORGANIZATION_ID

Columns