VIEW: APPS.GMS_BUDGETARY_CONTROL_PROJ_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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