ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719E51A9E05362FB09050512Y SELECT A.ORGANIZATION_ID ORGANIZATION_ID1, count(distinct decode(:P_LEAV_REASON1,null,null, &P_REASON_COLUMN, P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason1_tot, count(distinct decode(:P_LEAV_REASON2,null,null,&P_REASON_COLUMN, P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason2_tot, count(distinct decode(:P_LEAV_REASON3,null,null, &P_REASON_COLUMN, P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason3_tot, count(distinct decode(:P_LEAV_REASON4,null,null,&P_REASON_COLUMN, P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason4_tot, count(distinct decode(:P_LEAV_REASON5,null,null,&P_REASON_COLUMN, P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason5_tot, count(distinct decode(:P_LEAV_REASON6,null,null,&P_REASON_COLUMN, P.PERSON_ID||P.ACTUAL_TERMINATION_DATE,NULL)) reason6_tot, count(distinct decode(&P_REASON_COLUMN, decode(:P_LEAV_REASON1,null,'999',:P_LEAV_REASON1), P.PERSON_ID||P.ACTUAL_TERMINATION_DATE, decode(:P_LEAV_REASON2,null,'999',:P_LEAV_REASON2), P.PERSON_ID||P.ACTUAL_TERMINATION_DATE, decode(:P_LEAV_REASON3,null,'999',:P_LEAV_REASON3), P.PERSON_ID||P.ACTUAL_TERMINATION_DATE, decode(:P_LEAV_REASON4,null,'999',:P_LEAV_REASON4), P.PERSON_ID||P.ACTUAL_TERMINATION_DATE, decode(:P_LEAV_REASON5,null,'999',:P_LEAV_REASON5), P.PERSON_ID||P.ACTUAL_TERMINATION_DATE, decode(:P_LEAV_REASON5,null,'999',:P_LEAV_REASON5), P.PERSON_ID||P.ACTUAL_TERMINATION_DATE, null)) reasons_tot, count(distinct P.PERSON_ID||P.ACTUAL_TERMINATION_DATE) all_total FROM PER_PERIODS_OF_SERVICE P, PER_ASSIGNMENTS_F A WHERE P.PERIOD_OF_SERVICE_ID = A.PERIOD_OF_SERVICE_ID AND A.ASSIGNMENT_TYPE = 'E' AND P.ACTUAL_TERMINATION_DATE BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND P.ACTUAL_TERMINATION_DATE BETWEEN :P_DATE_FROM AND :P_DATE_TO and A.ORGANIZATION_ID=:org_id group by A.ORGANIZATION_ID PER PERRPRTM_XML AR PER تقرير إنهاء الخدمات (بتنسيق XML) Imported from BI Publisher Description: تقرير إنهاء الخدمات Application: الموارد البشرية Source: تقرير إنهاء الخدمات (بتنسيق XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG D PER Kündigungen Imported from BI Publisher Description: Auswertung "Kündigungen" Application: Human Resources Source: Kündigungen (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG E PER Terminaciones de Contratos Imported from BI Publisher Description: Informe de terminaciones de contratos Application: Human Resources Source: Terminaciones de Contratos (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG F PER Etat des fins de contrat Imported from BI Publisher Description: Etat des fins de contrat Application: Human Resources Source: Etat des fins de contrat (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG I PER Rapporto Cessazioni Imported from BI Publisher Description: Rapporto Cessazioni Application: Human Resources Source: Rapporto Cessazioni (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG JA PER 退職レポート Imported from BI Publisher Description: 退職レポート Application: Human Resources Source: 退職レポート(XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG KO PER 퇴직 보고서 Imported from BI Publisher Description: 퇴직 보고서 Application: HR Source: 퇴직 보고서(XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG PTB PER Relatório de Desligamentos Imported from BI Publisher Description: Relatório de Desligamentos Application: Human Resources Source: Relatório de Desligamentos (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG RU PER Отчет о прекращениях Imported from BI Publisher Description: Отчет о прекращениях Application: Персонал Source: Отчет о прекращениях (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG S PER Avslutningar - rapport Imported from BI Publisher Description: Avslutningar - rapport Application: Human Resources Source: Avslutningar - rapport (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG TR PER Sonlandırmalar Raporu Imported from BI Publisher Description: Sonlandırmalar Raporu Application: İnsan Kaynakları Source: Sonlandırmalar Raporu (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG US PER Terminations Imported from BI Publisher Description: Terminations Report Application: Human Resources Source: Terminations Report (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG ZHS PER 终止报表 Imported from BI Publisher Description: 终止报表 Application: 人力资源管理系统 Source: 终止报表 (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG BI Publisher &p_reason_column :c_business_group_name :c_global_hierarchy :c_head_reasons :c_leav_reason1 :c_leav_reason2 :c_leav_reason3 :c_leav_reason4 :c_leav_reason5 :c_leav_reason6 :c_org_structure_name :c_parent_organization_name :c_report_subtitle :org_id :p_alternate :p_business_group_id :p_conc_request_id :p_date_from :p_date_to :p_leav_reason1 :p_leav_reason2 :p_leav_reason3 :p_leav_reason4 :p_leav_reason5 :p_leav_reason6 :p_lookup_type :p_org_matching :p_org_structure_version_id :p_parent_organization_id :p_reason_column :p_session_date 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_session_date Date select fnd_date.date_to_displaydate(effective_date, 1) from fnd_sessions where session_id = userenv('sessionid') Y AR تاريخ الفعالية تاريخ الفعالية D Gültigkeitsdatum Gültigkeitsdatum E Fecha en Vigor Fecha en vigor F Date de validité Date de validité I Data validità Data di validità JA 有効日 有効日 KO 유효 일자 유효 일자 PTB Data de Efetivação Data de Efetivação RU Дата действия Дата действия S Giltighetsdatum Giltighetsdatum TR Geçerlilik Tarihi Geçerlilik Tarihi US Effective Date Effective Date ZHS 有效日期 有效日期 3 20 :p_organization_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 组织结构 组织结构 4 30 :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 版本 版本 5 40 :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 上层组织 上层组织 6 50 :p_date_from Date Y 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 日期自 日期自 7 60 :p_date_to Date Y 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 日期至 日期至 8 70 :p_leav_reason1 LOV Oracle HR_LEAV_REAS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='LEAV_REAS' order by value,description Y AR سبب إنهاء الخدمة 1 سبب إنهاء الخدمة 1 D Kündigungsgrund 1 Kündigungsgrund 1 E Motivo 1 de Terminación Motivo 1 de terminación F Motif fin de contrat 1 Motif fin de contrat 1 I Motivo cessazione 1 Motivo cessazione 1 JA 退職理由1 退職理由1 KO 퇴직 사유 1 퇴직 사유 1 PTB Motivo do Desligamento 1 Motivo do Desligamento 1 RU Основание прекращения 1 Основание прекращения 1 S Orsak till avslutning 1 Orsak till avslutning 1 TR Sonlandırma Nedeni 1 Sonlandırma Nedeni 1 US Termination Reason 1 Termination Reason 1 ZHS 终止原因 1 终止原因 1 9 80 :p_leav_reason2 LOV Oracle HR_LEAV_REAS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='LEAV_REAS' order by value,description AR سبب إنهاء الخدمة 2 سبب إنهاء الخدمة 2 D Kündigungsgrund 2 Kündigungsgrund 2 E Motivo 2 de Terminación Motivo 2 de terminación F Motif fin de contrat 2 Motif fin de contrat 2 I Motivo cessazione 2 Motivo cessazione 2 JA 退職理由2 退職理由2 KO 퇴직 사유 2 퇴직 사유 2 PTB Motivo do Desligamento 2 Motivo do Desligamento 2 RU Основание прекращения 2 Основание прекращения 2 S Orsak till avslutning 2 Orsak till avslutning 2 TR Sonlandırma Nedeni 2 Sonlandırma Nedeni 2 US Termination Reason 2 Termination Reason 2 ZHS 终止原因 2 终止原因 2 10 90 :p_leav_reason3 LOV Oracle HR_LEAV_REAS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='LEAV_REAS' order by value,description AR سبب إنهاء الخدمة 3 سبب إنهاء الخدمة 3 D Kündigungsgrund 3 Kündigungsgrund 3 E Motivo 3 de Terminación Motivo 3 de terminación F Motif fin de contrat 3 Motif fin de contrat 3 I Motivo cessazione 3 Motivo cessazione 3 JA 退職理由3 退職理由3 KO 퇴직 사유 3 퇴직 사유 3 PTB Motivo do Desligamento 3 Motivo do Desligamento 3 RU Основание прекращения 3 Основание прекращения 3 S Orsak till avslutning 3 Orsak till avslutning 3 TR Sonlandırma Nedeni 3 Sonlandırma Nedeni 3 US Termination Reason 3 Termination Reason 3 ZHS 终止原因 3 终止原因 3 11 100 :p_leav_reason4 LOV Oracle HR_LEAV_REAS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='LEAV_REAS' order by value,description AR سبب إنهاء الخدمة 4 سبب إنهاء الخدمة 4 D Kündigungsgrund 4 Kündigungsgrund 4 E Motivo 4 de Terminación Motivo 4 de terminación F Motif fin de contrat 4 Motif fin de contrat 4 I Motivo cessazione 4 Motivo cessazione 4 JA 退職理由4 退職理由4 KO 퇴직 사유 4 퇴직 사유 4 PTB Motivo do Desligamento 4 Motivo do Desligamento 4 RU Основание прекращения 4 Основание прекращения 4 S Orsak till avslutning 4 Orsak till avslutning 4 TR Sonlandırma Nedeni 4 Sonlandırma Nedeni 4 US Termination Reason 4 Termination Reason 4 ZHS 终止原因 4 终止原因 4 12 110 :p_leav_reason5 LOV Oracle HR_LEAV_REAS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='LEAV_REAS' order by value,description AR سبب إنهاء الخدمة 5 سبب إنهاء الخدمة 5 D Kündigungsgrund 5 Kündigungsgrund 5 E Motivo 5 de Terminación Motivo 5 de terminación F Motif fin de contrat 5 Motif fin de contrat 5 I Motivo cessazione 5 Motivo cessazione 5 JA 退職理由5 退職理由5 KO 퇴직 사유 5 퇴직 사유 5 PTB Motivo do Desligamento 5 Motivo do Desligamento 5 RU Основание прекращения 5 Основание прекращения 5 S Orsak till avslutning 5 Orsak till avslutning 5 TR Sonlandırma Nedeni 5 Sonlandırma Nedeni 5 US Termination Reason 5 Termination Reason 5 ZHS 终止原因 5 终止原因 5 13 120 :p_leav_reason6 LOV Oracle HR_LEAV_REAS Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='LEAV_REAS' order by value,description AR سبب إنهاء الخدمة 6 سبب إنهاء الخدمة 6 D Kündigungsgrund 6 Kündigungsgrund 6 E Motivo 6 de Terminación Motivo 6 de terminación F Motif fin de contrat 6 Motif fin de contrat 6 I Motivo cessazione 6 Motivo cessazione 6 JA 退職理由6 退職理由6 KO 퇴직 사유 6 퇴직 사유 6 PTB Motivo do Desligamento 6 Motivo do Desligamento 6 RU Основание прекращения 6 Основание прекращения 6 S Orsak till avslutning 6 Orsak till avslutning 6 TR Sonlandırma Nedeni 6 Sonlandırma Nedeni 6 US Termination Reason 6 Termination Reason 6 ZHS 终止原因 6 终止原因 6