ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4718E51A9E05362FB09050512Y SELECT PAF.ORGANIZATION_ID, 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_PLACEMENT P, PER_PEOPLE_F PAP, PER_ASSIGNMENTS_F PAF WHERE P.ACTUAL_TERMINATION_DATE BETWEEN :P_DATE_FROM AND :P_DATE_TO AND P.ACTUAL_TERMINATION_DATE BETWEEN PAP.EFFECTIVE_START_DATE AND PAP.EFFECTIVE_END_DATE AND PAP.PERSON_ID = P.PERSON_ID AND PAF.PERSON_ID = P.PERSON_ID AND P.ACTUAL_TERMINATION_DATE BETWEEN PAF.EFFECTIVE_START_DATE AND PAF.EFFECTIVE_END_DATE AND PAF.ASSIGNMENT_TYPE = 'C' and PAF.ORGANIZATION_ID=:org_id GROUP by Organization_Id PER PERRPCTM_XML AR PER تقرير إنهاء التعيين (بتنسيق XML) Imported from BI Publisher Description: تقرير إنهاء التعيين Application: الموارد البشرية Source: تقرير إنهاء التعيين (بتنسيق XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG D PER Beschäftigungsende Imported from BI Publisher Description: Auswertung "Beschäftigungsende" Application: Human Resources Source: Beschäftigungsende (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG E PER Terminación de Asignación Imported from BI Publisher Description: Informe de terminación de asignación Application: Human Resources Source: Terminación de Asignación (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG F PER Etat Fin de placement Imported from BI Publisher Description: Etat Fin de placement Application: Human Resources Source: Etat Fin de placement (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG I PER Rapporto Concludi collocamento Imported from BI Publisher Description: Rapporto Concludi collocamento Application: Human Resources Source: Rapporto Concludi collocamento (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG JA PER 派遣完了レポート Imported from BI Publisher Description: 派遣完了レポート Application: Human Resources Source: 派遣完了レポート(XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG KO PER 지정 확정 보고서 Imported from BI Publisher Description: 지정 확정 보고서 Application: HR Source: 지정 확정 보고서(XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG PTB PER Concluir Relatório de Colocação Imported from BI Publisher Description: Concluir Relatório de Colocação Application: Human Resources Source: Concluir Relatório de Colocação (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG RU PER Отчет о завершении размещения Imported from BI Publisher Description: Отчет о завершении размещения Application: Персонал Source: Отчет о завершении размещения (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG S PER Avsluta placering - rapport Imported from BI Publisher Description: Avsluta placering - rapport Application: Human Resources Source: Avsluta placering - rapport (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG TR PER Yerleştirmeyi Tamamlama Raporu Imported from BI Publisher Description: Yerleştirmeyi Tamamlama Raporu Application: İnsan Kaynakları Source: Yerleştirmeyi Tamamlama Raporu (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG US PER Conclude Placement Imported from BI Publisher Description: Conclude Placement Report Application: Human Resources Source: Conclude Placement Report (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_XMLP_PKG ZHS PER 终止职位安排报表 Imported from BI Publisher Description: 终止职位安排报表 Application: 人力资源管理系统 Source: 终止职位安排报表 (XML) Short Name: PERRPCTM_XML DB package: PER_PERRPCTM_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_from_t :p_date_to :p_date_to_t :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 :p_session_date_t 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR مجموعة الأعمال معرف مجموعة الأعمال D Unternehmensgruppe Kennung Unternehmensgruppe E Grupo de Trabajo Identificador del grupo de trabajo F Entité professionnelle ID entité professionnelle I Business group Id del business group JA ビジネス・グループ ビジネス・グループID KO 업무 그룹 업무 그룹 ID PTB Grupo Funcional ID do Grupo Funcional RU Бизнес-группа Идентификатор бизнес-группы S Verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu İş Grubu No US Business Group 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_CWK_LEAVING_REASON Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HR_CWK_TERMINATION_REASONS' order by meaning Y AR سبب الإنهاء 1 سبب الإنهاء 1 D Beendigungsgrund 1 Beendigungsgrund 1 E Motivo de Terminación 1 Motivo de terminación 1 F Motif de fin 1 Motif de fin 1 I Motivo conclusione 1 Motivo conclusione 1 JA 完了理由1 完了理由1 KO 확정 사유 1 확정 사유 1 PTB Motivo da Conclusão 1 Motivo da Conclusão 1 RU Основание заключения 1 Основание заключения 1 S Orsak till avslutning 1 Orsak till avslutning 1 TR Tamamlama Nedeni 1 Tamamlama Nedeni 1 US Conclude Reason 1 Conclude Reason 1 ZHS 终止原因 1 终止原因 1 9 80 :p_leav_reason2 LOV Oracle HR_CWK_LEAVING_REASON Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HR_CWK_TERMINATION_REASONS' order by meaning AR سبب الإنهاء 2 سبب الإنهاء 2 D Beendigungsgrund 2 Beendigungsgrund 2 E Motivo de Terminación 2 Motivo de terminación 2 F Motif de fin 2 Motif de fin 2 I Motivo conclusione 2 Motivo conclusione 2 JA 完了理由2 完了理由2 KO 확정 사유 2 확정 사유 2 PTB Motivo da Conclusão 2 Motivo da Conclusão 2 RU Основание заключения 2 Основание заключения 2 S Orsak till avslutning 2 Orsak till avslutning 2 TR Tamamlama Nedeni 2 Tamamlama Nedeni 2 US Conclude Reason 2 Conclude Reason 2 ZHS 终止原因 2 终止原因 2 10 90 :p_leav_reason3 LOV Oracle HR_CWK_LEAVING_REASON Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HR_CWK_TERMINATION_REASONS' order by meaning AR سبب الإنهاء 3 سبب الإنهاء 3 D Beendigungsgrund 3 Beendigungsgrund 3 E Motivo de Terminación 3 Motivo de terminación 3 F Motif de fin 3 Motif de fin 3 I Motivo conclusione 3 Motivo conclusione 3 JA 完了理由3 完了理由3 KO 확정 사유 3 확정 사유 3 PTB Motivo da Conclusão 3 Motivo da Conclusão 3 RU Основание заключения 3 Основание заключения 3 S Orsak till avslutning 3 Orsak till avslutning 3 TR Tamamlama Nedeni 3 Tamamlama Nedeni 3 US Conclude Reason 3 Conclude Reason 3 ZHS 终止原因 3 终止原因 3 11 100 :p_leav_reason4 LOV Oracle HR_CWK_LEAVING_REASON Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HR_CWK_TERMINATION_REASONS' order by meaning AR سبب الإنهاء 4 سبب الإنهاء 4 D Beendigungsgrund 4 Beendigungsgrund 4 E Motivo de Terminación 4 Motivo de terminación 4 F Motif de fin 4 Motif de fin 4 I Motivo conclusione 4 Motivo conclusione 4 JA 完了理由4 完了理由4 KO 확정 사유 4 확정 사유 4 PTB Motivo da Conclusão 4 Motivo da Conclusão 4 RU Основание заключения 4 Основание заключения 4 S Orsak till avslutning 4 Orsak till avslutning 4 TR Tamamlama Nedeni 4 Tamamlama Nedeni 4 US Conclude Reason 4 Conclude Reason 4 ZHS 终止原因 4 终止原因 4 12 110 :p_leav_reason5 LOV Oracle HR_CWK_LEAVING_REASON Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HR_CWK_TERMINATION_REASONS' order by meaning AR سبب الإنهاء 5 سبب الإنهاء 5 D Beendigungsgrund 5 Beendigungsgrund 5 E Motivo de Terminación 5 Motivo de terminación 5 F Motif de fin 5 Motif de fin 5 I Motivo conclusione 5 Motivo conclusione 5 JA 完了理由5 完了理由5 KO 확정 사유 5 확정 사유 5 PTB Motivo da Conclusão 5 Motivo da Conclusão 5 RU Основание заключения 5 Основание заключения 5 S Orsak till avslutning 5 Orsak till avslutning 5 TR Tamamlama Nedeni 5 Tamamlama Nedeni 5 US Conclude Reason 5 Conclude Reason 5 ZHS 终止原因 5 终止原因 5 13 120 :p_leav_reason6 LOV Oracle HR_CWK_LEAVING_REASON Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HR_CWK_TERMINATION_REASONS' order by meaning AR سبب الإنهاء 6 سبب الإنهاء 6 D Beendigungsgrund 6 Beendigungsgrund 6 E Motivo de Terminación 6 Motivo de terminación 6 F Motif de fin 6 Motif de fin 6 I Motivo conclusione 6 Motivo conclusione 6 JA 完了理由6 完了理由6 KO 확정 사유 6 확정 사유 6 PTB Motivo da Conclusão 6 Motivo da Conclusão 6 RU Основание заключения 6 Основание заключения 6 S Orsak till avslutning 6 Orsak till avslutning 6 TR Tamamlama Nedeni 6 Tamamlama Nedeni 6 US Conclude Reason 6 Conclude Reason 6 ZHS 终止原因 6 终止原因 6