ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2B93869E053B46B63588994Y select decode(:sort_by, 'ORGANIZATION' ,substr(o.name,1,60), 'JOB' ,j.name, 'JOB LEVEL' ,jd.segment1, 'JOB DISCIPLINE',jd.segment2, p.last_name) sort_by_value , p.full_name full_name , NVL( p.employee_number, p.npw_number ) employee_number , substr(o.name,1,60) Organization , j.name Job , a.title billing_title , a.effective_start_date , a.effective_end_date from per_job_definitions jd , per_jobs j , pa_implementations i , hr_organization_units o , per_all_people_f p , per_assignments_f a where a.job_id = j.job_id(+) and j.job_definition_id = jd.job_definition_id(+) &P_PARA_SQL and a.primary_flag = 'Y' and a.assignment_type in ( 'E' , 'C' ) and p.person_id = a.person_id and ((current_employee_flag='Y' and employee_number is not null) or (current_npw_flag='Y' and npw_number is not null)) and a.organization_id = o.organization_id and a.business_group_id = i.business_group_id ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC , a.effective_start_date PA PAXPEAST_XML AR PA تعيين الموظف (بتنسيق XML) Application: المشروعات Source: IMP: تعيين الموظف (بتنسيق XML) Short Name: PAXPEAST_XML DB package: PA_PAXPEAST_XMLP_PKG D PA Mitarbeiterzuordnungen Application: Projects Source: IMP: Mitarbeiterzuordnungen (XML) Short Name: PAXPEAST_XML DB package: PA_PAXPEAST_XMLP_PKG F PA Affectations d'employés Application: Projects Source: IMP : Affectations d'employés (XML) Short Name: PAXPEAST_XML DB package: PA_PAXPEAST_XMLP_PKG US PA Employee Assignment Application: Projects Source: IMP: Employee Assignment (XML) Short Name: PAXPEAST_XML DB package: PA_PAXPEAST_XMLP_PKG ZHS PA IMP：员工分配 Application: 项目 Source: IMP：员工分配 (XML) Short Name: PAXPEAST_XML DB package: PA_PAXPEAST_XMLP_PKG BI Publisher &p_para_sql :c_company_name_header :c_job :c_org_name :c_sort_by_meaning :effective_date :effective_date_1 :job_discipline :job_id :job_id_t :job_level :organization_id :organization_id_t :p_conc_request_id :p_para_sql :sort_by 1 10 :sort_by LOV Oracle PA_SRS_AST_SORT_BY Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='ASSIGNMENT SORT BY' order by meaning Y AR فرز التعيينات حسب D Zuordnungen sortieren nach F Tri des affectations par US Sort Assignments By ZHS 分配排序依据 2 20 :effective_date Date select sysdate from dual AR تاريخ الفعالية D Gültigkeitsdatum F Date de validité US Effective Date ZHS 有效日期 3 30 :organization_id LOV Oracle PA_SRS_REPORTING_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_id('REPORTING') connect by prior se.organization_id_child =se.organization_id_parent and org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') start with se.organization_id_parent= pa_org_utils.get_start_org_id('REPORTING') and org_structure_version_id= pa_org_utils.get_org_version_id('REPORTING') union select pa_org_utils.get_start_org_id('REPORTING') from sys.dual ) order by value,description AR المنشأة D Organisation F Organisation US Organization ZHS 组织 4 40 :job_id LOV Oracle PA_SRS_JOB_NAME Y select job_id id, name value, null description from pa_jobs_v order by name AR الوظيفة D Tätigkeit F Fonction US Job ZHS 职务 5 50 :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 职务级别 6 60 :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 作业领域