View: GMS_CDL_BURDEN_DETAIL_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_CDL_BURDEN_DETAIL_V

View Text

SELECT CDL.PROJECT_ID
, CDL.TASK_ID
, P.SEGMENT1
, ICS.ORGANIZATION_ID
, CDL.PA_DATE
, ADL.AWARD_ID
, ADL.AWARD_SET_ID
, ADL.ADL_STATUS
, 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
, ADL.ADL_LINE_NUM
, CDL.LINE_NUM
, EI.EXPENDITURE_ITEM_DATE
, ADL.RAW_COST
, NVL(ADL.BURDENABLE_RAW_COST
, 0) * CM.COMPILED_MULTIPLIER
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, CDL.ORG_ID
, CDL.GL_DATE
, EI.SYSTEM_LINKAGE_FUNCTION
, CDL.LINE_TYPE
, CDL.CREATION_DATE
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
, PA_TRANSACTION_SOURCES PTS
, PA_PROJECTS_ALL P
, PA_PROJECT_TYPES PT
, PA_IND_COST_CODES ICC
, PA_COMPILED_MULTIPLIERS CM
, PA_IND_COMPILED_SETS ICS
, PA_COST_BASE_EXP_TYPES CBET
, PA_COST_BASES CB
, PA_IND_RATE_SCH_REVISIONS IRSR
, PA_IND_RATE_SCHEDULES_ALL_BG IRS
, GMS_AWARD_DISTRIBUTIONS ADL
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 = CM.IND_COMPILED_SET_ID
AND ICC.IND_COST_CODE = CM.IND_COST_CODE
AND ICS.IND_COMPILED_SET_ID = ADL.IND_COMPILED_SET_ID
AND ADL.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND ADL.CDL_LINE_NUM = CDL.LINE_NUM
AND ADL.ADL_STATUS = 'A'
AND ADL.FC_STATUS = 'A'
AND ADL.DOCUMENT_TYPE='EXP'
AND NVL( ADL.BURDENABLE_RAW_COST
, 0) <> 0
AND CDL.BURDEN_SUM_REJECTION_CODE IS NULL
AND CDL.LINE_TYPE = 'R'
AND NVL(CDL.AMOUNT
, 0) <> 0
AND CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND ((GMS_BURDEN_COSTING.GET_CURRENT_PROJECT_ID IS NOT NULL
AND CDL.PROJECT_ID = GMS_BURDEN_COSTING.GET_CURRENT_PROJECT_ID ) OR (GMS_BURDEN_COSTING.GET_CURRENT_PROJECT_ID IS NULL))
AND P.PROJECT_ID =CDL.PROJECT_ID
AND EI.TRANSACTION_SOURCE = PTS.TRANSACTION_SOURCE(+)
AND NVL(PTS.ALLOW_BURDEN_FLAG
, 'N') <> 'Y'
AND P.ORG_ID = PT.ORG_ID

Columns