View: GMS_STATUS_ACTUALS_BASE1_V

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

View Text

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

Columns