ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2BA3869E053B46B63588994Y select o.organization_id organization_id1 , substr('Organization:'||o.name,1,60) Organization , p.person_id , p.full_name full_name , DECODE(p.current_employee_flag,'Y',p.employee_number,p.npw_number) employee_number , j.name Job , to_char(a.effective_start_date,'DD-MON-YYYY') effective_start_date , decode(a.effective_end_date,to_date('47121231', 'YYYYMMDD'),'', to_char(a.effective_end_date,'DD-MON-YYYY')) effective_end_date from per_job_definitions jd , per_jobs j , pa_implementations i , hr_organization_units o , per_people_f p , per_assignments_f a where a.organization_id between decode(:organization_id,null,-99999,:organization_id) and decode(:organization_id,null,999999999999999,:organization_id) and nvl(:job_id,nvl(a.job_id,-1)) = nvl(a.job_id,-1) and nvl(:effective_date,sysdate) between a.effective_start_date and a.effective_end_date and a.job_id = j.job_id(+) and j.job_definition_id = jd.job_definition_id(+) and (:job_level is null or (:job_level is not null and jd.segment1 = :job_level)) and (:job_discipline is null or (:job_discipline is not null and jd.segment2 = :job_discipline)) and a.primary_flag = 'Y' and a.assignment_type IN ('E' ,'C') and p.person_id = a.person_id and NVL(:effective_date,sysdate) between p.effective_start_date and p.effective_end_date 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 and o.organization_id=:organization_id order by decode(:sort_by, 'ORGANIZATION' ,o.name, 'JOB' ,j.name, 'JOB LEVEL' ,jd.segment1, 'JOB DISCIPLINE',jd.segment2, p.last_name), p.last_name, p.first_name, DECODE(p.current_employee_flag,'Y',p.employee_number,p.npw_number) , a.effective_start_date, decode(:sort_by, 'ORGANIZATION',j.name, 'JOB', o.name, null), o.name, j.name PA PAXPEEMO_XML AR PA تعيينات الموظفين حسب التنظيم (بتنسيق XML) Application: المشروعات Source: IMP: تعيينات الموظفين حسب التنظيم (بتنسيق XML) Short Name: PAXPEEMO_XML DB package: PA_PAXPEEMO_XMLP_PKG D PA Mitarbeiterzuordnungen nach Organisation Application: Projects Source: IMP: Mitarbeiterzuordnungen nach Organisation (XML) Short Name: PAXPEEMO_XML DB package: PA_PAXPEEMO_XMLP_PKG F PA Affectations d'employés par organisation Application: Projects Source: IMP : Affectations d'employés par organisation (XML) Short Name: PAXPEEMO_XML DB package: PA_PAXPEEMO_XMLP_PKG US PA Employee Assignments By Organization Application: Projects Source: IMP: Employee Assignments By Organization (XML) Short Name: PAXPEEMO_XML DB package: PA_PAXPEEMO_XMLP_PKG ZHS PA IMP：按组织列出的员工分配 Application: 项目 Source: IMP：按组织列出的员工分配 (XML) Short Name: PAXPEEMO_XML DB package: PA_PAXPEEMO_XMLP_PKG BI Publisher :c_company_name_header :c_job_name :c_org_name :effective_date :job_discipline :job_id :job_level :operating_unit :organization_id :p_conc_request_id :p_debug_mode :p_rule_optimizer :p_start_organization_id :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 :p_start_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 Startorganisation F Organisation de départ US Start 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 作业领域