ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719251A9E05362FB09050512Y select hrl.meaning || decode(hrl.meaning,null,null,' ') || peo.first_name || decode(peo.first_name,null,null,' ') || peo.last_name name, peo.comment_id comment_id1, --&c_emp_df_details conc_emp_df, &c_emp_df_details conc_emp_df1, &c_emp_df_label conc_emp_label_df, peo.middle_names middle_names, peo.known_as known_as, hrl2.meaning sex, peo.previous_last_name previous_surname, hrl3.meaning registered_disabled, peo.date_of_birth date_of_birth, hrl4.meaning marital_status, hrl5.meaning nationality, peo.national_identifier national_identifier, hr_person_type_usage_info.get_user_person_type(peo.effective_end_date,peo.person_id) person_type, peo.employee_number employee_number, peo.applicant_number applicant_number, pp.phone_number work_tel_no, peo.email_address email_address, hrl6.meaning expense_cheque, peo.effective_start_date effective_start_date_1, peo.effective_end_date effective_end_date_1, peo.person_id person_id_1, peo.PER_INFORMATION_CATEGORY, decode(:p_town_of_birth,null,peo.town_of_birth,hr_general.decode_lookup(:p_town_of_birth, peo.town_of_birth)) town_of_birth, decode(:p_region_of_birth,null,peo.region_of_birth,hr_general.decode_lookup(:p_region_of_birth,peo.region_of_birth)) region_of_birth, ftl.territory_short_name country_of_birth, PER_PERRPFP1_XMLP_PKG.c_get_emp_leg_dfformula(peo.PER_INFORMATION_CATEGORY) C_get_emp_leg_df from per_all_people_f peo, per_phones pp, hr_lookups hrl, hr_lookups hrl2, hr_lookups hrl3, hr_lookups hrl4, hr_lookups hrl5, hr_lookups hrl6, fnd_territories_vl ftl where peo.person_id = :p_person_id and pp.parent_table (+) = 'PER_ALL_PEOPLE_F' and pp.phone_type (+) = 'W1' and pp.parent_id (+) = peo.person_id and :p_session_date between nvl(pp.date_from,:p_session_date) and nvl(pp.date_to,:p_session_date) and hrl.lookup_type (+) = 'TITLE' and hrl.lookup_code (+) = peo.title and hrl2.lookup_type (+) = 'SEX' and hrl2.lookup_code (+) = peo.sex and hrl3.lookup_type (+) = 'YES_NO' and hrl3.lookup_code (+) = peo.registered_disabled_flag and hrl4.lookup_type (+) = 'MAR_STATUS' and hrl4.lookup_code (+) = peo.marital_status and hrl5.lookup_type (+) = 'NATIONALITY' and hrl5.lookup_code (+) = peo.nationality and hrl6.lookup_type (+) = 'HOME_OFFICE' and hrl6.lookup_code (+) = peo.expense_check_send_to_address and peo.business_group_id = :P_BUSINESS_GROUP_ID and peo.country_of_birth = ftl.territory_code (+) order by peo.effective_start_date PER PERRPFP1_XML AR PER تقرير التفاصيل الكاملة عن الشخص (بتنسيق XML) Imported from BI Publisher Description: التفاصيل الكاملة عن الشخص Application: الموارد البشرية Source: تقرير التفاصيل الكاملة عن الشخص (بتنسيق XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG D PER Vollständige Personendaten Imported from BI Publisher Description: Vollständige Personendaten Application: Human Resources Source: Vollständige Personendaten (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG E PER Detalles Completos de Persona Imported from BI Publisher Description: Detalles completos de persona Application: Human Resources Source: Detalles Completos de Persona (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG F PER Etat des détails complets sur une personne Imported from BI Publisher Description: Détails complets sur une personne Application: Human Resources Source: Etat des détails complets sur une personne (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG I PER Rapporto Dettagli persona completi Imported from BI Publisher Description: Dettagli persona completi Application: Human Resources Source: Rapporto Dettagli persona completi (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG JA PER 個人詳細レポート Imported from BI Publisher Description: 個人詳細 Application: Human Resources Source: 個人詳細レポート(XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG KO PER 전체 개인 상세내역 보고서 Imported from BI Publisher Description: 전체 개인 상세내역 Application: HR Source: 전체 개인 상세내역 보고서(XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG PTB PER Relatório de Detalhes Completos sobre a Pessoa Imported from BI Publisher Description: Detalhes Completos sobre a Pessoa Application: Human Resources Source: Relatório de Detalhes Completos sobre a Pessoa (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG RU PER Подробный отчет по личным данным Imported from BI Publisher Description: Подробные личные данные Application: Персонал Source: Подробный отчет по личным данным (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG S PER Fullständiga persondetaljer - rapport Imported from BI Publisher Description: Fullständiga persondetaljer Application: Human Resources Source: Fullständiga persondetaljer - rapport (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG TR PER Tam Kişi Detayları Raporu Imported from BI Publisher Description: Tam Kişi Detayları Application: İnsan Kaynakları Source: Tam Kişi Detayları Raporu (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG US PER Full Person Details Imported from BI Publisher Description: Full Person Details Application: Human Resources Source: Full Person Details Report (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG ZHS PER 完整的人员详细信息报表 Imported from BI Publisher Description: 完整的人员详细信息 Application: 人力资源管理系统 Source: 完整的人员详细信息报表 (XML) Short Name: PERRPFP1_XML DB package: PER_PERRPFP1_XMLP_PKG BI Publisher &c_emp_df_details &c_emp_df_label :c_absence_df_details :c_absence_df_label :c_add_df_details :c_add_df_label :c_address1 :c_address10 :c_address11 :c_address12 :c_address13 :c_address14 :c_address15 :c_address16 :c_address17 :c_address18 :c_address19 :c_address2 :c_address20 :c_address3 :c_address4 :c_address5 :c_address6 :c_address7 :c_address8 :c_address9 :c_app_ass_df_details :c_app_ass_df_label :c_app_df_details :c_app_df_label :c_app_sec_status_details :c_app_sec_status_label :c_ass_df_details :c_ass_df_label :c_book_df_details :c_book_df_label :c_business_group_name :c_cont_details :c_cont_df_details :c_cont_df_label :c_cost_desc :c_cost_id_flex_num :c_cost_values :c_details :c_details10 :c_ele_cost_desc :c_ele_cost_values :c_ele_df_details :c_ele_df_label :c_emp_df_details :c_emp_df_label :c_emp_leg_df_details :c_emp_leg_df_label :c_end_of_time :c_event_df_details :c_event_df_label :c_ext_act_desc :c_ext_act_values :c_fur_info_ddf_details :c_fur_info_ddf_label :c_fur_info_df_details :c_fur_info_df_label :c_header_name :c_inter_df_details :c_inter_df_label :c_pay_meth_count :c_per_serv_df_details :c_per_serv_df_label :c_ppm_df_details :c_ppm_df_label :c_requirement_desc :c_requirement_value :c_scl_desc :c_scl_id_flex_num :c_scl_value :c_sec_ass_df_details :c_sec_ass_df_label :c_special_df_details :c_special_df_label :c_subtitle :c_temp :p_ass_cost_segs :p_ass_scl_segs :p_business_group_id :p_conc_request_id :p_ext_act_segs :p_person_id :p_region_of_birth :p_session_date :p_session_date1 :p_special_info_segs :p_town_of_birth 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) 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_person_id LOV Oracle PER_EMPLOYEES Y Y select person_id id, full_name||' ('||employee_number||')' value, null description from per_people_f p,fnd_sessions fs where p.business_group_id+0=fnd_global.per_business_group_id and fs.effective_date between p.effective_start_date and p.effective_end_date and p.current_employee_flag='Y' and fs.session_id=userenv('SESSIONID') order by value,description Y AR الموظف الموظف D Mitarbeiter Mitarbeiter E Empleado Empleado F Employé Employé I Dipendente Dipendente JA 従業員 従業員 KO 사원 사원 PTB Funcionário Funcionário RU Работник Работник S Anställd Anställd TR Çalışan Çalışan US Employee Employee ZHS 员工 员工