ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4718151A9E05362FB09050512 select pose.org_structure_version_id ,pose.org_structure_element_id ,rpad(substr((HR_PERSON_FLEX_LOGIC.GetOrgAliasName(pose.organization_id_child,sysdate)),1,60),60,' ') name ,hr_head_count.get_rev_start_val(pose.org_structure_element_id) rev_start_val ,hr_head_count.get_nonrev_start_val(pose.org_structure_element_id) nonrev_start_val ,hr_head_count.get_rev_end_val(pose.org_structure_element_id) rev_end_val ,hr_head_count.get_nonrev_end_val(pose.org_structure_element_id) nonrev_end_val ,hr_head_count.get_rev_perm(pose.org_structure_element_id) rev_perm ,hr_head_count.get_nonrev_perm(pose.org_structure_element_id) nonrev_perm ,hr_head_count.get_rev_cont(pose.org_structure_element_id) rev_cont ,hr_head_count.get_nonrev_cont(pose.org_structure_element_id) nonrev_cont ,hr_head_count.get_rev_temp(pose.org_structure_element_id) rev_temp ,hr_head_count.get_nonrev_temp(pose.org_structure_element_id) nonrev_temp ,hr_head_count.get_rev_cur_nh(pose.org_structure_element_id) rev_cur_nh ,hr_head_count.get_nonrev_cur_nh(pose.org_structure_element_id) nonrev_cur_nh ,hr_head_count.get_rev_nh(pose.org_structure_element_id) rev_nh ,hr_head_count.get_nonrev_nh(pose.org_structure_element_id) nonrev_nh ,hr_head_count.get_rev_transfer_in(pose.org_structure_element_id) rev_transfer_in ,hr_head_count.get_nonrev_transfer_in(pose.org_structure_element_id) nonrev_transfer_in ,hr_head_count.get_rev_transfer_out(pose.org_structure_element_id) rev_transfer_out ,hr_head_count.get_nonrev_transfer_out(pose.org_structure_element_id) nonrev_transfer_out ,hr_head_count.get_rev_open_offers(pose.org_structure_element_id) rev_open_offers ,hr_head_count.get_nonrev_open_offers(pose.org_structure_element_id) nonrev_open_offers ,hr_head_count.get_rev_accepted_offers(pose.org_structure_element_id) rev_accepted_offers ,hr_head_count.get_nonrev_accepted_offers(pose.org_structure_element_id) nonrev_accepted_offers ,hr_head_count.get_rev_vacant_FTE(pose.org_structure_element_id) rev_vacant_FTE ,hr_head_count.get_nonrev_vacant_FTE(pose.org_structure_element_id) nonrev_vacant_FTE ,hr_head_count.get_rev_vol_term(pose.org_structure_element_id) rev_vol_term ,hr_head_count.get_nonrev_vol_term(pose.org_structure_element_id) nonrev_vol_term ,hr_head_count.get_rev_invol_term(pose.org_structure_element_id) rev_invol_term ,hr_head_count.get_nonrev_invol_term(pose.org_structure_element_id) nonrev_invol_term ,hr_head_count.get_rev_cur_term(pose.org_structure_element_id) rev_cur_term ,hr_head_count.get_nonrev_cur_term(pose.org_structure_element_id) nonrev_cur_term ,hr_head_count.get_rev_change(pose.org_structure_element_id) rev_change ,hr_head_count.get_nonrev_change(pose.org_structure_element_id) nonrev_change ,hr_head_count.get_rev_pct_change(pose.org_structure_element_id) rev_pct_change ,hr_head_count.get_nonrev_pct_change(pose.org_structure_element_id) nonrev_pct_change ,posv1.version_number ,greatest(posv1.date_from,:P_REPORT_DATE_FROM) date_from ,least(nvl(posv1.date_to,to_date('31/12/4712','DD/MM/YYYY')),:P_REPORT_DATE_TO) date_to, PER_PERHDCNT_XMLP_PKG.cf_days_betweenformula(least ( nvl ( posv1.date_to , to_date ( '31/12/4712' , 'DD/MM/YYYY' ) ) , :P_REPORT_DATE_TO ), greatest ( posv1.date_from , :P_REPORT_DATE_FROM )) CF_DAYS_BETWEEN /*, PER_PERHDCNT_XMLP_PKG.cf_rev_vol_termformula(:CS_rev_vol_term, :Sumrev_start_valPerorg_structu) CF_rev_vol_term, PER_PERHDCNT_XMLP_PKG.cf_rev_invol_termformula(:CS_nonrev_invol_term, :Sumnonrev_start_valPerorg_stru) CF_nonrev_invol_term, PER_PERHDCNT_XMLP_PKG.cf_nonrev_vol_termformula(:CS_nonrev_vol_term, :Sumnonrev_start_valPerorg_stru) CF_nonrev_vol_term, PER_PERHDCNT_XMLP_PKG.cf_nonrev_cur_termformula(:CS_nonrev_cur_term, :Sumnonrev_start_valPerorg_stru) CF_nonrev_cur_term, PER_PERHDCNT_XMLP_PKG.cf_rev_cur_termformula(:CS_rev_cur_term, :Sumrev_start_valPerorg_structu) CF_rev_cur_term, PER_PERHDCNT_XMLP_PKG.cf_rev_invol_termformula0017(:CS_rev_invol_term, :Sumrev_start_valPerorg_structu) CF_rev_invol_term, PER_PERHDCNT_XMLP_PKG.cf_rev_pct_changeformula(:Sumrev_start_valPerorg_structu, :Sumrev_end_valPerorg_structure) CF_rev_pct_change, PER_PERHDCNT_XMLP_PKG.cf_nonrev_pct_changeformula(:Sumnonrev_start_valPerorg_stru, :Sumnonrev_end_valPerorg_struct) CF_nonrev_pct_change*/ from per_org_structure_elements pose ,per_org_structure_versions posv1 where pose.organization_id_parent = :P_TOP_ORGANIZATION_ID and pose.org_structure_version_id = posv1.org_structure_version_id and pose.org_structure_version_id in ( select posv.org_structure_version_id from per_org_structure_versions posv where posv.organization_structure_id = :P_ORGANIZATION_STRUCTURE_ID and (:P_REPORT_DATE_FROM between posv.date_from and nvl(posv.date_to, :P_REPORT_DATE_TO) or posv.date_from between :P_REPORT_DATE_FROM and :P_REPORT_DATE_TO)) UNION select distinct posv.org_structure_version_id ,1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID) org_structure_element_id ,rpad(substr((HR_PERSON_FLEX_LOGIC.GetOrgAliasName(:P_TOP_ORGANIZATION_ID,sysdate)),1,60),60,' ') name ,hr_head_count.get_rev_start_val(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_start_val ,hr_head_count.get_nonrev_start_val(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_start_val ,hr_head_count.get_rev_end_val(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_end_val ,hr_head_count.get_nonrev_end_val(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_end_val ,hr_head_count.get_rev_perm(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_perm ,hr_head_count.get_nonrev_perm(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_perm ,hr_head_count.get_rev_cont(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_cont ,hr_head_count.get_nonrev_cont(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_cont ,hr_head_count.get_rev_temp(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_temp ,hr_head_count.get_nonrev_temp(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_temp ,hr_head_count.get_rev_cur_nh(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_cur_nh ,hr_head_count.get_nonrev_cur_nh(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_cur_nh ,hr_head_count.get_rev_nh(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_nh ,hr_head_count.get_nonrev_nh(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_nh ,hr_head_count.get_rev_transfer_in(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_transfer_in ,hr_head_count.get_nonrev_transfer_in(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_transfer_in ,hr_head_count.get_rev_transfer_out(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_transfer_out ,hr_head_count.get_nonrev_transfer_out(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_transfer_out ,hr_head_count.get_rev_open_offers(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_open_offers ,hr_head_count.get_nonrev_open_offers(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_open_offers ,hr_head_count.get_rev_accepted_offers(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_accepted_offers ,hr_head_count.get_nonrev_accepted_offers(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_accepted_offers ,hr_head_count.get_rev_vacant_FTE(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_vacant_FTE ,hr_head_count.get_nonrev_vacant_FTE(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_vacant_FTE ,hr_head_count.get_rev_vol_term(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_vol_term ,hr_head_count.get_nonrev_vol_term(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_vol_term ,hr_head_count.get_rev_invol_term(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_invol_term ,hr_head_count.get_nonrev_invol_term(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_invol_term ,hr_head_count.get_rev_cur_term(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_cur_term ,hr_head_count.get_nonrev_cur_term(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_cur_term ,hr_head_count.get_rev_change(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_change ,hr_head_count.get_nonrev_change(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_change ,hr_head_count.get_rev_pct_change(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) rev_pct_change ,hr_head_count.get_nonrev_pct_change(1-(posv.org_structure_version_id+:P_TOP_ORGANIZATION_ID)) nonrev_pct_change ,posv.version_number ,greatest(posv.date_from,:P_REPORT_DATE_FROM) date_from ,least(nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY')),:P_REPORT_DATE_TO) date_to, PER_PERHDCNT_XMLP_PKG.cf_days_betweenformula(least ( nvl ( posv.date_to , to_date ( '31/12/4712' , 'DD/MM/YYYY' ) ) , :P_REPORT_DATE_TO ), greatest ( posv.date_from , :P_REPORT_DATE_FROM )) CF_DAYS_BETWEEN /*, PER_PERHDCNT_XMLP_PKG.cf_rev_vol_termformula(:CS_rev_vol_term, :Sumrev_start_valPerorg_structu) CF_rev_vol_term, PER_PERHDCNT_XMLP_PKG.cf_rev_invol_termformula(:CS_nonrev_invol_term, :Sumnonrev_start_valPerorg_stru) CF_nonrev_invol_term, PER_PERHDCNT_XMLP_PKG.cf_nonrev_vol_termformula(:CS_nonrev_vol_term, :Sumnonrev_start_valPerorg_stru) CF_nonrev_vol_term, PER_PERHDCNT_XMLP_PKG.cf_nonrev_cur_termformula(:CS_nonrev_cur_term, :Sumnonrev_start_valPerorg_stru) CF_nonrev_cur_term, PER_PERHDCNT_XMLP_PKG.cf_rev_cur_termformula(:CS_rev_cur_term, :Sumrev_start_valPerorg_structu) CF_rev_cur_term, PER_PERHDCNT_XMLP_PKG.cf_rev_invol_termformula0017(:CS_rev_invol_term, :Sumrev_start_valPerorg_structu) CF_rev_invol_term, PER_PERHDCNT_XMLP_PKG.cf_rev_pct_changeformula(:Sumrev_start_valPerorg_structu, :Sumrev_end_valPerorg_structure) CF_rev_pct_change, PER_PERHDCNT_XMLP_PKG.cf_nonrev_pct_changeformula(:Sumnonrev_start_valPerorg_stru, :Sumnonrev_end_valPerorg_struct) CF_nonrev_pct_change*/ from per_org_structure_versions posv where posv.organization_structure_id = :P_ORGANIZATION_STRUCTURE_ID and (:P_REPORT_DATE_FROM between posv.date_from and nvl(posv.date_to, :P_REPORT_DATE_TO) or posv.date_from between :P_REPORT_DATE_FROM and :P_REPORT_DATE_TO) and :P_INCLUDE_TOP_ORG = 'Y' order by 1,3 --/ Y PER PERHDCNT_XML AR PER تقرير تفاصيل عدد الموظفين (بتنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل عدد الموظفين Application: الموارد البشرية Source: تقرير تفاصيل عدد الموظفين (بتنسيق XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG D PER Mitarbeiteranzahl - Details Imported from BI Publisher Description: Auswertung "Mitarbeiteranzahl - Details" Application: Human Resources Source: Mitarbeiteranzahl - Details (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG E PER Detalles de Plantilla Imported from BI Publisher Description: Informe de detalles de plantilla Application: Human Resources Source: Detalles de Plantilla (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG F PER Etat Détails des effectifs(1) Imported from BI Publisher Application: Human Resources Source: Etat Détails des effectifs(1) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG I PER Rapporto Dettagli numero di risorse Imported from BI Publisher Description: Rapporto Dettagli numero di risorse Application: Human Resources Source: Rapporto Dettagli numero di risorse (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG JA PER 人数詳細レポート Imported from BI Publisher Description: 人数詳細レポート Application: Human Resources Source: 人数詳細レポート(XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG KO PER 인원 수 상세 보고서 Imported from BI Publisher Description: 인원수 상세 보고서 Application: HR Source: 인원 수 상세 보고서(XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG PTB PER Relatório Detalhado do Efetivo de Pessoal Imported from BI Publisher Description: Relatório Detalhado do Efetivo de Pessoal Application: Human Resources Source: Relatório Detalhado do Efetivo de Pessoal (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG RU PER Подробный отчет о численности персонала Imported from BI Publisher Description: Подробный отчет о численности персонала Application: Персонал Source: Подробный отчет о численности персонала (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG S PER Antal personer - detaljrapport Imported from BI Publisher Description: Antal personer - detaljrapport Application: Human Resources Source: Antal personer - detaljrapport (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG TR PER Kişi Sayısı Detay Raporu Imported from BI Publisher Description: Kişi Sayısı Detay Raporu Application: İnsan Kaynakları Source: Kişi Sayısı Detay Raporu (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG US PER Head Count Detail Imported from BI Publisher Description: Head Count Detail Report Application: Human Resources Source: Head Count Detail Report (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG ZHS PER 人数详细信息报表 Imported from BI Publisher Description: 人数详细信息报表 Application: 人力资源管理系统 Source: 人数详细信息报表 (XML) Short Name: PERHDCNT_XML DB package: PER_PERHDCNT_XMLP_PKG BI Publisher :cp_business_group_name :cp_nh :cp_nh1 :cp_null :cp_organization_hierarchy_name :cp_term :cp_term1 :cp_top_org_name :cp_worker_type :p_budget :p_business_group_id :p_conc_request_id :p_days_prior_to_end_date :p_include_asg_type :p_include_top_org :p_job_category :p_organization_structure_id :p_report_date :p_report_date_from :p_report_date_to :p_roll_up :p_top_organization_id :p_worker_type 1 -40 :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 -30 :p_report_date Date select trunc(sysdate) from sys.dual Y AR تاريخ التقرير تاريخ تشغيل التقرير D Auswertungsdatum Startdatum Auswertung E Fecha de Informe Fecha de ejecución de informes F Report Date Date d'édition de l'état I Data rapporto Data esecuzione rapporto JA 日付 実行日 KO 보고서 일자 보고서 실행 일자 PTB Data do Relatório Data de Execução do Relatório RU Дата отчета Дата выполнения отчета S Rapportdatum Körningsdatum för rapport TR Rapor Tarihi Rapor Çalıştırma Tarihi US Report Date Report Run Date ZHS 报表日期 报表运行日期 3 -20 :p_job_category Char select 'RG' from sys.dual Y AR فئة الوظيفة فئة الوظيفة - الإيرادات D Tätigkeitskategorie Tätigkeitskategorie - Umsatz E Categoría de Puesto Categoría de puesto: ingresos F Catégorie de fonction Catégorie de fonction - Contribution I Categoria mansione Categoria mansione - Ricavi JA 役職カテゴリ 役職カテゴリ - 収益 KO Job 범주 Job 범주 - 수익 PTB Categoria do Cargo Categoria do Cargo - Receita RU Категория должности Категория специальности - доход S Befattningskategori Befattningskategori - intäkt TR İş Kategorisi İş Kategorisi - Gelir US Job Category Job Category - Revenue ZHS 职务类别 职务类别 - 收入 4 10 :p_report_date_from Date Y AR Date_From من تاريخ D Date_From Von Datum E Date_From De Fecha F Date_From Date - Du I Date_From Data - Da JA Date_From 日付:自 KO Date_From 일자: 부터 PTB Date_From Data - De RU Date_From Дата с S Date_From Från datum TR Date_From Başlangıç Tarihi US Date_From Date From ZHS Date_From 日期自 5 20 :p_report_date_to Date Y AR Date_To التاريخ إلى D Date_To Bis Datum E Date_To A Fecha F Date_To Date - Au I Date_To Data - A JA Date_To 日付:至 KO Date_To 일자: 까지 PTB Date_To Data - Até RU Date_To Дата по S Date_To Till datum TR Date_To Bitiş Tarihi US Date_To Date To ZHS Date_To 日期至 6 30 :p_organization_structure_id LOV Oracle HR_HQ_ORGANIZATION_HIERARCHY Y select pos.organization_structure_id id, pos.name value, null description from per_organization_structures pos where (pos.business_group_id= fnd_global.per_business_group_id or pos.business_group_id is null) and exists (select 1 from per_org_structure_versions posv, per_org_structure_versions posv1 where pos.organization_structure_id=posv.organization_structure_id and posv.organization_structure_id=posv1.organization_structure_id and posv.date_from<=to_date(:$flex$.date_from,'YYYY/MM/DD HH24:MI:SS') and nvl(posv1.date_to,to_date(:$flex$.date_to,'YYYY/MM/DD HH24:MI:SS'))>=to_date(:$flex$.date_to,'YYYY/MM/DD HH24:MI:SS')) order by pos.organization_structure_id Y AR التدرج الوظيفي للمنشأة اسم التدرج الوظيفي للمنشأة D Organisationshierarchie Bezeichnung Organisationshierarchie E Jerarquía de Organizaciones Nombre de jerarquía de organizaciones F Hiérarchie des organisations Nom de la hiérarchie des organisations I Gerarchia organizzazione Nome gerarchia organizzazione JA 組織階層 組織階層名 KO 조직 계층 조직 계층명 PTB Hierarquia da Organização Nome da Hierarquia da Organização RU Иерархия организации Имя иерархии организаций S Organisationshierarki Namn på organisationshierarki TR Organizasyon Hiyerarşisi Organizasyon Hiyerarşisi Adı US Organization Hierarchy Organization Hierarchy Name ZHS 组织层次结构 组织层次结构名 7 40 :p_top_organization_id LOV Oracle HR_ORGANIZATIONS Y select hou.organization_id id, hou.name value, null description from hr_organization_units hou where hou.organization_id in ( select pose.organization_id_parent from per_org_structure_elements pose ,per_org_structure_versions posv where pose.org_structure_version_id=posv.org_structure_version_id and posv.organization_structure_id= :$flex$.hr_hq_organization_hierarchy union select pose.organization_id_child from per_org_structure_elements pose ,per_org_structure_versions posv where pose.org_structure_version_id=posv.org_structure_version_id and posv.organization_structure_id= :$flex$.hr_hq_organization_hierarchy ) order by value,description Y AR أعلى منشأة أعلى منشأة D Übergeordnete Organisation Übergeordnete Organisation E Organización Superior Organización superior F Organisation supérieure Organisation supérieure I Organizzazione principale Organizzazione principale JA 最高組織 最高組織 KO 최상위 조직 최상위 조직 PTB Organização Superior Organização Superior RU Головная организация Головная организация S Överordnad org. Överordnad org. TR En Üst Organizasyon En Üst Organizasyon US Top Organization Top Organization ZHS 顶层组织 顶层组织 8 50 :p_worker_type LOV Oracle HR_HEADCOUNT_WORKER_TYPE Y select hl.lookup_code id, hl.meaning value, null description from hr_lookups hl where hl.lookup_type='HR_HEADCOUNT_WORKER_TYPE' and ((hr_person_flex_logic.headcountforcwk='N' and hl.lookup_code='E') or hr_person_flex_logic.headcountforcwk='Y') order by value,description select hl.meaning from hr_lookups hl where hl.lookup_type = 'HR_HEADCOUNT_WORKER_TYPE' and hl.lookup_code = 'E' Y AR نوع العامل نوع العامل D Mitarbeiterart Mitarbeiterart E Tipo de Trabajador Tipo de trabajador F Type d'intervenant Type d'intervenant I Tipo di lavoratore Tipo di lavoratore JA 就業者タイプ 就業者タイプ KO 근로자 유형 근로자 유형 PTB Tipo de Trabalhador Tipo de Trabalhador RU Тип исполнителя Тип исполнителя S Typ av arbetstagare Typ av arbetstagare TR Çalışan Tipi Çalışan Tipi US Worker Type Worker Type ZHS 员工类型 员工类型 9 60 :p_roll_up 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 select hl.meaning from hr_lookups hl where hl.lookup_type = 'YES_NO' and hl.lookup_code = 'Y' Y AR تجميع تجميع بيانات المنشآت D Zusammenfassen Organisationen zusammenfassen E Acumular Acumular organizaciones F Regrouper Regrouper des organisations I Aggrega Aggrega le organizzazioni JA 積上 組織を積上 KO 적상 조직 적상 PTB Totalizar Totalizar Organizações RU Сведение Сведение организаций S Summering Summera organisationer TR Aktar Organizasyonları Aktar US Roll Up Roll Up Organizations ZHS 累计 累计组织 10 70 :p_budget LOV Oracle HR_HEADCOUNT_BUDGET_TYPE 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=1010887 order by ffvv.flex_value select 'HEAD' from sys.dual Y AR الموازنة قياس الموازنة D Budget Budgetkennzahl E Presupuesto Medida presupuestaria F Budget Mesure du budget I Budget Valutazione del budget JA 予算計画 予算計画測定 KO 예산 예산 측정 PTB Orçamento Mensuração do Orçamento RU Бюджет Бюджетный показатель S Budget Nyckeltal för budget TR Bütçe Bütçe Ölçümü US Budget Budget Measurement ZHS 预算 预算度量 11 80 :p_include_top_org 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 select hl.meaning from hr_lookups hl where hl.lookup_type = 'YES_NO' and hl.lookup_code = 'Y' Y AR تضمين أعلى منشأة تضمين قيم أعلى منشأة D Mit übergeordneter Organisation Mit Werten der übergeordneten Organisation E Incluir Organización Superior Incluir los valores de la organización superior F Inclure l'organisation supérieure Inclure les valeurs de l'organisation supérieure I Includi organizzazione al vertice Includi i valori dell'organizzazione principale JA 最高組織に組込む 最高組織の値に組込む KO 최상위 조직 포함 최상위 조직 값 포함 PTB Incluir Organização Superior Incluir Valores da Organização Superior RU Включая головную организацию Включая значения для головной организации S Inkludera överordnad org. Inkludera värden för överordnad org. TR En Üst Organizasyonu Dahil Et En Üst Organizasyonun Değerlerini Dahil Eder US Include Top Organization Include Values of Top Organization ZHS 包括顶层组织 包括顶层组织的值 12 90 :p_include_asg_type LOV Oracle HR_HEADCOUNT_ASG_TYPE 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=1010886 order by ffvv.flex_value select 'A' from sys.dual Y AR تضمين نوع التعيين تضمين أنواع التعيينات - النشطة / المعلقة/ كلاهما D Zuordnungsart berücksichtigen Zuordnungsarten berücksichtigen - Aktiv/Unterbrechen/Beides E Incluir Tipo de Asignación Incluir el tipo de asignación: activa/suspendida/ambas F Inclure le type d'affectation Inclure les types d'affectation - Active / Suspendue / Les deux I Includi tipo di assegnazione Include i tipi di assegnazione: Attivo/Sospendi/Entrambi JA アサイメント・タイプを含む アサイメント・タイプを含む - 有効 / 休止/ 両方 KO 발령 유형 포함 발령 유형 포함 - 유효/보류/모두 PTB Incluir Tipo de Atribuição Inclui Tipos de Atribuição - Ativo / Suspenso/ Ambos RU Включая тип назначения Включая типы назначения - Активно / Приостановлено/ Все S Inkludera typ av anst.uppdrag Inkludera typer av anst.uppdrag - Aktiv/Uppehållen/Båda TR Görev Tipini Ekle Görev Tiplerini Dahil Eder - Etkin / Askıda/ Her İkisi US Include Assignment Type Include Assignment Types - Active / Suspend/ Both ZHS 包括分配类型 包括分配类型 - 有效/暂停/两者兼有 13 100 :p_days_prior_to_end_date Number select 31 from sys.dual Y AR الأيام السابقة لتاريخ النهاية الأيام السابقة لتاريخ النهاية لنسخة التدرج الوظيفي للمنشأة D Tage vor dem Enddatum Tage vor dem Enddatum der Organisationshierarchie-Version E Días Anteriores a la Fecha de Finalización Días anteriores a la fecha de finalización de la versión de jerarquía de organizaciones F Nombre de jours avant la date de fin Nombre de jours avant la date de fin de la version de hiérarchie des organisations I Giorni prima della data di fine Giorni prima della data di fine della versione gerarchia organizzazioni JA 終了日前日数 組織階層バージョンの終了日前日数 KO 종료 일자 이전 일수 조직 계층 버전의 종료 일자 이전 일수 PTB Dias Antes à Data Final Dias Antes à Data Final da Versão da Hierarquia da Organização RU Число дней до конечной даты Число дней до конечной даты версии иерархии организаций S Dagar före slutdatum Dagar före slutdatum för organisationshierarkiversion TR Bitiş Tarihinden Önceki Günler Organizasyon Hiyerarşisi Sürümü Bitiş Tarihinden önceki günler US Days Prior to End Date Days Prior to the End Date of the Org Hierarchy Version ZHS 早于终止日期的天数 早于组织层次结构版本终止日期的天数 :$flex$.date_from Date_From Y Organization Hierarchy :$flex$.date_to Date_To Y Organization Hierarchy :$flex$.hr_hq_organization_hierarchy Organization Hierarchy Top Organization