ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719651A9E05362FB09050512 select asg.person_id person_id6, asg.assignment_number assignment_number, ast.user_status status, hrl4.meaning primary2, org.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, asg.probation_period length, hrl4.meaning units, asg.date_probation_end end_date, asg.normal_hours working_hours, hrl3.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_date2, asg.effective_end_date effective_end_date2, asg.assignment_id assignment_id, asg.vendor_id vendor_id, asg.vendor_employee_number vendor_employee_number, asg.vendor_assignment_number vendor_assignment_number, -- PER_PERRPPSM_XMLP_PKG.c_pay_meth2formula(:ASSIGNMENT_ID) C_PAY_METH2 PER_PERRPPSM_XMLP_PKG.c_pay_meth2formula(asg.assignment_id) C_PAY_METH2 from per_all_assignments_f asg, per_assignment_status_types ast, hr_all_organization_units org, 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 asg.organization_id = org.organization_id 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 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.effective_start_date between ppa.effective_start_date (+) and ppa.effective_end_date (+) and :p_session_date between asg.effective_start_date and asg.effective_end_date and asg.business_group_id = :p_business_group_id and asg.person_id=:person_id5 order by hrl4.meaning desc, asg.assignment_id Y PER PERRPPSM_XML AR PER تقرير إجمالي العمال (بتنسيق XML) Imported from BI Publisher Description: إجمالي العمال Application: الموارد البشرية Source: تقرير إجمالي العمال (بتنسيق XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG D PER Befristete Mitarbeiter - Übersicht Imported from BI Publisher Description: Auswertung "Befristete Mitarbeiter - Übersicht" Application: Human Resources Source: Befristete Mitarbeiter - Übersicht (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG E PER Resumen del Trabajador Imported from BI Publisher Description: Resumen del trabajador Application: Human Resources Source: Resumen del Trabajador (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG F PER Etat Synthèse de l'intervenant Imported from BI Publisher Description: Synthèse de l'intervenant Application: Human Resources Source: Etat Synthèse de l'intervenant (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG I PER Rapporto Sintetico lavoratore Imported from BI Publisher Description: Sintetico lavoratore Application: Human Resources Source: Rapporto Sintetico lavoratore (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG JA PER 就業者要約レポート Imported from BI Publisher Description: 就業者要約 Application: Human Resources Source: 就業者要約レポート(XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG KO PER 근로자 요약 보고서 Imported from BI Publisher Description: 근로자 요약 Application: HR Source: 근로자 요약 보고서(XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG PTB PER Relatório Resumido do Trabalhador Imported from BI Publisher Description: Resumo do Trabalhador Application: Human Resources Source: Relatório Resumido do Trabalhador (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG RU PER Сводный отчет по работнику Imported from BI Publisher Description: Сводка для работника Application: Персонал Source: Сводный отчет по работнику (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG S PER Översiktsrapport över anställning Imported from BI Publisher Description: Anställningsöversikt Application: Human Resources Source: Översiktsrapport över anställning (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG TR PER İşçi Özet Raporu Imported from BI Publisher Description: Çalışan Özeti Application: İnsan Kaynakları Source: İşçi Özet Raporu (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG US PER Worker Summary Imported from BI Publisher Description: Worker Summary Application: Human Resources Source: Worker Summary Report (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG ZHS PER 人员汇总报表 Imported from BI Publisher Description: 人员汇总 Application: 人力资源管理系统 Source: 人员汇总报表 (XML) Short Name: PERRPPSM_XML DB package: PER_PERRPPSM_XMLP_PKG BI Publisher :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_business_group_name :c_cont_address1 :c_cont_address10 :c_cont_address11 :c_cont_address12 :c_cont_address13 :c_cont_address14 :c_cont_address15 :c_cont_address16 :c_cont_address17 :c_cont_address18 :c_cont_address19 :c_cont_address2 :c_cont_address20 :c_cont_address3 :c_cont_address4 :c_cont_address5 :c_cont_address6 :c_cont_address7 :c_cont_address8 :c_cont_address9 :c_cont_details :c_currency_code :c_details :c_end_of_time :c_header_name :c_pay_meth_count :c_requirement_desc :c_requirement_value :p_business_group_id :p_conc_request_id :p_person_id :p_session_date :p_session_date1 :p_special_info_segs :person_id5 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 HR_WORKFORCE Y select person_id id, full_name||' ('||npw_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' or p.current_npw_flag='Y') and fs.session_id=userenv('SESSIONID') order by value,description Y AR العامل العامل D Befristeter Mitarbeiter Befristeter Mitarbeiter E Trabajador Trabajador F Intervenant Intervenant I Lavoratore Lavoratore JA 就業者 就業者 KO 근로자 근로자 PTB Trabalhador Trabalhador RU Исполнитель Исполнитель S Anställning Anställning TR Çalışan Çalışan US Worker Worker ZHS 员工 员工