View: GMS_NONE_BAL_V

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

View Text

SELECT PROJECT_ID
, AWARD_ID
, TASK_ID
, BUDGET_VERSION_ID
, MAX(START_DATE) START_DATE
, MIN(END_DATE) END_DATE
FROM GMS_BALANCES
WHERE BALANCE_TYPE = 'BGT' GROUP BY PROJECT_ID
, AWARD_ID
, TASK_ID
, BUDGET_VERSION_ID

Columns