eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GMS_BUDG_CONTROL_RES_GRP_V

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

View Text

SELECT GBC.ROWID
, GBC.PROJECT_ID
, GBC.TASK_ID
, GBC.AWARD_ID
, GBC.BUDGETARY_CONTROLS_ID
, GBC.FUNDS_CONTROL_LEVEL_CODE
, PRLM.RESOURCE_LIST_ID
, GBC.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, PRLM.RESOURCE_ID
, PR.NAME RESOURCE_NAME
, GBC.LAST_UPDATED_BY
, GBC.LAST_UPDATE_DATE
, GBC.CREATED_BY
, GBC.CREATION_DATE
, GBC.LAST_UPDATE_LOGIN
, GBC.PARENT_MEMBER_ID
FROM PA_RESOURCE_LISTS PRL
, PA_RESOURCE_LIST_MEMBERS PRLM
, PA_RESOURCES PR
, GMS_BUDGETARY_CONTROLS GBC
WHERE PRL.RESOURCE_LIST_ID = PRLM.RESOURCE_LIST_ID
AND PRLM.RESOURCE_ID = PR.RESOURCE_ID
AND PRLM.RESOURCE_LIST_MEMBER_ID = GBC.RESOURCE_LIST_MEMBER_ID

Columns

Name
ROW_ID
PROJECT_ID
TASK_ID
AWARD_ID
BUDGETARY_CONTROLS_ID
FUNDS_CONTROL_LEVEL_CODE
RESOURCE_LIST_ID
RESOURCE_LIST_MEMBER_ID
ALIAS
RESOURCE_ID
RESOURCE_NAME
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
PARENT_MEMBER_ID