ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4718251A9E05362FB09050512Y select distinct pose.ORGANIZATION_ID_CHILD organization_id ,substr((HR_PERSON_FLEX_LOGIC.GetOrgAliasName(pose.organization_id_child,sysdate)),1,60) name ,hr_head_count_summary.get_rev_start_val(pose.organization_id_child) rev_start_val ,hr_head_count_summary.get_nonrev_start_val(pose.organization_id_child) nonrev_start_val ,hr_head_count_summary.get_rev_end_val(pose.organization_id_child) rev_end_val ,hr_head_count_summary.get_nonrev_end_val(pose.organization_id_child) nonrev_end_val ,hr_head_count_summary.get_rev_net_change(pose.organization_id_child) rev_net_change ,hr_head_count_summary.get_nonrev_net_change(pose.organization_id_child) nonrev_net_change ,hr_head_count_summary.get_rev_nh(pose.organization_id_child) rev_nh ,hr_head_count_summary.get_nonrev_nh(pose.organization_id_child) nonrev_nh ,hr_head_count_summary.get_rev_term(pose.organization_id_child) rev_term ,hr_head_count_summary.get_nonrev_term(pose.organization_id_child) nonrev_term ,hr_head_count_summary.get_rev_other_net(pose.organization_id_child) rev_other_net ,hr_head_count_summary.get_nonrev_other_net(pose.organization_id_child) nonrev_other_net from per_org_structure_elements pose where exists (select 1 from per_org_structure_versions posv where posv.org_structure_version_id = pose.org_structure_version_id and posv.organization_structure_id = :P_ORGANIZATION_STRUCTURE_ID and (posv.date_from <= :P_REPORT_DATE_FROM or nvl(posv.date_to,to_date('31/12/4712','DD/MM/YYYY')) >= :P_REPORT_DATE_TO )) and pose.organization_id_parent = :P_TOP_ORGANIZATION_ID union select TO_NUMBER(:P_TOP_ORGANIZATION_ID) organization_id ,substr((HR_PERSON_FLEX_LOGIC.GetOrgAliasName(:P_TOP_ORGANIZATION_ID,sysdate)),1,60) name ,hr_head_count_summary.get_rev_start_val(:P_TOP_ORGANIZATION_ID) rev_start_val ,hr_head_count_summary.get_nonrev_start_val(:P_TOP_ORGANIZATION_ID) nonrev_start_val ,hr_head_count_summary.get_rev_end_val(:P_TOP_ORGANIZATION_ID) rev_end_val ,hr_head_count_summary.get_nonrev_end_val(:P_TOP_ORGANIZATION_ID) nonrev_end_val ,hr_head_count_summary.get_rev_net_change(:P_TOP_ORGANIZATION_ID) rev_net_change ,hr_head_count_summary.get_nonrev_net_change(:P_TOP_ORGANIZATION_ID) nonrev_net_change ,hr_head_count_summary.get_rev_nh(:P_TOP_ORGANIZATION_ID) rev_nh ,hr_head_count_summary.get_nonrev_nh(:P_TOP_ORGANIZATION_ID) nonrev_nh ,hr_head_count_summary.get_rev_term(:P_TOP_ORGANIZATION_ID) rev_term ,hr_head_count_summary.get_nonrev_term(:P_TOP_ORGANIZATION_ID) nonrev_term ,hr_head_count_summary.get_rev_other_net(:P_TOP_ORGANIZATION_ID) rev_other_net ,hr_head_count_summary.get_nonrev_other_net(:P_TOP_ORGANIZATION_ID) nonrev_other_net from sys.dual where :P_INCLUDE_TOP_ORG = 'Y' PER PERHDSUM_XML AR PER تقرير عدد القوى العاملة (بتنسيق XML) Imported from BI Publisher Description: تقرير إجمالي عدد الأشخاص Application: الموارد البشرية Source: تقرير عدد القوى العاملة (بتنسيق XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG D PER Anzahl Personal Imported from BI Publisher Description: Auswertung "Mitarbeiteranzahl - Übersicht" Application: Human Resources Source: Anzahl Personal (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG E PER Recuento de Fuerza de Trabajo Imported from BI Publisher Description: Informe de resumen de plantilla Application: Human Resources Source: Recuento de Fuerza de Trabajo (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG F PER Etat Effectif de main-d'oeuvre Imported from BI Publisher Description: Etat Synthèse des effectifs Application: Human Resources Source: Etat Effectif de main-d'oeuvre (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG I PER Rapporto Conteggio forza lavoro Imported from BI Publisher Description: Rapporto Sintetico numero di risorse Application: Human Resources Source: Rapporto Conteggio forza lavoro (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG JA PER 要員数レポート Imported from BI Publisher Description: 人数要約レポート Application: Human Resources Source: 要員数レポート(XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG KO PER 인력 수 보고서 Imported from BI Publisher Description: 인원 수 요약 보고서 Application: HR Source: 인력 수 보고서(XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG PTB PER Relatório da Contagem da Força de Trabalho Imported from BI Publisher Description: Relatório Sumariado do Efetivo de Pessoal Application: Human Resources Source: Relatório da Contagem da Força de Trabalho (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG RU PER Отчет о численности персонала Imported from BI Publisher Description: Сводный отчет о численности персонала Application: Персонал Source: Отчет о численности персонала (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG S PER Antal personer i arbetsstyrka - rapport Imported from BI Publisher Description: Antal personer - översiktsrapport Application: Human Resources Source: Antal personer i arbetsstyrka - rapport (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG TR PER İşgücü Sayım Raporu Imported from BI Publisher Description: Kişi Sayısı Özet Raporu Application: İnsan Kaynakları Source: İşgücü Sayım Raporu (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG US PER Work Force Count Imported from BI Publisher Description: Head Count Summary Report Application: Human Resources Source: Work Force Count Report (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG ZHS PER 员工计数报表 Imported from BI Publisher Description: 人数统计汇总报表 Application: 人力资源管理系统 Source: 员工计数报表 (XML) Short Name: PERHDSUM_XML DB package: PER_PERHDSUM_XMLP_PKG BI Publisher :cp_business_group_name :cp_organization_hierarchy_name :cp_organization_name :cp_top_org_name :p_budget :p_business_group_id :p_conc_request_id :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_from_lp :p_report_date_to :p_report_date_to_lp :p_roll_up :p_top_organization_id 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_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 meaning from fnd_lookup_values where lookup_type = 'Yes_No' and 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 累计 累计组织 9 60 :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 Budgetart Budgetkennzahl E Tipo de Presupuesto Medida presupuestaria F Type de budget Mesure du budget I Tipo di budget Valutazione del budget JA 予算計画タイプ 予算計画測定 KO 예산 유형 예산 측정 PTB Tipo de Orçamento Mensuração do Orçamento RU Тип бюджета Бюджетный показатель S Budgettyp Nyckeltal för budget TR Bütçe Tipi Bütçe Ölçümü US Budget Type Budget Measurement ZHS 预算类型 预算度量 10 70 :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 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 包括顶层组织 包括顶层组织的值 11 80 :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 Zuordnungsart berücksichtigen E Incluir Tipo de Asignación Incluir el tipo de asignación F Inclure le type d'affectation Inclure le type d'affectation I Includi tipo di assegnazione Include il tipo di assegnazione JA アサイメント・タイプを含む アサイメント・タイプを含む KO 발령 유형 포함 발령 유형 포함 PTB Incluir Tipo de Atribuição Incluir Tipo de Atribuição RU Включая тип назначения Включая тип назначения S Inkludera typ av anst.uppdrag Inkludera typ av anst.uppdrag TR Görev Tipini Ekle Görev Tipini Ekle US Include Assignment Type Include Assignment Type ZHS 包括分配类型 包括分配类型