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_COMMITMENT_BURDEN_V

Source

View Text - Preformatted


SELECT document_type, transaction_source, cmt_number, description, project_id, task_id, award_id, expenditure_type, expenditure_item_date, organization_id, vendor_name, unit_of_measure, unit_price,pa_period, sum(tot_cmt_quantity) tot_cmt_quantity, sum(acct_raw_cost) acct_raw_cost, sum(acct_burdened_cost) acct_burdened_cost,gl_date FROM ( SELECT document_type, transaction_source, cmt_number, description, project_id, task_id, award_id, expenditure_type, expenditure_item_date, organization_id, vendor_name, unit_of_measure, unit_price,pa_period, tot_cmt_quantity, acct_raw_cost, acct_raw_cost acct_burdened_cost,gl_date FROM gms_commitment_encumbered_v UNION ALL SELECT cmt.document_type, cmt.transaction_source, cmt.cmt_number, cmt.description, cmt.project_id, cmt.task_id, cmt.award_id, icc.expenditure_type, cmt.expenditure_item_date, cmt.organization_id, cmt.vendor_name, cmt.unit_of_measure, cmt.unit_price, cmt.pa_period, 0, 0, NVL (cmt.burdenable_raw_cost, 0) * cm.compiled_multiplier acct_burdened_cost,cmt.gl_date FROM pa_ind_cost_codes icc, pa_cost_base_exp_types cbet, pa_compiled_multipliers cm, gms_commitment_encumbered_v cmt WHERE icc.ind_cost_code = cm.ind_cost_code AND cbet.cost_base = cm.cost_base AND cbet.cost_base_type = 'INDIRECT COST' AND cbet.expenditure_type = cmt.expenditure_type AND cm.ind_compiled_set_id = cmt.ind_compiled_set_id AND cmt.burdenable_raw_cost <> 0 AND cmt.ind_compiled_set_id IS NOT NULL AND cmt.burdenable_raw_cost * cm.compiled_multiplier <> 0 AND EXISTS ( SELECT NULL FROM pa_ind_rate_sch_revisions irsr WHERE irsr.cost_plus_structure = cbet.cost_plus_structure AND EXISTS (SELECT null FROM pa_ind_compiled_sets ics WHERE ics.cost_base = cbet.cost_base AND ics.ind_rate_sch_revision_id = irsr.ind_rate_sch_revision_id AND ics.organization_id = cmt.organization_id AND ics.ind_compiled_set_id = cmt.ind_compiled_set_id ))) GROUP BY document_type, transaction_source, cmt_number, description, project_id, task_id, award_id, expenditure_type, expenditure_item_date, organization_id, vendor_name, unit_of_measure, unit_price,pa_period,gl_date

View Text - HTML Formatted

SELECT DOCUMENT_TYPE
, TRANSACTION_SOURCE
, CMT_NUMBER
, DESCRIPTION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ORGANIZATION_ID
, VENDOR_NAME
, UNIT_OF_MEASURE
, UNIT_PRICE
, PA_PERIOD
, SUM(TOT_CMT_QUANTITY) TOT_CMT_QUANTITY
, SUM(ACCT_RAW_COST) ACCT_RAW_COST
, SUM(ACCT_BURDENED_COST) ACCT_BURDENED_COST
, GL_DATE
FROM ( SELECT DOCUMENT_TYPE
, TRANSACTION_SOURCE
, CMT_NUMBER
, DESCRIPTION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ORGANIZATION_ID
, VENDOR_NAME
, UNIT_OF_MEASURE
, UNIT_PRICE
, PA_PERIOD
, TOT_CMT_QUANTITY
, ACCT_RAW_COST
, ACCT_RAW_COST ACCT_BURDENED_COST
, GL_DATE
FROM GMS_COMMITMENT_ENCUMBERED_V UNION ALL SELECT CMT.DOCUMENT_TYPE
, CMT.TRANSACTION_SOURCE
, CMT.CMT_NUMBER
, CMT.DESCRIPTION
, CMT.PROJECT_ID
, CMT.TASK_ID
, CMT.AWARD_ID
, ICC.EXPENDITURE_TYPE
, CMT.EXPENDITURE_ITEM_DATE
, CMT.ORGANIZATION_ID
, CMT.VENDOR_NAME
, CMT.UNIT_OF_MEASURE
, CMT.UNIT_PRICE
, CMT.PA_PERIOD
, 0
, 0
, NVL (CMT.BURDENABLE_RAW_COST
, 0) * CM.COMPILED_MULTIPLIER ACCT_BURDENED_COST
, CMT.GL_DATE
FROM PA_IND_COST_CODES ICC
, PA_COST_BASE_EXP_TYPES CBET
, PA_COMPILED_MULTIPLIERS CM
, GMS_COMMITMENT_ENCUMBERED_V CMT
WHERE ICC.IND_COST_CODE = CM.IND_COST_CODE
AND CBET.COST_BASE = CM.COST_BASE
AND CBET.COST_BASE_TYPE = 'INDIRECT COST'
AND CBET.EXPENDITURE_TYPE = CMT.EXPENDITURE_TYPE
AND CM.IND_COMPILED_SET_ID = CMT.IND_COMPILED_SET_ID
AND CMT.BURDENABLE_RAW_COST <> 0
AND CMT.IND_COMPILED_SET_ID IS NOT NULL
AND CMT.BURDENABLE_RAW_COST * CM.COMPILED_MULTIPLIER <> 0
AND EXISTS ( SELECT NULL
FROM PA_IND_RATE_SCH_REVISIONS IRSR
WHERE IRSR.COST_PLUS_STRUCTURE = CBET.COST_PLUS_STRUCTURE
AND EXISTS (SELECT NULL
FROM PA_IND_COMPILED_SETS ICS
WHERE ICS.COST_BASE = CBET.COST_BASE
AND ICS.IND_RATE_SCH_REVISION_ID = IRSR.IND_RATE_SCH_REVISION_ID
AND ICS.ORGANIZATION_ID = CMT.ORGANIZATION_ID
AND ICS.IND_COMPILED_SET_ID = CMT.IND_COMPILED_SET_ID ))) GROUP BY DOCUMENT_TYPE
, TRANSACTION_SOURCE
, CMT_NUMBER
, DESCRIPTION
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE
, ORGANIZATION_ID
, VENDOR_NAME
, UNIT_OF_MEASURE
, UNIT_PRICE
, PA_PERIOD
, GL_DATE