View: GMS_TASK_BAL_V

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

View Text

SELECT PROJECT_ID
, AWARD_ID
, TOP_TASK_ID
, GMS_BUDGET_UTILS.GET_TASK_NUMBER(TOP_TASK_ID)
, BUDGET_VERSION_ID
, START_DATE
, END_DATE
, SUM(BUDGET)
, SUM(ACTUALS)
, SUM(ENCUMBRANCES)
FROM GMS_AWARD_BAL_V GROUP BY BUDGET_VERSION_ID
, AWARD_ID
, PROJECT_ID
, TOP_TASK_ID
, GMS_BUDGET_UTILS.GET_TASK_NUMBER(TOP_TASK_ID)
, START_DATE
, END_DATE

Columns