ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2BB3869E053B46B63588994Y SELECT decode(:p_sort_by, 'JOB LEVEL', jd.segment1, 'JOB DISCIPLINE', jd.segment2, j.name) sort_by_value, jd.segment1 job_level, jd.segment2 job_discipline, j.name, j.comments, j.date_from, j.date_to FROM per_jobs j, per_job_definitions jd, pa_implementations pi WHERE j.business_group_id = pi.business_group_id and j.job_definition_id = jd.job_definition_id and nvl ( jd.segment1 , 'zzz' ) = nvl ( :p_job_level , nvl ( jd.segment1 , 'zzz' ) ) and nvl ( jd.segment2 , 'zzz' ) = nvl ( :p_job_discipline , nvl ( jd.segment2 , 'zzz' ) ) ORDER BY 1 ASC,2 ASC , j.name PA PAXPEJOB_XML AR PA قائمة الوظائف (بتنسيق XML) Application: المشروعات Source: IMP: قائمة الوظائف (بتنسيق XML) Short Name: PAXPEJOB_XML DB package: PA_PAXPEJOB_XMLP_PKG D PA Liste Tätigkeiten Application: Projects Source: IMP: Liste Tätigkeiten (XML) Short Name: PAXPEJOB_XML DB package: PA_PAXPEJOB_XMLP_PKG F PA Liste des fonctions Application: Projects Source: IMP : Liste des fonctions (XML) Short Name: PAXPEJOB_XML DB package: PA_PAXPEJOB_XMLP_PKG US PA Job Listing Application: Projects Source: IMP: Job Listing (XML) Short Name: PAXPEJOB_XML DB package: PA_PAXPEJOB_XMLP_PKG ZHS PA IMP：职务列表 Application: 项目 Source: IMP：职务列表 (XML) Short Name: PAXPEJOB_XML DB package: PA_PAXPEJOB_XMLP_PKG BI Publisher :c_company_name_header :c_sort_by_name :p_conc_request_id :p_job_discipline :p_job_level :p_sort_by 1 10 :p_sort_by LOV Oracle PA_SRS_JOB_SORT_BY Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='JOB SORT BY' order by meaning Y AR فرز الوظائف حسب D Tätigkeiten sortieren nach F Tri des fonctions par US Sort Jobs By ZHS 作业排序依据 2 20 :p_job_level LOV Oracle PA_SRS_JOB_LEVEL Y select job_level id, job_level value, null description from pa_job_levels_v order by value,description AR مستوى الوظيفة D Tätigkeitsebene F Niveau de fonction US Job Level ZHS 职务级别 3 30 :p_job_discipline LOV Oracle PA_SRS_JOB_DISCIPLINE Y select job_discipline id, job_discipline value, null description from pa_job_disciplines_v order by job_discipline AR النظام الوظيفي D Tätigkeitsart F Poste US Job Discipline ZHS 作业领域