VIEW: APPS.GMS_BUDGETARY_CONTROL_AWARD_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'