VIEW: APPS.PA_BUDGETARY_CONTROL_PROJ_V

Source

View Text - Preformatted

SELECT distinct pp.project_id, pp.segment1, pp.name, prl.name resource_list_name, prl.resource_list_id, prl.group_resource_type_id, pbem.entry_level_code, pbem.categorization_code, pbv.budget_type_code, pbt.budget_type from pa_budget_versions pbv, pa_budget_entry_methods pbem, pa_resource_lists prl, pa_budget_types pbt, pa_projects_all pp WHERE pbv.resource_list_id = prl.resource_list_id and pbv.budget_entry_method_code = pbem.budget_entry_method_code and pbv.budget_type_code = pbt.budget_type_code and pbv.project_id = pp.project_id and pbv.current_flag = 'Y' and nvl(prl.migration_code, 'M') = 'M' order by pp.segment1

View Text - HTML Formatted

SELECT DISTINCT PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, PRL.NAME RESOURCE_LIST_NAME
, PRL.RESOURCE_LIST_ID
, PRL.GROUP_RESOURCE_TYPE_ID
, PBEM.ENTRY_LEVEL_CODE
, PBEM.CATEGORIZATION_CODE
, PBV.BUDGET_TYPE_CODE
, PBT.BUDGET_TYPE
FROM PA_BUDGET_VERSIONS PBV
, PA_BUDGET_ENTRY_METHODS PBEM
, PA_RESOURCE_LISTS PRL
, PA_BUDGET_TYPES PBT
, PA_PROJECTS_ALL PP
WHERE PBV.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND PBV.BUDGET_ENTRY_METHOD_CODE = PBEM.BUDGET_ENTRY_METHOD_CODE
AND PBV.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PBV.PROJECT_ID = PP.PROJECT_ID
AND PBV.CURRENT_FLAG = 'Y'
AND NVL(PRL.MIGRATION_CODE
, 'M') = 'M' ORDER BY PP.SEGMENT1