ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4717851A9E05362FB09050512Y select distinct paf.assignment_type new_hire_asg_type , paf.assignment_id , paf.effective_start_date , paf.effective_end_date , ppos.date_start date_start , ppf.full_name , paf.assignment_number , hou.name org , gdt.name grade , jbt.name job , pp.name position , hltl.location_code , hrl.meaning new_hire_reason , null new_hire_supplier_name , null new_hire_supplier_site, PER_PAYRPEMV_XMLP_PKG.cf_control_total_newhireformul(paf.assignment_type, :ASSIGNMENT_TYPE) CF_control_total_newhire from per_assignments_f paf , per_periods_of_service ppos , per_people_f ppf , hr_organization_units hou , per_grades_tl gdt , per_jobs_tl jbt , per_positions pp , hr_locations_no_join hl , hr_locations_all_tl hltl , hr_leg_lookups hrl where hl.location_id = hltl.location_id (+) and decode(hltl.location_id,null,'1',hltl.language) = decode(hltl.location_id,null,'1',userenv('LANG')) and paf.period_of_service_id = ppos.period_of_service_id(+) and paf.person_id = ppf.person_id and ppf.effective_end_date = (select min(ppf3.effective_end_date) from per_people_f ppf3 where ppf3.person_id = paf.person_id and ppf3.effective_end_date >= sysdate group by ppf3.person_id) and paf.organization_id = hou.organization_id and paf.grade_id = gdt.grade_id(+) and gdt.language(+) = userenv('LANG') and paf.job_id = jbt.job_id(+) and jbt.language(+) = userenv('LANG') and paf.position_id = pp.position_id(+) and paf.location_id = hl.location_id(+) and paf.assignment_type = 'E' and :p_worker_type in ('E','B') and upper(:p_employee_detail) != 'S' and hrl.lookup_type = 'NEW_HIRE_REASON' and hrl.lookup_code = 'NEW_STARTER' /* added as fix:*/ and paf.assignment_id=:new_hires and paf.effective_start_date=:effective_start_date7 and paf.effective_end_date=:effective_end_date7 /* fix ends */ UNION ALL select distinct paf.assignment_type new_hire_asg_type , paf.assignment_id , paf.effective_start_date , paf.effective_end_date , ppp.date_start , ppf.full_name , paf.assignment_number , hou.name org , gdt.name grade , jbt.name job , pp.name position , hltl.location_code , hrl.meaning new_hire_reason , POV.VENDOR_NAME asg_supplier_name , POVS.VENDOR_SITE_CODE asg_supplier_site, PER_PAYRPEMV_XMLP_PKG.cf_control_total_newhireformul(paf.assignment_type, :ASSIGNMENT_TYPE) CF_control_total_newhire from per_assignments_f paf , per_periods_of_placement ppp , per_people_f ppf , hr_organization_units hou , per_grades_tl gdt , per_jobs_tl jbt , per_positions pp , hr_locations_no_join hl , hr_locations_all_tl hltl , PO_VENDORS POV , PO_VENDOR_SITES_ALL POVS , hr_leg_lookups hrl where hl.location_id = hltl.location_id (+) and decode(hltl.location_id,null,'1',hltl.language) = decode(hltl.location_id,null,'1',userenv('LANG')) and paf.period_of_placement_date_start = ppp.date_start(+) and paf.person_id = ppp.person_id(+) and paf.person_id = ppf.person_id and paf.assignment_type = 'C' and ppf.effective_end_date = (select min(ppf3.effective_end_date) from per_people_f ppf3 where ppf3.person_id = paf.person_id and ppf3.effective_end_date >= sysdate group by ppf3.person_id) and paf.organization_id = hou.organization_id and paf.grade_id = gdt.grade_id(+) and gdt.language(+) = userenv('LANG') and paf.job_id = jbt.job_id(+) and jbt.language(+) = userenv('LANG') and paf.position_id = pp.position_id(+) and paf.location_id = hl.location_id(+) AND paf.VENDOR_ID = POV.VENDOR_ID (+) AND paf.VENDOR_SITE_ID = POVS.VENDOR_SITE_ID (+) and :p_worker_type in ('C','B') and upper(:p_employee_detail) != 'S' and hrl.lookup_type = 'NEW_HIRE_REASON' and hrl.lookup_code = 'NEW_STARTER' and paf.assignment_id=:new_hires and paf.effective_start_date=:effective_start_date7 and paf.effective_end_date=:effective_end_date7 PER PAYRPEMV_HR_XML AR PER تقرير حركات العمال في المنشأة (بتنسيق XML) Imported from BI Publisher Description: تقرير حركات العمال في المنشأة Application: الموارد البشرية Source: تقرير حركات العمال في المنشأة (بتنسيق XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG D PER Mitarbeiter - Organisationsbewegungen Imported from BI Publisher Description: Mitarbeiter - Organisationsbewegungen Application: Human Resources Source: Mitarbeiter - Organisationsbewegungen (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG E PER Traslados de Trabajadores en la Organización Imported from BI Publisher Description: Informe de traslados de trabajadores en la organización Application: Human Resources Source: Traslados de Trabajadores en la Organización (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG F PER Etat des mouvements des intervenants par organisation Imported from BI Publisher Description: Etat des mouvements des intervenants par organisation Application: Human Resources Source: Etat des mouvements des intervenants par organisation (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG I PER Rapporto Spostamenti organizzazioni lavoratori Imported from BI Publisher Description: Rapporto Movimenti organizzazione dei lavoratori Application: Human Resources Source: Rapporto Spostamenti organizzazioni lavoratori (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG JA PER 就業者の組織間異動レポート Imported from BI Publisher Description: 就業者の組織間異動レポート Application: Human Resources Source: 就業者の組織間異動レポート(XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG KO PER 근로자 조직 이동 보고서 Imported from BI Publisher Description: 근로자 조직 이동 보고서 Application: HR Source: 근로자 조직 이동 보고서(XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG PTB PER Relatório de Movimentações da Organização do Trabalhador Imported from BI Publisher Description: Relatório de Movimentações da Organização do Trabalhador Application: Human Resources Source: Relatório de Movimentações da Organização do Trabalhador (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG RU PER Отчет о перемещениях работников внутри организации Imported from BI Publisher Description: Отчет о перемещениях работников внутри организации Application: Персонал Source: Отчет о перемещениях работников внутри организации (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG S PER Arbetares organisationsförflyttningar - rapport Imported from BI Publisher Description: Arbetares organisationsförflyttningar Application: Human Resources Source: Arbetares organisationsförflyttningar - rapport (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG TR PER Çalışan Organizasyon Hareketleri Raporu Imported from BI Publisher Description: Çalışan Organizasyon Hareketleri Raporu Application: İnsan Kaynakları Source: Çalışan Organizasyon Hareketleri Raporu (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG US PER Worker Organization Movements Imported from BI Publisher Description: Worker Organization Movements Report Application: Human Resources Source: Worker Organization Movements Report (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG ZHS PER 员工组织变动报表 Imported from BI Publisher Description: 员工组织变动报表 Application: 人力资源管理系统 Source: 员工组织变动报表 (XML) Short Name: PAYRPEMV_HR_XML DB package: PER_PAYRPEMV_XMLP_PKG BI Publisher :assignment_type :c_business_group_name :c_emp_det_param_disp :c_org_structure_name :c_parent_organization_name :c_payroll_name :c_payroll_period :c_report_subtitle :c_version_number :cp_total_cwk_newhire :cp_total_cwk_term :cp_total_cwk_transin :cp_total_cwk_transout :cp_total_emp_newhire :cp_total_emp_term :cp_total_emp_transin :cp_total_emp_transout :cp_worker_type_desc :effective_end_date7 :effective_start_date7 :new_hires :p_business_group_id :p_conc_request_id :p_date_from :p_date_from_t :p_date_to :p_date_to_t :p_dates_matching :p_dates_matching2 :p_dates_matching3 :p_dates_matching4 :p_dates_matching5 :p_emp_ord_clause :p_employee_detail :p_org_matching :p_org_matching2 :p_org_matching3 :p_org_structure_id :p_org_structure_version_id :p_parent_organization_id :p_payroll_id :p_payroll_matching :p_payroll_matching2 :p_payroll_matching3 :p_payroll_period_id :p_report_title :p_session_date :p_trace :p_worker_type 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR معرف مجموعة الأعمال معرف مجموعة الأعمال D Kennung Unternehmensgruppe Kennung Unternehmensgruppe E Id Grupo de Trabajo Identificador del grupo de trabajo F ID entité professionnelle ID entité professionnelle I Id business group Id del business group JA ビジネス・グループID ビジネス・グループID KO 업무 그룹 ID 업무 그룹 ID PTB ID do Grupo Funcional ID do Grupo Funcional RU Идентификатор бизнес-группы Идентификатор бизнес-группы S Id för verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu No İş Grubu No US Business Group ID Business Group ID ZHS 业务组标识 业务组标识 2 10 :p_org_structure_id LOV Oracle PER_ORG_STRUCTS_GLOBAL Y select organization_structure_id id, name||decode(business_group_id,null,' (*)',null) value, null description from per_organization_structures where business_group_id=fnd_global.per_business_group_id or (business_group_id is null and (select p.business_group_id from per_security_profiles p where p.security_profile_id=fnd_global.per_security_profile_id) is null) order by name AR هيكل المنشأة هيكل المنشأة D Organisationsstruktur Organisationsstruktur E Estructura de Organización Estructura de organización F Structure de l'organisation Structure de l'organisation I Struttura organizzazione Struttura dell'organizzazione JA 組織体系 組織体系 KO 조직 구조 조직 구조 PTB Estrutura da Organização Estrutura da Organização RU Структура организации Структура организации S Organisationsstruktur Organisationsstruktur TR Organizasyon Yapısı Organizasyon Yapısı US Organization Structure Organization Structure ZHS 组织结构 组织结构 3 20 :p_org_structure_version_id LOV Oracle PER_ORG_STRUCT_VERS_GLOBAL Y select org_structure_version_id id, to_char(version_number) value, fnd_date.date_to_displaydate(date_to,1) description from per_org_structure_versions where organization_structure_id=:$flex$.per_org_structs_global order by date_from desc Y AR النسخة النسخة E Versión Versión I Versione Versione JA バージョン バージョン KO 버전 버전 PTB Versão Versão RU Версия Версия TR Sürüm Sürüm US Version Version ZHS 版本 版本 4 30 :p_parent_organization_id LOV Oracle PER_ORG_STRUCT_ELES2_GLOBAL Y select organization_id id, name value, null description from hr_organization_units where (:$flex$.per_org_structs_global:null is not null and exists (select 1 from per_org_structure_elements e where e.org_structure_version_id=:$flex$.per_org_struct_vers_global:null and (e.organization_id_parent=organization_id or e.organization_id_child=organization_id))) or (:$flex$.per_org_structs_global:null is null) order by name AR المنشأة الرئيسية المنشأة الرئيسية D Übergeordnete Organisation Übergeordnete Organisation E Organización Matriz Organización matriz F Organisation parent Organisation parent I Organizzazione padre Organizzazione padre JA 上位組織 上位組織 KO 상위 조직 상위 조직 PTB Organização-Pai Organização-Pai RU Головная организация Головная организация S Överordnad organisation Överordnad organisation TR Üst Organizasyon Üst Organizasyon US Parent Organization Parent Organization ZHS 上层组织 上层组织 5 40 :p_date_from Date AR من تاريخ من تاريخ D Von Datum Von Datum E De Fecha De Fecha F Date - Du Date - Du I Data - Da Data - Da JA 日付:自 日付:自 KO 시작 일자 일자: 부터 PTB Data - De Data - De RU Дата с Дата с S Från datum Från datum TR Başlangıç Tarihi Başlangıç Tarihi US Date From Date From ZHS 日期自 日期自 6 50 :p_date_to Date AR التاريخ إلى التاريخ إلى D Bis Datum Bis Datum E A Fecha A Fecha F Date - Au Date - Au I Data - A Data - A JA 日付:至 日付:至 KO 종료 일자 일자: 까지 PTB Data - Até Data - Até RU Дата по Дата по S Till datum Till datum TR Bitiş Tarihi Bitiş Tarihi US Date To Date To ZHS 日期至 日期至 7 60 :p_worker_type LOV Oracle HR_PAYRPEMV_WORKER_TYPE Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where hl.lookup_type='HR_HEADCOUNT_WORKER_TYPE' and hl.enabled_flag='Y' order by value,description select meaning from hr_lookups where lookup_type='HR_HEADCOUNT_WORKER_TYPE' and lookup_code='E' Y AR نوع العامل الموظف أو العامل الطارئ أو كلاهما D Mitarbeiterart Mitarbeiter, Befristeter Mitarbeiter oder beides E Tipo de Trabajador Empleado, trabajador temporal o ambos F Type d'intervenant employé , intérimaire ou les deux I Tipo di lavoratore Dipendente, lavoratore a termine o entrambi JA 就業者タイプ 従業員、派遣就業者または両方 KO 근로자 유형 사원, 임시 근로자 또는 둘 다 PTB Tipo de Trabalhador funcionário, cwk ou ambos RU Тип исполнителя Работник, работник по контракту или все S Typ av arbetstagare anställd, konsult eller båda TR Çalışan Tipi çalışan , cwk veya her ikisi US Worker Type employee , cwk or both ZHS 员工类型 员工、临时工或两者兼有 8 70 :p_employee_detail LOV Oracle HR_US_PAYRPEMV_EMP_DET Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PAYRPEMV_EMP_DET' order by value,description select meaning from hr_lookups where lookup_type='PAYRPEMV_EMP_DET' and lookup_code='S' Y AR تفاصيل العامل تفاصيل العامل D Details Befristeter Mitarbeiter Details Befristeter Mitarbeiter E Detalle de Trabajador Detalle de trabajador F Détails sur l'intervenant Détails sur l'intervenant I Dettaglio lavoratore Dettaglio del lavoratore JA 就業者詳細 就業者詳細 KO 근로자 상세내역 근로자 상세내역 PTB Detalhe do Trabalhador Detalhe do Trabalhador RU Сведения о работнике Сведения о работнике S Anställningsdetalj Anställningsdetalj TR Çalışan Detayı Çalışan Detayı US Worker Detail Worker Detail ZHS 员工详细信息 员工详细信息