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_STATUS_ACTUALS_BASE1_V

Source

View Text - Preformatted


SELECT award_id, project_id, task_id, expenditure_item_id, sum(revenue_amount) revenue_amount, sum(billed_amount) billed_amount, sum(raw_cost) raw_cost, sum(burdened_cost) burdened_cost, pa_date, gl_date, invoice_id from (SELECT adl.award_id, adl.project_id, adl.task_id, adl.expenditure_item_id, NVL (DECODE (adl.revenue_distributed_flag, 'Y', adl.raw_cost, 0), 0 ) revenue_amount, NVL (DECODE (adl.billed_flag, 'Y', adl.raw_cost, 0), 0 ) billed_amount, adl.raw_cost, cdl.burdened_cost, cdl.pa_date, cdl.gl_date, to_number(cdl.system_reference2) invoice_id FROM gms_award_distributions adl, pa_cost_distribution_lines_all cdl WHERE adl.adl_status = 'A' AND cdl.expenditure_item_id = adl.expenditure_item_id AND cdl.line_num = adl.cdl_line_num AND adl.document_type = 'EXP' UNION ALL SELECT adl.award_id award_id, adl.project_id project_id, adl.task_id task_id, gbc.expenditure_item_id expenditure_item_id, NVL (decode(gbc.event_type, 'REVENUE', gbc.amount, 0), 0) revenue_amount, NVL (decode(gbc.event_type, 'INVOICE', gbc.amount, 0), 0) billed_amount, 0 raw_cost, 0 burdened_cost, cdl.pa_date pa_date, cdl.gl_date gl_date, to_number(cdl.system_reference2) invoice_id FROM gms_burden_components gbc, pa_cost_distribution_lines_all cdl, gms_award_distributions adl WHERE gbc.event_num IS NOT NULL AND gbc.expenditure_item_id = adl.expenditure_item_id AND gbc.adl_line_num = adl.adl_line_num AND cdl.expenditure_item_id = adl.expenditure_item_id AND cdl.line_num = adl.cdl_line_num AND adl.document_type = 'EXP' AND adl.adl_status = 'A' ) group by award_id, project_id, task_id, expenditure_item_id, pa_date,gl_date, invoice_id

View Text - HTML Formatted

SELECT AWARD_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ITEM_ID
, SUM(REVENUE_AMOUNT) REVENUE_AMOUNT
, SUM(BILLED_AMOUNT) BILLED_AMOUNT
, SUM(RAW_COST) RAW_COST
, SUM(BURDENED_COST) BURDENED_COST
, PA_DATE
, GL_DATE
, INVOICE_ID
FROM (SELECT ADL.AWARD_ID
, ADL.PROJECT_ID
, ADL.TASK_ID
, ADL.EXPENDITURE_ITEM_ID
, NVL (DECODE (ADL.REVENUE_DISTRIBUTED_FLAG
, 'Y'
, ADL.RAW_COST
, 0)
, 0 ) REVENUE_AMOUNT
, NVL (DECODE (ADL.BILLED_FLAG
, 'Y'
, ADL.RAW_COST
, 0)
, 0 ) BILLED_AMOUNT
, ADL.RAW_COST
, CDL.BURDENED_COST
, CDL.PA_DATE
, CDL.GL_DATE
, TO_NUMBER(CDL.SYSTEM_REFERENCE2) INVOICE_ID
FROM GMS_AWARD_DISTRIBUTIONS ADL
, PA_COST_DISTRIBUTION_LINES_ALL CDL
WHERE ADL.ADL_STATUS = 'A'
AND CDL.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
AND CDL.LINE_NUM = ADL.CDL_LINE_NUM
AND ADL.DOCUMENT_TYPE = 'EXP' UNION ALL SELECT ADL.AWARD_ID AWARD_ID
, ADL.PROJECT_ID PROJECT_ID
, ADL.TASK_ID TASK_ID
, GBC.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, NVL (DECODE(GBC.EVENT_TYPE
, 'REVENUE'
, GBC.AMOUNT
, 0)
, 0) REVENUE_AMOUNT
, NVL (DECODE(GBC.EVENT_TYPE
, 'INVOICE'
, GBC.AMOUNT
, 0)
, 0) BILLED_AMOUNT
, 0 RAW_COST
, 0 BURDENED_COST
, CDL.PA_DATE PA_DATE
, CDL.GL_DATE GL_DATE
, TO_NUMBER(CDL.SYSTEM_REFERENCE2) INVOICE_ID
FROM GMS_BURDEN_COMPONENTS GBC
, PA_COST_DISTRIBUTION_LINES_ALL CDL
, GMS_AWARD_DISTRIBUTIONS ADL
WHERE GBC.EVENT_NUM IS NOT NULL
AND GBC.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
AND GBC.ADL_LINE_NUM = ADL.ADL_LINE_NUM
AND CDL.EXPENDITURE_ITEM_ID = ADL.EXPENDITURE_ITEM_ID
AND CDL.LINE_NUM = ADL.CDL_LINE_NUM
AND ADL.DOCUMENT_TYPE = 'EXP'
AND ADL.ADL_STATUS = 'A' ) GROUP BY AWARD_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ITEM_ID
, PA_DATE
, GL_DATE
, INVOICE_ID