ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4204CD8FAE45CFD1E06362FB0905D0BAY 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) (1) Imported from BI Publisher Description: تقرير إنهاء الخدمات Application: الموارد البشرية Source: تقرير إنهاء الخدمات (بتنسيق XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG D PER Kündigungen (1) 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 (1) 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 (1) 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 (1) 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 退職レポート (1) Imported from BI Publisher Description: 退職レポート Application: Human Resources Source: 退職レポート(XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG KO PER 퇴직 보고서 (1) 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 (1) 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 Отчет о прекращениях (1) Imported from BI Publisher Description: Отчет о прекращениях Application: Персонал Source: Отчет о прекращениях (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG S PER Avslutningar - rapport (1) 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 (1) 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 (1) 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 终止报表 (1) Imported from BI Publisher Description: 终止报表 Application: 人力资源管理系统 Source: 终止报表 (XML) Short Name: PERRPRTM_XML DB package: PER_PERRPRTM_XMLP_PKG BI Publisher 1=1 :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 :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 US Business Group Id Business Group Id 2 -10 :debugflag Char N US DebugFlag DebugFlag 3 10 :p_session_date Date select fnd_date.date_to_displaydate(effective_date, 1) from fnd_sessions where session_id = userenv('sessionid') Y US Effective Date Effective Date 4 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 US Organization Structure Organization Structure 5 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 US Version Version 6 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 US Parent Organization Parent Organization 7 50 :p_date_from Date Y US Date From Date From 8 60 :p_date_to Date Y US Date To Date To 9 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 US Termination Reason 1 Termination Reason 1 10 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 US Termination Reason 2 Termination Reason 2 11 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 US Termination Reason 3 Termination Reason 3 12 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 US Termination Reason 4 Termination Reason 4 13 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 US Termination Reason 5 Termination Reason 5 14 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 US Termination Reason 6 Termination Reason 6