ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2C73869E053B46B63588994Y SELECT distinct p.org_structure_version_id org_structure_version_id , pos1.name Organization_hierarchy ,posv.version_number version_number , decode(:aa_start_org_id,'',&p_parent_org_id,:aa_start_org_id) ORG_ID_PARENT ,substr(org.name,1,60) name2 ,&p_parent_org_id FROM per_org_structure_elements p ,hr_organization_units org , pa_implementations pi ,per_organization_structures pos1 ,&P_From_Clause WHERE decode(null,'', p.organization_id_parent, -999) not in (select d.organization_id_child from per_org_structure_elements d where d.org_structure_version_id = &P_Decode_Column ) and p.org_structure_version_id = &P_Decode_Column &p_version_id &p_structure_id &p_where_clause1 &p_where_clause &p_org_hr &p_burden order by 5 PA PAXRWDOH_XML AR PA التدرج الوظيفي للمنشأة (بتنسيق XML) Application: المشروعات Source: IMP: التدرج الوظيفي للمنشأة (بتنسيق XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG D PA Organisationshierarchie Application: Projects Source: IMP: Organisationshierarchie (XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG F PA Hiérarchie des organisations Application: Projects Source: IMP : Hiérarchie des organisations (XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG US PA Organization Hierarchy Application: Projects Source: IMP: Organization Hierarchy (XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG ZHS PA IMP：组织层次结构 Application: 项目 Source: IMP：组织层次结构 (XML) Short Name: PAXRWDOH_XML DB package: PA_PAXRWDOH_XMLP_PKG BI Publisher &p_burden &p_decode_column &p_from_clause &p_org_hr &p_parent_org_id &p_structure_id &p_version_id &p_where_clause &p_where_clause1 :aa_start_org_id :c_company_name_header :c_no_data_found :c_org_name :operating_unit :p_burden :p_conc_request_id :p_decode_column :p_from_clause :p_hierarchy_type :p_org_hr :p_parent_org_id :p_select_column :p_select_column1 :p_structure_id :p_version_id :p_where_clause :p_where_clause1 :start_org_id 1 10 :p_hierarchy_type LOV Oracle PA_SRS_HIERARCHY_TYPES Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type= ('ALL_HIERARCHY_CLASS') order by lookup_code Y AR نوع التدرج الوظيفي D Hierarchieart F Type de hiérarchie US Hierarchy Type ZHS 层次结构类型 2 20 :start_org_id LOV Oracle PA_SRS_STARTING_ORGANIZATION Y select organization_id id, name value, null description from pa_organizations_v where organization_id in (select se.organization_id_child from per_org_structure_elements se where org_structure_version_id= pa_org_utils.get_org_version_id2(decode(:$flex$.pa_srs_hierarchy_types, 'PA_REPORTING_ORG','REPORTING','PA_PROJECT_ORG','PROJECTS','PA_EXPENDITURE_ORG','EXPENDITURES', 'PA_BURDENING_ORG','BURDENING')) connect by prior se.organization_id_child =se.organization_id_parent and org_structure_version_id= pa_org_utils.get_org_version_id2(decode(:$flex$.pa_srs_hierarchy_types, 'PA_REPORTING_ORG','REPORTING','PA_PROJECT_ORG','PROJECTS','PA_EXPENDITURE_ORG','EXPENDITURES', 'PA_BURDENING_ORG','BURDENING')) start with se.organization_id_parent= pa_org_utils.get_start_org_id2(decode(:$flex$.pa_srs_hierarchy_types, 'PA_REPORTING_ORG','REPORTING','PA_PROJECT_ORG','PROJECTS','PA_EXPENDITURE_ORG','EXPENDITURES', 'PA_BURDENING_ORG','BURDENING')) and org_structure_version_id= pa_org_utils.get_org_version_id2(decode(:$flex$.pa_srs_hierarchy_types, 'PA_REPORTING_ORG','REPORTING','PA_PROJECT_ORG','PROJECTS','PA_EXPENDITURE_ORG','EXPENDITURES', 'PA_BURDENING_ORG','BURDENING')) union select pa_org_utils.get_start_org_id2(decode(:$flex$.pa_srs_hierarchy_types, 'PA_REPORTING_ORG','REPORTING','PA_PROJECT_ORG','PROJECTS','PA_EXPENDITURE_ORG','EXPENDITURES', 'PA_BURDENING_ORG','BURDENING')) from sys.dual ) order by value,description AR التنظيم الأعلى D Startorganisation F Organisation supérieure US Top Organization ZHS 顶层组织