ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719451A9E05362FB09050512Y select asg.person_id, asg.soft_coding_keyflex_id, asg.assignment_number assignment_number, astl.user_status status, hrl4.meaning primary, orgtl.name organization, ppg.group_name group_name, jbt.name job, hr_general.decode_position_latest_name(asg.position_id) position, gdt.name grade, ppa.payroll_name payroll, loc.location_code location, peo.full_name supervisor, asg.change_reason reason, &c_ass_df_details con_ass_df, &c_ass_df_label conc_ass_label_df, asg.probation_period length, hrl2.meaning units, asg.date_probation_end end_date, asg.normal_hours working_hours, hrl.meaning frequency, asg.time_normal_start start_time, asg.time_normal_finish end_time, hrl3.meaning manager, asg.internal_address_line internal_address, asg.effective_start_date effective_start_date, substr(asg.effective_end_date,1,11) effective_end_date, asg.assignment_id assignment_id, asg.period_of_service_id, asg.comment_id, PER_PERRPFP3_XMLP_PKG.c_scl_segsformula() C_scl_segs from per_all_assignments_f asg, per_assignment_status_types ast, per_assignment_status_types_tl astl, hr_all_organization_units org, hr_all_organization_units_tl orgtl, pay_all_payrolls_f ppa, per_jobs_tl jbt, per_grades_tl gdt, pay_people_groups ppg, hr_locations loc, per_all_people_f peo, hr_lookups hrl, hr_lookups hrl2, hr_lookups hrl3, hr_lookups hrl4 where asg.assignment_status_type_id = ast.assignment_status_type_id and ast.assignment_status_type_id = astl.assignment_status_type_id and astl.language = userenv('LANG') and asg.organization_id = org.organization_id and org.organization_id = orgtl.organization_id and orgtl.language = userenv('LANG') and asg.payroll_id = ppa.payroll_id (+) and asg.job_id = jbt.job_id (+) and jbt.language(+) = userenv('LANG') and asg.grade_id = gdt.grade_id (+) and gdt.language(+) = userenv('LANG') and asg.people_group_id = ppg.people_group_id (+) and asg.location_id = loc.location_id (+) and asg.supervisor_id = peo.person_id (+) and :p_session_date between peo.effective_start_date (+) and peo.effective_end_date (+) and :p_session_date between asg.effective_start_date and asg.effective_end_date and :p_session_date between ppa.effective_start_date (+) and ppa.effective_end_date(+) and hrl.lookup_type (+) = 'FREQUENCY' and hrl.lookup_code (+) = asg.frequency and hrl2.lookup_type (+) = 'QUALIFYING_UNITS' and hrl2.lookup_code (+) = asg.probation_unit and hrl3.lookup_type (+) = 'YES_NO' and hrl3.lookup_code (+) = asg.manager_flag and hrl4.lookup_type (+) = 'YES_NO' and hrl4.lookup_code (+) = asg.primary_flag and asg.business_group_id = :p_business_group_id and asg.period_of_service_id=:period_of_service_id1 order by hrl4.meaning desc, asg.assignment_id,asg.effective_start_date PER PERRPFP3_XML AR PER تقرير التفاصيل الكاملة عن التعيين (بتنسيق XML) Imported from BI Publisher Description: التفاصيل الكاملة عن التعيين Application: الموارد البشرية Source: تقرير التفاصيل الكاملة عن التعيين (بتنسيق XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG D PER Vollständige Stellendaten Imported from BI Publisher Description: Vollständige Stellendaten Application: Human Resources Source: Vollständige Stellendaten (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG E PER Detalles Completos de Asignación Imported from BI Publisher Description: Detalles completos de asignación Application: Human Resources Source: Detalles Completos de Asignación (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG F PER Etat détaillé sur les affectations Imported from BI Publisher Description: Etat détaillé sur les affectations Application: Human Resources Source: Etat détaillé sur les affectations (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG I PER Rapporto Dettagli completi assegnazione Imported from BI Publisher Description: Dettagli assegnazione completi Application: Human Resources Source: Rapporto Dettagli completi assegnazione (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG JA PER アサイメント詳細レポート Imported from BI Publisher Description: アサイメント詳細 Application: Human Resources Source: アサイメント詳細レポート(XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG KO PER 전체 발령 상세내역 보고서 Imported from BI Publisher Description: 전체 발령 상세내역 Application: HR Source: 전체 발령 상세내역 보고서(XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG PTB PER Relatório Detalhes Completos sobre a Atribuição Imported from BI Publisher Description: Detalhes Completos sobre a Atribuição Application: Human Resources Source: Relatório Detalhes Completos sobre a Atribuição (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG RU PER Подробный отчет о назначениях Imported from BI Publisher Description: Подробные сведения о назначениях Application: Персонал Source: Подробный отчет о назначениях (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG S PER Fullständiga anst.uppdragsdetaljer - rapport Imported from BI Publisher Description: Fullständiga anställningsdetaljer Application: Human Resources Source: Fullständiga anst.uppdragsdetaljer - rapport (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG TR PER Tam Görev Detayları Raporu Imported from BI Publisher Description: Tam Görev Detayları Application: İnsan Kaynakları Source: Tam Görev Detayları Raporu (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG US PER Full Assignment Details Imported from BI Publisher Description: Full Assignment Details Application: Human Resources Source: Full Assignment Details Report (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG ZHS PER 完整的分配详细信息报表 Imported from BI Publisher Description: 完整的分配详细信息 Application: 人力资源管理系统 Source: 完整的分配详细信息报表 (XML) Short Name: PERRPFP3_XML DB package: PER_PERRPFP3_XMLP_PKG BI Publisher &c_ass_df_details &c_ass_df_label :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_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_currency_code :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_acct_id :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_session_date :p_session_date1 :p_special_info_segs :period_of_service_id1 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 员工 员工