ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4719B51A9E05362FB09050512Y select o.name organization , nvl(s.user_status,t.user_status) status , a.effective_start_date date_from , a.effective_end_date date_to , a.assignment_id , a.person_id, PER_PERRPRMS_XMLP_PKG.c_date_toformula(a.effective_end_date) C_DATE_TO --from --, a.effective_end_date date_to --, a.assignment_id --, a.person_id from per_assignments_f a , hr_all_organization_units o , per_assignment_status_types t , per_ass_status_type_amends s where :P_SESSION_DATE between a.effective_start_date and a.effective_end_date and a.organization_id = o.organization_id and a.assignment_status_type_id = t.assignment_status_type_id and s.assignment_status_type_id(+) = t.assignment_status_type_id and s.business_group_id(+) = :P_BUSINESS_GROUP_ID and nvl(t.business_group_id,:P_BUSINESS_GROUP_ID) = :P_BUSINESS_GROUP_ID and nvl(t.legislation_code,:P_LEGISLATION_CODE) = :P_LEGISLATION_CODE and nvl(s.active_flag,t.active_flag) = 'Y' and nvl(s.default_flag,t.default_flag) = 'Y' and a.person_id=:person_id1 PER PERRPRMS_XML AR PER تقرير مطابقة مهارات الوظائف والمناصب (بتنسيق XML) Imported from BI Publisher Description: تقرير مطابقة مهارات الوظائف والمناصب Application: الموارد البشرية Source: تقرير مطابقة مهارات الوظائف والمناصب (بتنسيق XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG D PER Vergleich Tätigkeiten/Qualifikationen Imported from BI Publisher Description: Auswertung "Vergleich Tätigkeiten/Qualifikationen" Application: Human Resources Source: Vergleich Tätigkeiten/Qualifikationen (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG E PER Ajuste de Aptitudes a Puestos y Posiciones Imported from BI Publisher Description: Informe de ajuste de aptitudes a puestos y posiciones Application: Human Resources Source: Ajuste de Aptitudes a Puestos y Posiciones (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG F PER Etat de rapprochement des compétences (postes et fonctions) Imported from BI Publisher Description: Etat de rapprochement des compétences (postes et fonctions) Application: Human Resources Source: Etat de rapprochement des compétences (postes et fonctions) (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG I PER Rapporto Corrispondenza mansioni e skill Imported from BI Publisher Description: Rapporto Corrispondenza mansioni e skill Application: Human Resources Source: Rapporto Corrispondenza mansioni e skill (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG JA PER 役職と職階のスキル照合レポート Imported from BI Publisher Description: 役職と職階のスキル照合レポート Application: Human Resources Source: 役職と職階のスキル照合レポート(XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG KO PER Job 및 Position 스킬 대응 보고서 Imported from BI Publisher Description: Job 및 Position 스킬 대응 보고서 Application: HR Source: Job 및 Position 스킬 대응 보고서(XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG PTB PER Relatório de Vinculação de Habilidades de Posição e Cargo Imported from BI Publisher Description: Relatório de Vinculação de Habilidades de Posição e Cargo Application: Human Resources Source: Relatório de Vinculação de Habilidades de Posição e Cargo (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG RU PER Отчет о сопоставлении навыков для должности и штатной единицы Imported from BI Publisher Description: Отчет о сопоставлении навыков для специальности и должности Application: Персонал Source: Отчет о сопоставлении навыков для должности и штатной единицы (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG S PER Matchning av färdigheter för befattning och tjänst - rapport Imported from BI Publisher Description: Matchning av färdigheter för befattning och tjänst - rapport Application: Human Resources Source: Matchning av färdigheter för befattning och tjänst - rapport (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG TR PER İş ve Pozisyon Yetenekleri Eşleme Raporu Imported from BI Publisher Description: İş ve Pozisyon Yetenekleri Eşleme Raporu Application: İnsan Kaynakları Source: İş ve Pozisyon Yetenekleri Eşleme Raporu (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG US PER Job and Position Skills Matching Imported from BI Publisher Description: Job and Position Skills Matching Report Application: Human Resources Source: Job and Position Skills Matching Report (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG ZHS PER 职务和职位技能匹配报表 Imported from BI Publisher Description: 职务和职位技能匹配报表 Application: 人力资源管理系统 Source: 职务和职位技能匹配报表 (XML) Short Name: PERRPRMS_XML DB package: PER_PERRPRMS_XMLP_PKG BI Publisher :c_business_group_name :c_end_of_time :c_job_position_id :c_job_position_name :c_person_type_desc :c_report_subtitle :c_req_val :c_requirement_desc :c_requirement_value :p_business_group_id :p_conc_request_id :p_job_id :p_job_position :p_legislation_code :p_matching_level :p_person_type :p_position_id :p_session_date :p_session_date1 :p_special_info_segs :person_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 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_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 职务 职务 4 30 :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 职位 职位 5 40 :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 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 人员类型 人员类型 6 50 :p_matching_level LOV Oracle PER_SKILLS_MATCHING_VALUES Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=101774 order by ffvv.flex_value S Y AR مستوى المطابقة المطلوب مستوى المطابقة D Erforderlicher Grad der Übereinstimmung Grad der Übereinstimmung E Nivel Necesario de Ajuste Nivel de coincidencia F Niveau d'adéquation requis Niveau de rapprochement I Livello di corrispondenza richiesto Livello di corrispondenza JA 照合に必須なレベル 照合レベル KO 연결 요구 레벨 대응 수준 PTB Nível de Vinculação Necessário Nível de Vinculação RU Требуемый уровень сопоставления Уровень сопоставления S Matchningsnivå måste anges Matchningsnivå TR İstenilen Eşleşme Düzeyi Eşleşme Düzeyi US Required Level of Matching Matching Level ZHS 要求的匹配层 匹配层