ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719551A9E05362FB09050512Y select con.contact_person_id , con.person_id , con.contact_relationship_id , hl1.meaning Contact_primary , hl2.meaning Relationship , hr3.meaning || decode(hr3.meaning,null,null,' ') || peo.first_name || decode(peo.first_name,null,null,' ') || peo.last_name person , hr4.meaning dependent from per_contact_relationships con , per_all_people_f peo , hr_lookups hl1 , hr_lookups hl2 , hr_lookups hr3 , hr_lookups hr4 where con.contact_person_id = :P_PERSON_ID and hl1.lookup_code = con.primary_contact_flag and hl1.lookup_type = 'YES_NO' and hl2.lookup_code = con.contact_type and hl2.lookup_type = 'CONTACT' and con.business_group_id = :p_business_group_id and hr3.lookup_type (+) = 'TITLE' and hr3.lookup_code (+) = peo.title and peo.person_id = con.person_id and peo.effective_start_date = (select min(peo2.effective_start_date) from per_all_people_f peo2 where peo2.person_id = peo.person_id) and hr4.lookup_type (+) = 'YES_NO' and hr4.lookup_code (+) = con.dependent_flag order by con.contact_relationship_id PER PERRPFP4_XML AR PER تقرير التفاصيل الكاملة عن العمل (بتنسيق XML) Imported from BI Publisher Description: التفاصيل الكاملة عن العمل Application: الموارد البشرية Source: تقرير التفاصيل الكاملة عن العمل (بتنسيق XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG D PER Vollständige Arbeitsdaten Imported from BI Publisher Description: Vollständige Arbeitsdaten Application: Human Resources Source: Vollständige Arbeitsdaten (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG E PER Detalles Completos de Trabajo Imported from BI Publisher Description: Detalles completos de trabajo Application: Human Resources Source: Detalles Completos de Trabajo (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG F PER Etat des détails complets sur un travail Imported from BI Publisher Description: Détails complets sur un travail Application: Human Resources Source: Etat des détails complets sur un travail (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG I PER Rapporto Dettagli lavoro completi Imported from BI Publisher Description: Dettagli mansione completi Application: Human Resources Source: Rapporto Dettagli lavoro completi (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG JA PER 勤務詳細レポート Imported from BI Publisher Description: 勤務詳細 Application: Human Resources Source: 勤務詳細レポート(XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG KO PER 전체 작업 상세내역 보고서 Imported from BI Publisher Description: 전체 작업 상세내역 Application: HR Source: 전체 작업 상세내역 보고서(XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG PTB PER Relatório de Detalhes Completos do Trabalho Imported from BI Publisher Description: Detalhes Completos do Trabalho Application: Human Resources Source: Relatório de Detalhes Completos do Trabalho (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG RU PER Подробный отчет о работе Imported from BI Publisher Description: Подробные сведения о работе Application: Персонал Source: Подробный отчет о работе (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG S PER Fullständiga arbetsdetaljer - rapport Imported from BI Publisher Description: Fullständiga arbetsdetaljer Application: Human Resources Source: Fullständiga arbetsdetaljer - rapport (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG TR PER Tam İş Detayları Raporu Imported from BI Publisher Description: Tam İş Detayları Application: İnsan Kaynakları Source: Tam İş Detayları Raporu (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG US PER Full Work Details Imported from BI Publisher Description: Full Work Details Application: Human Resources Source: Full Work Details Report (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG ZHS PER 完整的工作详细信息报表 Imported from BI Publisher Description: 完整的工作详细信息 Application: 人力资源管理系统 Source: 完整的工作详细信息报表 (XML) Short Name: PERRPFP4_XML DB package: PER_PERRPFP4_XMLP_PKG BI Publisher :c_absence_df_details :c_absence_df_label :c_add_df_details :c_add_df_label :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_authorized_by :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_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_replaced_by :c_req_descript :c_req_value :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_session_date :p_session_date1 :p_special_info_segs 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 员工 员工