View: GMS_RESG_BAL_V

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

View Text

SELECT GB.PROJECT_ID
, GB.AWARD_ID
, GB.TASK_ID
, GB.BUDGET_VERSION_ID BUDGET_VERSION_ID
, NVL(GB.PARENT_MEMBER_ID
, GB.RESOURCE_LIST_MEMBER_ID) PARENT_MEMBER_ID
, MIN(GB.START_DATE) START_DATE
, MAX(GB.END_DATE) END_DATE
, SUM(NVL(GB.BUDGET_PERIOD_TO_DATE
, 0)) BUDGET
, SUM(NVL(GB.ACTUAL_PERIOD_TO_DATE
, 0)) ACTUALS
, SUM(NVL(GB.ENCUMB_PERIOD_TO_DATE
, 0)) ENCUMBRANCES
FROM GMS_BALANCES GB
, PA_RESOURCE_LIST_MEMBERS PA
WHERE NVL(GB.PARENT_MEMBER_ID
, GB.RESOURCE_LIST_MEMBER_ID) = PA.RESOURCE_LIST_MEMBER_ID
AND NVL(PA.MEMBER_LEVEL
, 0) = 1 GROUP BY GB.PROJECT_ID
, GB.AWARD_ID
, GB.TASK_ID
, NVL(GB.PARENT_MEMBER_ID
, GB.RESOURCE_LIST_MEMBER_ID)
, GB.BUDGET_VERSION_ID

Columns