ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719851A9E05362FB09050512Y select p.full_name name , p.employee_number employee_number , p.applicant_number applicant_number , m.meaning manager_flag , pf.meaning primary_flag , o.name organization , l.location_code location , r.name recruitment_activity , v.name vacancy , nvl(btl.user_status,stl.user_status) status , a.assignment_status_type_id , a.assignment_id , a.effective_start_date , a.effective_end_date , a.assignment_type , a.organization_id , decode(a.assignment_type,'A',1,0) count_applicants , decode(a.assignment_type,'E',1,0) count_employees , decode(nvl(b.active_flag,s.active_flag),'N','*',NULL) active_status_flag, PER_PERRPRAS_XMLP_PKG.c_status_end_dateformula(a.assignment_id, a.assignment_status_type_id) C_STATUS_END_DATE, PER_PERRPRAS_XMLP_PKG.c_status_start_dateformula(a.assignment_id, a.assignment_status_type_id) C_STATUS_START_DATE from per_assignments_f a , per_people_f p , hr_organization_units o , pay_people_groups g , per_vacancies v , per_recruitment_activities r , hr_lookups m , hr_lookups pf , hr_locations l , per_assignment_status_types s , per_assignment_status_types_tl stl , per_ass_status_type_amends b , per_ass_status_type_amends_tl btl where ( (a.assignment_type || '' ='E' and NVL(:P_PRIMARY_FLAG,a.primary_flag) = a.primary_flag) or a.assignment_type || '' != 'E' ) &P_JOB_MATCHING &P_POSITION_MATCHING &P_GRADE_MATCHING &P_PAYROLL_MATCHING and :C_SESSION_DATE between a.effective_start_date and a.effective_end_date and p.person_id = a.person_id and :C_SESSION_DATE between p.effective_start_date and p.effective_end_date and (:P_PEOPLE_GROUP_ID is null or :P_PEOPLE_GROUP_ID is not null &P_MATCHING_CRITERIA) and g.id_flex_num(+) = :P_PEOPLE_GROUP_FLEX_ID and g.people_group_id(+) = a.people_group_id &P_STATUS_MATCHING_1 &P_ORG_MATCHING and m.lookup_type(+) = 'YES_NO' and m.lookup_code(+) = a.manager_flag and pf.lookup_type(+) = 'YES_NO' and pf.lookup_code(+) = a.primary_flag and o.organization_id = a.organization_id and a.location_id = l.location_id(+) and a.recruitment_activity_id = r.recruitment_activity_id(+) and a.vacancy_id = v.vacancy_id(+) and a.assignment_status_type_id = s.assignment_status_type_id and b.assignment_status_type_id(+) = a.assignment_status_type_id and b.business_group_id(+) = a.business_group_id and s.assignment_status_type_id = stl.assignment_status_type_id and b.ass_status_type_amend_id = btl.ass_status_type_amend_id(+) and decode(btl.ass_status_type_amend_id, NULL, '1', btl.language) = decode(btl.ass_status_type_amend_id, NULL, '1', userenv('LANG')) and stl.language = userenv('LANG') order by NVL(p.order_name,p.full_name), assignment_sequence, assignment_number PER PERRPRAS_XML AR PER تقرير حالة التعيين (بتنسيق XML) Imported from BI Publisher Description: تقرير حالة التعيين Application: الموارد البشرية Source: تقرير حالة التعيين (بتنسيق XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG D PER Stellenzuordnungsstatus Imported from BI Publisher Description: Auswertung "Stellenzuordnungsstatus" Application: Human Resources Source: Stellenzuordnungsstatus (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG E PER Estado de Asignación Imported from BI Publisher Description: Informe de estado de asignación Application: Human Resources Source: Estado de Asignación (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG F PER Etat des statuts des affectations Imported from BI Publisher Description: Etat des statuts des affectations Application: Human Resources Source: Etat des statuts des affectations (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG I PER Rapporto Stato assegnazione Imported from BI Publisher Description: Rapporto Stato assegnazione Application: Human Resources Source: Rapporto Stato assegnazione (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG JA PER アサイメント状況レポート Imported from BI Publisher Description: アサイメント状況レポート Application: Human Resources Source: アサイメント状況レポート(XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG KO PER 발령 상태 보고서 Imported from BI Publisher Description: 발령 상태 보고서 Application: HR Source: 발령 상태 보고서(XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG PTB PER Relatório do Status da Atribuição Imported from BI Publisher Description: Relatório do Status da Atribuição Application: Human Resources Source: Relatório do Status da Atribuição (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG RU PER Отчет о статусе назначений Imported from BI Publisher Description: Отчет о статусе назначений Application: Персонал Source: Отчет о статусе назначений (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG S PER Status på anst.uppdrag - rapport Imported from BI Publisher Description: Status på anst.uppdrag - rapport Application: Human Resources Source: Status på anst.uppdrag - rapport (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG TR PER Görev Statüsü Raporu Imported from BI Publisher Description: Görev Statüsü Raporu Application: İnsan Kaynakları Source: Görev Statüsü Raporu (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG US PER Assignment Status Imported from BI Publisher Description: Assignment Status Report Application: Human Resources Source: Assignment Status Report (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG ZHS PER 分配状态报表 Imported from BI Publisher Description: 分配状态报表 Application: 人力资源管理系统 Source: 分配状态报表 (XML) Short Name: PERRPRAS_XML DB package: PER_PERRPRAS_XMLP_PKG BI Publisher &p_grade_matching &p_job_matching &p_matching_criteria &p_org_matching &p_payroll_matching &p_position_matching &p_status_matching_1 :c_asg_status_desc1 :c_asg_status_desc2 :c_asg_status_desc3 :c_asg_status_desc4 :c_business_group_name :c_global_hierarchy :c_grade_desc :c_job_desc :c_org_structure_desc :c_org_structure_version_desc :c_organization_desc :c_payroll_desc :c_person_type_desc :c_position_desc :c_primary_flag_desc :c_report_subtitle :c_session_date :c_status_list :c_version_from_desc :c_version_to_desc :p_apl_order :p_asg_status_type_id1 :p_asg_status_type_id2 :p_asg_status_type_id3 :p_asg_status_type_id4 :p_business_group_id :p_conc_request_id :p_emp_order :p_grade_id :p_grade_matching :p_job_id :p_job_matching :p_legislation_code :p_matching_criteria :p_org_matching :p_org_structure_version_id :p_organization_structure_id :p_parent_organization_id :p_payroll_id :p_payroll_matching :p_people_group_flex_id :p_people_group_id :p_person_type :p_position_id :p_position_matching :p_primary_flag :p_session_date :p_session_date1 :p_status_matching :p_status_matching_1 1 -30 :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 -20 :p_people_group_flex_id Number select people_group_structure from per_business_groups where business_group_id = fnd_global.PER_BUSINESS_GROUP_ID Y AR المعرف المرن للمجموعة المعرف المرن للمجموعة D Kennung Gruppen-FlexFeld Kennung Gruppen-FlexFeld E Id Estructura de Grupo Identificador de la estructura de grupo F ID champ flexible groupe ID champ flexible groupe I Id flexfield gruppo Id del flexfield di gruppo JA グループ・フレックスID グループ・フレックスID KO 그룹 가변 ID 그룹 가변 ID PTB ID do Flexfield de Grupo ID do Flexfield de Grupo RU Идентификатор гибкого поля группы Идентификатор гибкого поля группы S Flex-id för grupp Flex-id för grupp TR Grup Esnek No Grup Esnek No US Group Flex ID Group Flex ID ZHS 组弹性域标识 组弹性域标识 3 10 :p_session_date Date select fnd_date.date_to_displaydate(effective_date, 1) 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 有效日期 4 20 :p_organization_structure_id LOV Oracle PER_ORG_STRUCTS_GLOBAL Y select organization_structure_id id, name||decode(business_group_id,null,' (*)',null) value, null description from per_organization_structures where business_group_id=fnd_global.per_business_group_id or (business_group_id is null and (select p.business_group_id from per_security_profiles p where p.security_profile_id=fnd_global.per_security_profile_id) is null) order by name AR هيكل المنشأة هيكل المنشأة D Organisationsstruktur Organisationsstruktur E Estructura de Organización Estructura de organización F Structure de l'organisation Structure de l'organisation I Struttura organizzazione Struttura dell'organizzazione JA 組織体系 組織体系 KO 조직 구조 조직 구조 PTB Estrutura da Organização Estrutura da Organização RU Структура организации Структура организации S Organisationsstruktur Organisationsstruktur TR Organizasyon Yapısı Organizasyon Yapısı US Organization Structure Organization Structure ZHS 组织结构 组织结构 5 30 :p_org_structure_version_id LOV Oracle PER_ORG_STRUCT_VERS_GLOBAL Y select org_structure_version_id id, to_char(version_number) value, fnd_date.date_to_displaydate(date_to,1) description from per_org_structure_versions where organization_structure_id=:$flex$.per_org_structs_global order by date_from desc Y AR النسخة النسخة E Versión Versión I Versione Versione JA バージョン バージョン KO 버전 버전 PTB Versão Versão RU Версия Версия TR Sürüm Sürüm US Version Version ZHS 版本 版本 6 40 :p_parent_organization_id LOV Oracle PER_ORG_STRUCT_ELES_GLOBAL Y select organization_id id, name value, null description from hr_organization_units where organization_id in (select p.organization_id_parent from per_org_structure_elements p where p.org_structure_version_id=:$flex$.per_org_struct_vers_global union select c.organization_id_child from per_org_structure_elements c where c.org_structure_version_id=:$flex$.per_org_struct_vers_global) order by name Y AR المنشأة الرئيسية المنشأة الرئيسية D Übergeordnete Organisation Übergeordnete Organisation E Organización Matriz Organización matriz F Organisation parent Organisation parent I Organizzazione padre Organizzazione padre JA 上位組織 上位組織 KO 상위 조직 상위 조직 PTB Organização-Pai Organização-Pai RU Головная организация Головная организация S Överordnad organisation Överordnad organisation TR Üst Organizasyon Üst Organizasyon US Parent Organization Parent Organization ZHS 上层组织 上层组织 7 50 :p_people_group_id Char AR المجموعة المجموعة D Gruppe Gruppe E Grupo Grupo F Groupe Groupe I Gruppo Gruppo JA グループ グループ KO 그룹 그룹 PTB Grupo Grupo RU Группа Группа S Grupp Grupp TR Grup Grup US Group Group ZHS 组 组 8 60 :p_job_id LOV Oracle PER_JOBS_RESTRICTED_BY_DATE_PARAM Y select j.job_id id, jt.name value, null description from per_jobs j,per_jobs_tl jt where j.business_group_id=fnd_global.per_business_group_id and j.date_from<=to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') and (j.date_to is null or (j.date_to is not null and j.date_to>=to_date(:$flex$.per_dates_standard, 'YYYY/MM/DD HH24:MI:SS') )) and jt.job_id=j.job_id and jt.language=userenv('LANG') order by value,description AR الوظيفة الوظيفة D Tätigkeit Tätigkeit E Puesto Puesto F Fonction Fonction I Mansione Mansione JA 役職 役職 KO Job Job PTB Cargo Cargo RU Должность Должность S Befattning Befattning TR İş İş US Job Job ZHS 职务 职务 9 70 :p_position_id LOV Oracle PER_POSITIONS_RESTRICTED_BY_DATE_PARAM Y select p.position_id id, pt.name value, null description from per_positions p,hr_all_positions_f_tl pt where p.business_group_id=fnd_global.per_business_group_id and p.job_id=nvl(:$flex$.per_jobs:null,job_id) and p.date_effective<= to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') and (p.date_end is null or (p.date_end is not null and p.date_end>=to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') )) and pt.position_id=p.position_id and pt.language=userenv('LANG') order by value,description AR المنصب المنصب E Posición Posición F Poste Poste I Posizione Posizione JA 職階 職階 KO Position Position PTB Posição Posição RU Штатная единица Штатная единица S Tjänst Tjänst TR Pozisyon Pozisyon US Position Position ZHS 职位 职位 10 80 :p_grade_id LOV Oracle PER_GRADES_RESTRICTED_BY_DATE_PARAM Y select g.grade_id id, gt.name value, null description from per_grades g,per_grades_tl gt where g.business_group_id=fnd_global.per_business_group_id and g.date_from<=to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') and (g.date_to is null or (g.date_to is not null and g.date_to<= to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') )) and gt.grade_id=g.grade_id and gt.language=userenv('LANG') order by g.sequence AR الدرجة الدرجة D Entgeltgruppe Entgeltgruppe E Grado Grado I Livello Livello JA 等級 等級 KO 등급 등급 PTB Grau Grau RU Разряд Сорт S Lönegrad Lönegrad TR Kademe Kademe US Grade Grade ZHS 级别 级别 11 90 :p_payroll_id LOV Oracle PAY_PAYROLLS Y select payroll_id id, payroll_name value, null description from pay_payrolls_f where business_group_id+0=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 order by value,description AR كشف الرواتب كشف الرواتب D Lohn- und Gehaltsabrechnung Lohn- und Gehaltsabrechnung E Nómina Nómina F Paie Paie I Ciclo paghe Ciclo paghe JA 給与 給与 KO 급여 급여 PTB Folha de Pagamento Folha de Pagamento RU Ведомость Ведомость S Lönegrupp Lönegrupp TR Bordro Bordro US Payroll Payroll ZHS 工资单 工资单 12 100 :p_primary_flag LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description AR أساسي أساسي D Primär Primär E Principal Principal F Principale Principal I Principale Principale JA プライマリ プライマリ KO 1차 1차 PTB Principal Principal RU Основной Основной S Primär Primär TR Birincil Birincil US Primary Primary ZHS 主要 主要 13 110 :p_person_type LOV Oracle PER_EMP_OR_APL Y select lookup_code id, meaning value, null description from fnd_common_lookups where lookup_type='EMP_OR_APL' order by meaning select meaning from fnd_common_lookups where lookup_type = 'EMP_OR_APL' and lookup_code = 'BOTH' Y AR نوع الشخص نوع الشخص D Personenart Personenart E Tipo de Persona Tipo de persona F Type de personne Type de personne I Tipo persona Tipo di persona JA Personタイプ Personタイプ KO 개인 유형 개인 유형 PTB Tipo de Pessoa Tipo de Pessoa RU Тип лица Тип лица S Persontyp Persontyp TR Kişi Tipi Kişi Tipi US Person Type Person Type ZHS 人员类型 人员类型 14 120 :p_asg_status_type_id1 LOV Oracle PER_PRIMARY_ASG_STATUS_TYPES Y select a.assignment_status_type_id id, nvl(b.user_status,a.user_status) value, null description from per_assignment_status_types_v a,per_ass_status_type_amends b,per_business_groups c where b.assignment_status_type_id(+)= a.assignment_status_type_id and b.business_group_id(+)= fnd_global.per_business_group_id and nvl(a.business_group_id ,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and nvl(a.legislation_code,c.legislation_code) =c.legislation_code and a.per_system_status in ('ACCEPTED','ACTIVE_APL','OFFER','TERM_ASSIGN', 'ACTIVE_ASSIGN','SUSP_ASSIGN') and c.business_group_id= fnd_global.per_business_group_id order by nvl(b.user_status,a.user_status) AR حالة التعيين 1 حالة التعيين 1 D Stellenzuordnungs-Status 1 Stellenzuordnungs-Status 1 E Estado de la Asignación 1 Estado de la asignación 1 F Statut affectation 1 Statut affectation 1 I Stato assegnazione 1 Stato assegnazione 1 JA アサイメント状況1 アサイメント状況1 KO 발령 상태 1 발령 상태 1 PTB Status de Atribuição 1 Status de Atribuição 1 RU Статус назначения 1 Статус назначения 1 S Status på anst.uppdrag 1 Status på anst.uppdrag 1 TR Görev Statüsü 1 Görev Statüsü 1 US Assignment Status 1 Assignment Status 1 ZHS 分配状态 1 分配状态 1 15 130 :p_asg_status_type_id2 LOV Oracle PER_PRIMARY_ASG_STATUS_TYPES Y select a.assignment_status_type_id id, nvl(b.user_status,a.user_status) value, null description from per_assignment_status_types_v a,per_ass_status_type_amends b,per_business_groups c where b.assignment_status_type_id(+)= a.assignment_status_type_id and b.business_group_id(+)= fnd_global.per_business_group_id and nvl(a.business_group_id ,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and nvl(a.legislation_code,c.legislation_code) =c.legislation_code and a.per_system_status in ('ACCEPTED','ACTIVE_APL','OFFER','TERM_ASSIGN', 'ACTIVE_ASSIGN','SUSP_ASSIGN') and c.business_group_id= fnd_global.per_business_group_id order by nvl(b.user_status,a.user_status) AR حالة التعيين 2 حالة التعيين 2 D Stellenzuordnungs-Status 2 Stellenzuordnungs-Status 2 E Estado de la Asignación 2 Estado de la asignación 2 F Statut affectation 2 Statut affectation 2 I Stato assegnazione 2 Stato assegnazione 2 JA アサイメント状況2 アサイメント状況2 KO 발령 상태 2 발령 상태 2 PTB Status de Atribuição 2 Status de Atribuição 2 RU Статус назначения 2 Статус назначения 2 S Status på anst.uppdrag 2 Status på anst.uppdrag 2 TR Görev Statüsü 2 Görev Statüsü 2 US Assignment Status 2 Assignment Status 2 ZHS 分配状态 2 分配状态 2 16 140 :p_asg_status_type_id3 LOV Oracle PER_PRIMARY_ASG_STATUS_TYPES Y select a.assignment_status_type_id id, nvl(b.user_status,a.user_status) value, null description from per_assignment_status_types_v a,per_ass_status_type_amends b,per_business_groups c where b.assignment_status_type_id(+)= a.assignment_status_type_id and b.business_group_id(+)= fnd_global.per_business_group_id and nvl(a.business_group_id ,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and nvl(a.legislation_code,c.legislation_code) =c.legislation_code and a.per_system_status in ('ACCEPTED','ACTIVE_APL','OFFER','TERM_ASSIGN', 'ACTIVE_ASSIGN','SUSP_ASSIGN') and c.business_group_id= fnd_global.per_business_group_id order by nvl(b.user_status,a.user_status) AR حالة التعيين 3 حالة التعيين 3 D Stellenzuordnungs-Status 3 Stellenzuordnungs-Status 3 E Estado de la Asignación 3 Estado de la asignación 3 F Statut affectation 3 Statut affectation 3 I Stato assegnazione 3 Stato assegnazione 3 JA アサイメント状況3 アサイメント状況3 KO 발령 상태 3 발령 상태 3 PTB Status de Atribuição 3 Status de Atribuição 3 RU Статус назначения 3 Статус назначения 3 S Status på anst.uppdrag 3 Status på anst.uppdrag 3 TR Görev Statüsü 3 Görev Statüsü 3 US Assignment Status 3 Assignment Status 3 ZHS 分配状态 3 分配状态 3 17 150 :p_asg_status_type_id4 LOV Oracle PER_PRIMARY_ASG_STATUS_TYPES Y select a.assignment_status_type_id id, nvl(b.user_status,a.user_status) value, null description from per_assignment_status_types_v a,per_ass_status_type_amends b,per_business_groups c where b.assignment_status_type_id(+)= a.assignment_status_type_id and b.business_group_id(+)= fnd_global.per_business_group_id and nvl(a.business_group_id ,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and nvl(a.legislation_code,c.legislation_code) =c.legislation_code and a.per_system_status in ('ACCEPTED','ACTIVE_APL','OFFER','TERM_ASSIGN', 'ACTIVE_ASSIGN','SUSP_ASSIGN') and c.business_group_id= fnd_global.per_business_group_id order by nvl(b.user_status,a.user_status) AR حالة التعيين 4 حالة التعيين 4 D Stellenzuordnungs-Status 4 Stellenzuordnungs-Status 4 E Estado de la Asignación 4 Estado de la asignación 4 F Statut affectation 4 Statut affectation 4 I Stato assegnazione 4 Stato assegnazione 4 JA アサイメント状況4 アサイメント状況4 KO 발령 상태 4 발령 상태 4 PTB Status de Atribuição 4 Status de Atribuição 4 RU Статус назначения 4 Статус назначения 4 S Status på anst.uppdrag 4 Status på anst.uppdrag 4 TR Görev Statüsü 4 Görev Statüsü 4 US Assignment Status 4 Assignment Status 4 ZHS 分配状态 4 分配状态 4