View: GMS_RXI_BURDEN_EXCEPTION_V

View Text

SELECT AWD.AWARD_NUMBER AWARD_NUMBER
, AWD.AWARD_ID AWARD_ID
, AWD.STATUS AWARD_STATUS
, DECODE(AWD.STATUS
, 'CLOSED'
, 'N'
, 'Y') STATUS_FLAG
, AWD.END_DATE_ACTIVE AWARD_END_DATE
, P.SEGMENT1 PROJECT_NUMBER
, P.PROJECT_ID PROJECT_ID
, T.TASK_NUMBER TASK_NUMBER
, T.TASK_ID TASK_ID
, O.NAME EXPENDITURE_ORG
, VAR.EXPENDITURE_TYPE EXPENDITURE_TYPE
, ICC.EXPENDITURE_TYPE ICC_EXPENDITURE_TYPE
, VAR.DOC_TYPE DOCUMENT_TYPE
, VAR.DOC_NUMBER DOCUMENT_NUMBER
, VAR.LINE_NUMBER LINE_NUMBER
, VAR.DOC_DIST_NUM DIST_NUMBER
, VAR.FC_STATUS FC_STATUS
, VAR.ENCUMBERED_FLAG ENCUMBERED_FLAG
, VAR.AMOUNT RAW_COST
, VAR.BURDENABLE_COST BURDENABLE_RAW_COST
, CM.COMPILED_MULTIPLIER IDC_MULTIPLIER
, (VAR.BURDENABLE_COST * CM.COMPILED_MULTIPLIER) BURDEN_COST
, VAR.BURDEN_COST_LIMIT BURDEN_COST_LIMIT
FROM GMS_RXI_BURDEN_EXCEPTION VAR
, 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
, HR_ORGANIZATION_UNITS O
, GMS_AWARDS_ALL AWD
, PA_PROJECTS_ALL P
, PA_TASKS T
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 = VAR.EXPENDITURE_TYPE
AND ICS.ORGANIZATION_ID = VAR.EXPENDITURE_ORGANIZATION_ID /*AND ICS.COST_BASE = CBET.COST_BASE */
AND ICS.IND_COMPILED_SET_ID = VAR.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
, VAR.IND_COMPILED_SET_ID)
AND CM.COMPILED_MULTIPLIER <> 0
AND O.ORGANIZATION_ID = VAR.EXPENDITURE_ORGANIZATION_ID
AND VAR.AWARD_ID = AWD.AWARD_ID
AND VAR.PROJECT_ID = P.PROJECT_ID
AND VAR.TASK_ID = T.TASK_ID

Columns