View: GMS_BUDGETARY_CONTROL_PROJ_V

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

View Text

SELECT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, PRL.NAME
, PRL.RESOURCE_LIST_ID
, PRL.GROUP_RESOURCE_TYPE_ID
, PBEM.ENTRY_LEVEL_CODE
, PI.ORG_ID
FROM GMS_BUDGET_VERSIONS GBV
, PA_BUDGET_ENTRY_METHODS PBEM
, PA_RESOURCE_LISTS PRL
, PA_PROJECTS_ALL PP
, PA_IMPLEMENTATIONS PI
WHERE GBV.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND GBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND GBV.PROJECT_ID = PP.PROJECT_ID
AND GBV.CURRENT_FLAG ='Y'
AND PRL.BUSINESS_GROUP_ID = PI.BUSINESS_GROUP_ID
AND PI.ORG_ID = PP.ORG_ID

Columns