View: GMS_AWD_V

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

View Text

SELECT GMS.AWARD_ID
, AW.AWARD_SHORT_NAME
, GMS.BUDGET_VERSION_ID
, GMS.START_DATE
, GMS.END_DATE
, SUM(GMS.BUDGET)
, SUM(GMS.ACTUALS)
, SUM(GMS.ENCUMBRANCES)
FROM GMS_AWARD_BAL_V GMS
, GMS_AWARDS AW
WHERE GMS.AWARD_ID = AW.AWARD_ID GROUP BY GMS.BUDGET_VERSION_ID
, GMS.AWARD_ID
, AW.AWARD_SHORT_NAME
, GMS.START_DATE
, GMS.END_DATE

Columns