eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMS_CDL_BURDEN_DETAIL_V

Source

View Text - Preformatted


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 ICS.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 = NVL( ADL.IND_COMPILED_SET_ID ,CDL.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

View Text - HTML Formatted

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 ICS.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 = NVL( ADL.IND_COMPILED_SET_ID
, CDL.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