View: GMS_BUDGETARY_CONTROL_AWARD_V

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

View Text

SELECT GBC.ROWID
, GBC.PROJECT_ID
, GBC.AWARD_ID
, GA.AWARD_SHORT_NAME
, GA.AWARD_NUMBER
, GBC.FUNDS_CONTROL_LEVEL_CODE
, GBC.LAST_UPDATED_BY
, GBC.LAST_UPDATE_DATE
, GBC.CREATED_BY
, GBC.CREATION_DATE
, GBC.LAST_UPDATE_LOGIN
, PBEM.ENTRY_LEVEL_CODE
, PBEM.CATEGORIZATION_CODE
, GBC.BUDGETARY_CONTROLS_ID
, PRL.RESOURCE_LIST_ID
, PRL.NAME
, GBV.BUDGET_ENTRY_METHOD_CODE
, GA.ORG_ID
FROM GMS_AWARDS GA
, GMS_BUDGET_VERSIONS GBV
, PA_BUDGET_ENTRY_METHODS PBEM
, GMS_BUDGETARY_CONTROLS GBC
, PA_RESOURCE_LISTS PRL
WHERE GBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND GBV.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND GBV.BUDGET_VERSION_ID = (SELECT BV.BUDGET_VERSION_ID
FROM GMS_BUDGET_VERSIONS BV
WHERE BV.PROJECT_ID = GBC.PROJECT_ID
AND BV.CURRENT_FLAG = 'Y'
AND BV.AWARD_ID = GA.AWARD_ID)
AND GA.AWARD_ID = GBC.AWARD_ID
AND GBC.TASK_ID IS NULL
AND GBC.PARENT_MEMBER_ID IS NULL
AND RESOURCE_LIST_MEMBER_ID IS NULL
AND NVL(PRL.MIGRATION_CODE
, 'M') ='M'

Columns