ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719A51A9E05362FB09050512 SELECT DISTINCT a.ORGANIZATION_ID, -- nvl(a.PEOPLE_GROUP_ID,-999), nvl(a.PEOPLE_GROUP_ID,-999) NVL_A_PEOPLE_GROUP_ID_999, -- nvl(a.JOB_ID,-999), nvl(a.JOB_ID,-999) NVL_A_JOB_ID_999, -- nvl(a.POSITION_ID,-999), nvl(a.POSITION_ID,-999) NVL_A_POSITION_ID_999, -- nvl(a.GRADE_ID,-999), nvl(a.GRADE_ID,-999) NVL_A_GRADE_ID_999, -- nvl(a.LOCATION_ID,-999), nvl(a.LOCATION_ID,-999) NVL_A_LOCATION_ID_999, -- nvl(a.VACANCY_ID,-999), nvl(a.VACANCY_ID,-999) NVL_A_VACANCY_ID_999, -- nvl(a.RECRUITMENT_ACTIVITY_ID,-999), nvl(a.RECRUITMENT_ACTIVITY_ID,-999) NVL_A_RECRUITMENT_ACTIVITY_ID1, -- nvl(a.RECRUITER_ID,-999), nvl(a.RECRUITER_ID,-999) NVL_A_RECRUITER_ID_999, o.NAME ORG_NAME, pg.GROUP_NAME PEOPLE_GROUP, jbt.NAME JOB_NAME, hr_general.decode_position_latest_name(a.position_id) POSITION_NAME, gdt.NAME GRADE_NAME, ltl.LOCATION_CODE LOCATION, v.NAME VACANCY_NAME, v.NUMBER_OF_OPENINGS PLACES, lu.MEANING VACANCY_STATUS, (select FULL_NAME from per_all_people_f where person_id = a.recruiter_id and SSPP.EFFECTIVE_DATE between effective_start_date and effective_end_date) RECRUITER, pr.NAME REQUISITION_NAME, pr.DATE_FROM, pr.DATE_TO, (select FULL_NAME from per_all_people_f where person_id = pr.PERSON_ID and SSPP.EFFECTIVE_DATE between effective_start_date and effective_end_date) RAISED_BY, ra.NAME RECRUITMENT_ACTIVITY /* Commented during DT Fixes from per_all_people_f where person_id = a.recruiter_id and SSPP.EFFECTIVE_DATE between effective_start_date and effective_end_date) RECRUITER, pr.NAME REQUISITION_NAME, pr.DATE_FROM, pr.DATE_TO, (select FULL_NAME from per_all_people_f where person_id = pr.PERSON_ID and SSPP.EFFECTIVE_DATE between effective_start_date and effective_end_date) RAISED_BY, ra.NAME RECRUITMENT_ACTIVITY */ FROM PER_ASSIGNMENTS_F a, HR_ORGANIZATION_UNITS o, PAY_PEOPLE_GROUPS pg, PER_JOBS_TL jbt, PER_GRADES_TL gdt, HR_LOCATIONS_ALL_TL ltl, PER_VACANCIES v, HR_LOOKUPS lu, PER_REQUISITIONS pr, PER_RECRUITMENT_ACTIVITIES ra, FND_SESSIONS SSPP WHERE a.ORGANIZATION_ID = o.ORGANIZATION_ID AND a.PEOPLE_GROUP_ID = pg.PEOPLE_GROUP_ID(+) AND a.JOB_ID = jbt.JOB_ID(+) AND jbt.language(+) = userenv('LANG') AND a.GRADE_ID = gdt.GRADE_ID(+) AND gdt.language(+) = userenv('LANG') AND a.LOCATION_ID = ltl.LOCATION_ID(+) AND a.VACANCY_ID = v.VACANCY_ID(+) AND v.STATUS = lu.LOOKUP_CODE(+) AND lu.LOOKUP_TYPE(+) = 'VACANCY_STATUS' AND a.RECRUITMENT_ACTIVITY_ID = ra.RECRUITMENT_ACTIVITY_ID(+) AND (:SESSION_DATE) between a.effective_start_date AND a.effective_end_date AND a.assignment_type = 'A' AND nvl(pr.DATE_FROM,nvl(:P_REQ_START_DATE,to_date('19000101','YYYYMMDD'))) between nvl(:P_REQ_START_DATE,to_date('19000101','YYYYMMDD')) and nvl(:P_REQ_END_DATE,to_date('47121231','YYYYMMDD')) AND nvl(pr.DATE_TO,nvl(:P_REQ_END_DATE,to_date('47121231','YYYYMMDD'))) between nvl(:P_REQ_START_DATE,to_date('19000101','YYYYMMDD')) and nvl(:P_REQ_END_DATE,to_date('47121231','YYYYMMDD')) AND a.business_group_id = :p_business_group_id AND v.REQUISITION_ID = pr.REQUISITION_ID AND a.ORGANIZATION_ID in (select organization_id from hr_all_organization_units where organization_id = nvl(:P_ORGANIZATION_ID,organization_id)) AND (:P_PEOPLE_GROUP is null or :P_PEOPLE_GROUP = pg.GROUP_NAME) AND (:P_JOB_ID is null or :P_JOB_ID = a.JOB_ID) AND (:P_POSITION_ID is null or :P_POSITION_ID = a.POSITION_ID) AND (:P_GRADE_ID is null or :P_GRADE_ID = a.GRADE_ID) AND (:P_LOCATION_ID is null or :P_LOCATION_ID = a.LOCATION_ID) AND (:P_RECRUITMENT_ACTIVITY_ID is null or :P_RECRUITMENT_ACTIVITY_ID = a.RECRUITMENT_ACTIVITY_ID) AND (:P_REQUISITION_ID is null or :P_REQUISITION_ID = pr.REQUISITION_ID) AND (:P_VACANCY_STATUS is null or :P_VACANCY_STATUS = v.STATUS) AND ltl.LANGUAGE (+) = userenv('LANG') AND SSPP.SESSION_ID=USERENV('sessionid') ORDER BY pr.NAME, v.NAME, o.NAME, jbt.NAME, pg.GROUP_NAME, gdt.NAME, ltl.LOCATION_CODE Y PER PERRPREQ_XML AR PER تقرير إجمالي الطلبات (بتنسيق XML) Imported from BI Publisher Description: تقرير إجمالي الطلبات Application: الموارد البشرية Source: تقرير إجمالي الطلبات (بتنسيق XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG D PER Anforderungen - Übersicht Imported from BI Publisher Description: Auswertung "Anforderungen - Übersicht" Application: Human Resources Source: Anforderungen - Übersicht (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG E PER Resumen de Solicitud Imported from BI Publisher Description: Informe de resumen de solicitud Application: Human Resources Source: Resumen de Solicitud (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG F PER Synthèse des demandes d'embauche Imported from BI Publisher Description: Synthèse des demandes d'embauche Application: Human Resources Source: Synthèse des demandes d'embauche (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG I PER Rapporto Sintetico richieste Imported from BI Publisher Description: Rapporto Sintetico richieste Application: Human Resources Source: Rapporto Sintetico richieste (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG JA PER 必要要件要約レポート Imported from BI Publisher Description: 必要要件要約レポート Application: Human Resources Source: 必要要件要約レポート(XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG KO PER 충원요청 요약 보고서 Imported from BI Publisher Description: 충원요청 요약 보고서 Application: HR Source: 충원요청 요약 보고서(XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG PTB PER Relatório Resumido da Requisição Imported from BI Publisher Description: Relatório Resumido da Requisição Application: Human Resources Source: Relatório Resumido da Requisição (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG RU PER Сводный отчет по заявкам Imported from BI Publisher Description: Сводный отчет по заявкам Application: Персонал Source: Сводный отчет по заявкам (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG S PER Rekvisitionsöversikt - rapport Imported from BI Publisher Description: Rekvisitionsöversikt - rapport Application: Human Resources Source: Rekvisitionsöversikt - rapport (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG TR PER Talep Özet Raporu Imported from BI Publisher Description: Talep Özet Raporu Application: İnsan Kaynakları Source: Talep Özet Raporu (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG US PER Requisition Summary Imported from BI Publisher Description: Requisition Summary Report Application: Human Resources Source: Requisition Summary Report (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG ZHS PER 申请汇总报表 Imported from BI Publisher Description: 申请汇总报表 Application: 人力资源管理系统 Source: 申请汇总报表 (XML) Short Name: PERRPREQ_XML DB package: PER_PERRPREQ_XMLP_PKG BI Publisher :c_business_group :p_applicant_status_id :p_business_group_id :p_conc_request_id :p_grade_id :p_group_flex_num :p_job_id :p_location_id :p_organization_id :p_people_group :p_position_id :p_recruitment_activity_id :p_req_end_date :p_req_start_date :p_requisition_id :p_vacancy_status :session_date 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_group_flex_num Number select people_group_structure from per_business_groups where business_group_id = fnd_global.PER_BUSINESS_GROUP_ID Y AR معرف الهيكل المرن الأساسي للمجموعة D Kennung Schlüssel-FlexFeld-Struktur Gruppe E Id Tipo de Estructura Clave de Grupo F ID structure de la clé flexible Groupe I Id struttura flexfield chiave gruppo JA グループ・キー・フレックスフィールド体系ID KO 그룹 키가변필드 구조 ID PTB Id da Estrutura de Flexfield Chave do Grupo RU Код структуры ключ. гибкого поля группы S Nyckelfältsstruktur-id för grupp TR Grup Anahtar Esnek Yapı No US Group KeyFlex Structure Id ZHS 组键弹性域结构标识 3 10 :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 有效日期 有效日期 4 20 :p_req_start_date Date AR تاريخ البداية تاريخ البداية D Startdatum Startdatum E Fecha de Inicio Fecha de Inicio F Date de début Date de début I Data inizio Data avvio JA 開始日 開始日 KO 시작 일자 시작 일자 PTB Data Inicial Data Inicial RU Начальная дата Начальная дата S Startdatum Startdatum TR Başlangıç Tarihi Başlangıç Tarihi US Start Date Start Date ZHS 起始日期 起始日期 5 30 :p_req_end_date Date AR تاريخ النهاية تاريخ النهاية D Enddatum Enddatum E Fecha de Finalización Fecha de finalización F Date de fin Date de fin I Data fine Data fine JA 終了日 終了日 KO 종료 일자 종료 일자 PTB Data Final Data Final RU Конечная дата Конечная дата S Slutdatum Slutdatum TR Bitiş Tarihi Bitiş Tarihi US End Date End Date ZHS 终止日期 终止日期 6 40 :p_requisition_id LOV Oracle HR_SRS_REQUISITIONS Y select requisition_id id, name value, null description from per_requisitions where business_group_id=fnd_global.per_business_group_id order by name AR الطلب اسم الطلب D Anforderung Anforderungsbezeichnung E Solicitud Nombre de solicitud F Demande de personnel Nom de la demande de personnel I Richiesta Nome della richiesta JA 必要要件 必要要件名 KO 충원요청 충원요청명 PTB Requisição Nome da Requisição RU Заявка Имя заявки S Rekvisition Rekvisitionsnamn TR Talep Talep Adı US Requisition Requisition Name ZHS 申请 申请名称 7 50 :p_vacancy_status LOV Oracle HR_SRS_VACANCY_STATUSES Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='VACANCY_STATUS' and application_id=800 order by value,description AR حالة الوظيفة الشاغرة حالة الوظيفة الشاغرة D Status offene Stelle Status offene Stelle E Estado de Vacante Estado de vacante F Statut du poste vacant Statut du poste vacant I Stato posto vacante Stato posto vacante JA 必要要員ステータス 必要要員ステータス KO 공석 상태 공석 상태 PTB Status da Vaga Status da Vaga RU Статус вакансии Статус вакансии S Vakansstatus Vakansstatus TR Boş Kadro Statüsü Boş Kadro Statüsü US Vacancy Status Vacancy Status ZHS 空缺状态 空缺状态 8 60 :p_organization_id LOV Oracle PER_ORGANIZATION_UNITS Y select organization_id id, o.name value, null description from per_organization_units o,fnd_sessions s where business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID') and session_id=userenv('sessionid') and s.effective_date between o.date_from and nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY')) order by value,description AR المنشأة المنشأة D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 9 70 :p_job_id LOV Oracle PER_JOBS Y select j.job_id id, jt.name value, null description from per_jobs j,per_jobs_tl jt,fnd_sessions s where j.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID') and s.session_id=userenv('sessionid') and s.effective_date between j.date_from and nvl(j.date_to,to_date('31/12/4712','DD/MM/YYYY')) and jt.job_id=j.job_id and jt.language=userenv('LANG') order by value,description AR الوظيفة المسمى الوظيفي D Tätigkeit Tätigkeit E Puesto Nombre del puesto F Fonction Fonction I Mansione Titolo della mansione JA 役職 役職タイトル KO Job Job Title PTB Cargo Título do Cargo RU Должность Должность S Befattning Befattning TR İş İş Ünvanı US Job Job Title ZHS 职务 职称 10 80 :p_people_group_id Char AR مجموعة الأشخاص مقطع مجموعة الأشخاص D Personengruppe Segment Personengruppe E Grupo de Personas Segmento de grupo de personas F Groupe de personnes Segment groupe de personnes I Gruppo persone Segmento del gruppo di persone JA Peopleグループ Peopleグループ・セグメント KO 사원 그룹 사원 그룹 세그먼트 PTB Grupo de Pessoas Segmento do Grupo de Pessoas RU Группа лиц Сегмент группы сотрудников S Personalgrupp Personalgruppssegment TR Kişi Grubu Kişi Grubu Segmenti US People Group People Group Segment ZHS 人员组 人员组段 11 90 :p_position_id LOV Oracle HR_SRS_POSITIONS Y select p.position_id id, pt.name value, null description from per_positions p,hr_all_positions_f_tl pt,fnd_sessions s where p.business_group_id=fnd_global.per_business_group_id and p.job_id=nvl(:$flex$.per_jobs_restricted_by_date_param:null,p.job_id) and p.organization_id= nvl(:$flex$.per_org_units_restricted_by_date_param:null, p.organization_id) and s.session_id=userenv('sessionid') and s.effective_date between p.date_effective and nvl(p.date_end,to_date('31/12/4712','DD/MM/YYYY')) and pt.position_id=p.position_id and pt.language=userenv('LANG') order by value,description AR المنصب المسمى الوظيفي للمنصب D Position Position E Posición Título de la posición F Poste Libellé du poste I Posizione Titolo della posizione JA 職階 職階タイトル KO Position Position명 PTB Posição Título da Posição RU Штатная единица Название штатной единицы S Tjänst Tjänstetitel TR Pozisyon Pozisyon Ünvanı US Position Position Title ZHS 职位 职位名称 12 100 :p_grade_id LOV Oracle PER_GRADES Y select g.grade_id id, gt.name value, null description from per_grades g,per_grades_tl gt,fnd_sessions s where g.business_group_id=fnd_global.per_business_group_id and s.session_id=userenv('sessionid') and s.effective_date between g.date_from and nvl(g.date_to,to_date('31/12/4712','DD/MM/YYYY')) and gt.grade_id=g.grade_id and gt.language=userenv('LANG') order by value,description AR الدرجة اسم الدرجة D Entgeltgruppe Bezeichnung Entgeltgruppe E Grado Nombre de grado F Grade Nom du grade I Livello Nome del livello JA 等級 等級名 KO 등급 등급명 PTB Grau Nome da Grade RU Разряд Имя разряда S Lönegrad Lönegradsnamn TR Kademe Kademe Adı US Grade Grade Name ZHS 级别 级别名称 13 110 :p_location_id LOV Oracle HR_SRS_LOCATIONS Y select location_id id, location_code value, description description from hr_locations order by location_code AR الموقع الموقع D Standort Standort E Ubicación Ubicación F Lieu Lieu I Ubicazione Ubicazione JA 事業所 事業所 KO 위치 위치 PTB Local Local RU Расположение Расположение S Placering Placering TR Yerleşim Yerleşim US Location Location ZHS 地点 地点 14 120 :p_recruitment_activity_id LOV Oracle HR_SRS_RECRUITMENT_ACTIVITIES Y select r.recruitment_activity_id id, r.name value, null description from per_recruitment_activities r,fnd_sessions s where r.business_group_id=fnd_global.per_business_group_id and s.session_id=userenv('sessionid') and s.effective_date between r.date_start and nvl(r.date_end,to_date('31/12/4712','DD/MM/YYYY')) order by r.name AR نشاط التوظيف نشاط التوظيف D Einstellungsaktivität Einstellungsaktivität E Actividad de Reclutamiento Actividad de reclutamiento F Activité de recrutement Activité de recrutement I Attività di selezione Attività di selezione JA 採用活動 採用活動 KO 채용 활동 채용 활동 PTB Atividade de Recrutamento Atividade de Recrutamento RU Мероприятие по набору персонала Мероприятие по набору персонала S Rekryteringsaktivitet Rekryteringsaktivitet TR İşe Alma Aktivitesi İşe Alma Aktivitesi US Recruitment Activity Recruitment Activity ZHS 招聘活动 招聘活动 15 130 :p_applicant_status_id LOV Oracle HR_SRS_APPLICANT_STATUS Y select a.assignment_status_type_id id, a.user_status value, null description from per_assignment_status_types a where nvl(a.business_group_id,fnd_global.per_business_group_id) =fnd_global.per_business_group_id and nvl(a.default_flag,a.default_flag)='Y' and nvl(a.per_system_status,a.per_system_status) in ('ACTIVE_APL','OFFER','ACCEPTED') order by value,description AR حالة طالب التوظف حالة طالب الوظيفة D Bewerberstatus Bewerberstatus E Estado de Solicitante Estado de solicitante F Statut du candidat Statut du candidat I Stato candidato Stato del candidato JA 応募者ステータス 応募者ステータス KO 신청자 상태 지원자 상태 PTB Status do Candidato Status do Candidato RU Статус претендента Статус претендента S Sökandestatus Sökandestatus TR Aday Statüsü Aday Statüsü US Applicant Status Applicant Status ZHS 申请人状态 申请人状态