View: GMS_RXI_EXPENDITURES_INQ_V

View Text

SELECT AWD.AWARD_NUMBER
, AWD.STATUS
, DECODE(AWD.STATUS
, 'CLOSED'
, 'N'
, 'Y') STATUS_FLAG
, AWD.END_DATE_ACTIVE
, P.SEGMENT1
, P.PROJECT_ID
, AWD.AWARD_ID
, T.TASK_ID
, T.TASK_NUMBER
, EI.EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE
, O.NAME
, EI.COST_DISTRIBUTED_FLAG
, EI.RAW_COST
, EI.BILLABLE_FLAG
, SYSF.MEANING
, DECODE ( GMS_RXI_BURDEN_PKG.GET_EXP_FLAG_COUNTS(EI.EXPENDITURE_ITEM_ID
, 'F')
, 1
, ADL.FC_STATUS
, 0
, NULL
, 'P-PARTIAL') FC_STATUS
, DECODE ( GMS_RXI_BURDEN_PKG.GET_EXP_FLAG_COUNTS(EI.EXPENDITURE_ITEM_ID
, 'B')
, 1
, ADL.BILLED_FLAG
, 0
, NULL
, 'P-PARTIAL') BILLED
, DECODE ( GMS_RXI_BURDEN_PKG.GET_EXP_FLAG_COUNTS(EI.EXPENDITURE_ITEM_ID
, 'R')
, 1
, ADL.REVENUE_DISTRIBUTED_FLAG
, 0
, NULL
, 'P-PARTIAL') REVENUE_DISTRIBUTED_FLAG
, DECODE ( GMS_RXI_BURDEN_PKG.GET_EXP_FLAG_COUNTS(EI.EXPENDITURE_ITEM_ID
, 'C')
, 1
, 'N'
, 0
, 'N'
, 'Y') CDL_DUPLICATE
, E.EXPENDITURE_GROUP
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
, GMS_AWARD_DISTRIBUTIONS ADL
, PA_SYSTEM_LINKAGES SYSF
, GMS_AWARDS_ALL AWD
, PA_PROJECTS_ALL P
, PA_TASKS T
, HR_ORGANIZATION_UNITS O
WHERE EI.EXPENDITURE_ID = E.EXPENDITURE_ID
AND EI.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
AND ADL.AWARD_ID = AWD.AWARD_ID
AND EI.PROJECT_ID = P.PROJECT_ID
AND EI.TASK_ID = T.TASK_ID
AND ADL.ADL_STATUS = 'A'
AND ADL.ADL_LINE_NUM = 1
AND SYSF.FUNCTION = EI.SYSTEM_LINKAGE_FUNCTION
AND EI.SYSTEM_LINKAGE_FUNCTION <> 'BTC'
AND O.ORGANIZATION_ID = NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)

Columns