ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719351A9E05362FB09050512Y select vac.name vacancy, rac.name recruitment_activity, asg.assignment_id assignment_number, org.name organization, jbt.name job, &c_app_ass_df_details conc_app_ass_df, &c_app_ass_df_label conc_app_ass_label_df, gdt.name grade, astl.user_status status, ppg.group_name group_name, hr_general.decode_position_latest_name(asg.position_id) position, loc.location_code location, asg.change_reason reason, peo.full_name recruiter, peo2.full_name referred_by, 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, peo3.full_name supervisor, hrl5.meaning manager, asg.effective_start_date effective_start_date, asg.effective_end_date effective_end_date, to_char(asg.effective_start_date,'YYYY/MM/DD HH24:MI:SS') ESD, to_char(asg.effective_end_date,'YYYY/MM/DD HH24:MI:SS') EED, asg.assignment_id assignment_id, asg.application_id application_id, asg.comment_id from per_all_assignments_f asg, per_assignment_status_types ast, per_assignment_status_types_tl astl, per_recruitment_activities rac, per_vacancies vac, per_all_organization_units org, per_jobs_tl jbt, per_grades_tl gdt, pay_people_groups ppg, hr_locations loc, per_all_people_f peo, per_all_people_f peo2, per_all_people_f peo3, hr_lookups hrl3, hr_lookups hrl4, hr_lookups hrl5 where asg.person_id = :p_person_id and asg.business_group_id = :p_business_group_id and asg.period_of_service_id is null and 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.vacancy_id = vac.vacancy_id (+) and asg.recruitment_activity_id = rac.recruitment_activity_id (+) and asg.organization_id = org.organization_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.recruiter_id = peo.person_id (+) and asg.person_referred_by_id = peo2.person_id (+) and asg.supervisor_id = peo3.person_id (+) and hrl3.lookup_type (+) = 'FREQUENCY' and hrl3.lookup_code (+) = asg.frequency and hrl4.lookup_type (+) = 'QUALIFYING_UNITS' and hrl4.lookup_code (+) = asg.probation_unit and hrl5.lookup_type (+) = 'YES_NO' and hrl5.lookup_code (+) = asg.manager_flag and :p_session_date between peo.effective_start_date (+) and peo.effective_end_date (+) and :p_session_date between peo2.effective_start_date (+) and peo2.effective_end_date (+) and :p_session_date between peo3.effective_start_date (+) and peo3.effective_end_date (+) and asg.application_id=:application_id1 order by asg.effective_start_date PER PERRPFP2_XML AR PER تقرير التفاصيل الكاملة عن طالب التوظف (بتنسيق XML) Imported from BI Publisher Description: التفاصيل الكاملة عن طالب التوظف Application: الموارد البشرية Source: تقرير التفاصيل الكاملة عن طالب التوظف (بتنسيق XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG D PER Vollständige Bewerberdaten Imported from BI Publisher Description: Vollständige Bewerberdaten Application: Human Resources Source: Vollständige Bewerberdaten (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG E PER Detalles Completos de Solicitante Imported from BI Publisher Description: Detalles completos de solicitante Application: Human Resources Source: Detalles Completos de Solicitante (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG F PER Etat détaillé sur les candidats Imported from BI Publisher Description: Détails complets du candidat Application: Human Resources Source: Etat détaillé sur les candidats (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG I PER Rapporto Dettagli completi candidati Imported from BI Publisher Description: Dettagli candidato completi Application: Human Resources Source: Rapporto Dettagli completi candidati (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG JA PER 応募者詳細レポート Imported from BI Publisher Description: 応募者詳細 Application: Human Resources Source: 応募者詳細レポート(XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG KO PER 전체 지원자 상세내역 보고서 Imported from BI Publisher Description: 전체 지원자 상세내역 Application: HR Source: 전체 지원자 상세내역 보고서(XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG PTB PER Relatório de Detalhes Completos sobre o Candidato Imported from BI Publisher Description: Detalhes Completos sobre o Candidato Application: Human Resources Source: Relatório de Detalhes Completos sobre o Candidato (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG RU PER Подробные сведения о претендентах Imported from BI Publisher Description: Подробные сведения о претендентах Application: Персонал Source: Подробные сведения о претендентах (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG S PER Fullständiga sökandedetaljer - rapport Imported from BI Publisher Description: Fullständiga sökandedetaljer Application: Human Resources Source: Fullständiga sökandedetaljer - rapport (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG TR PER Tam Aday Detayları Raporu Imported from BI Publisher Description: Tam Aday Detayları Application: İnsan Kaynakları Source: Tam Aday Detayları Raporu (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG US PER Full Applicant Details Imported from BI Publisher Description: Full Applicant Details Application: Human Resources Source: Full Applicant Details Report (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG ZHS PER 完整的申请人详细信息报表 Imported from BI Publisher Description: 完整的申请人详细信息 Application: 人力资源管理系统 Source: 完整的申请人详细信息报表 (XML) Short Name: PERRPFP2_XML DB package: PER_PERRPFP2_XMLP_PKG BI Publisher &c_app_ass_df_details &c_app_ass_df_label :application_id1 :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_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_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 PER_DATES_STANDARD تاريخ الفعالية D PER_DATES_STANDARD Gültigkeitsdatum E PER_DATES_STANDARD Fecha en vigor F PER_DATES_STANDARD Date de validité I PER_DATES_STANDARD Data di validità JA PER_DATES_STANDARD 有効日 KO PER_DATES_STANDARD 유효 일자 PTB PER_DATES_STANDARD Data de Efetivação RU PER_DATES_STANDARD Дата действия S PER_DATES_STANDARD Giltighetsdatum TR PER_DATES_STANDARD Geçerlilik Tarihi US PER_DATES_STANDARD Effective Date ZHS PER_DATES_STANDARD 有效日期 3 20 :p_person_id LOV Oracle PER_APPLICANTS Y Y select person_id id, full_name||' ('||applicant_number||')' value, null description from per_people_f where business_group_id=fnd_global.per_business_group_id and to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') between effective_start_date and effective_end_date and current_applicant_flag='Y' order by value,description Y AR طالب التوظف الموظف D Bewerber Mitarbeiter E Solicitante Empleado F Candidat Employé I Candidato Dipendente JA 応募者 従業員 KO 지원자 사원 PTB Candidato Funcionário RU Претендент Работник S Sökande Anställd TR Aday Çalışan US Applicant Employee ZHS 申请人 员工 :$flex$.per_dates_standard PER_DATES_STANDARD Y Applicant