ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E651A9E05362FB09050512Y Select business_group_id bgrp_business_group_id, budget_measurement_type bgrp_budget_measure_type, budget_unit_id bgrp_budget_unit_id, NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id, :p_start_date, :p_end_date, budget_unit_id, :p_currency_code ),0) bgrp_budgeted_amt, NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id, :p_start_date, :p_end_date, budget_unit_id, 'A', :p_currency_code ) ,0) bgrp_actual_amt, NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id, :p_start_date, :p_end_date, budget_unit_id, 'C' , :p_currency_code ),0) bgrp_committed_amt, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )) CF_bgrp_projected_amt, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_amtformula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 ))) CF_bgrp_def_ex_amt, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_com_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )) CF_bgrp_com_per, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_proj_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 ))) CF_bgrp_proj_per, PQH_PQHWSPCH_XMLP_PKG.cf_format_mask3(budget_unit_id) CF_Format_Mask3, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_amtformula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )))) CF_bgrp_def_ex_per, PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_actual_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 )) CF_bgrp_actual_per from pqh_pc_org_summary_v where business_group_id=:business_group_id group by business_group_id, budget_measurement_type, budget_unit_id PQH PQHWSPCH_XML AR PQH تقرير إجمالي المناصب بالمنشأة (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية للقطاع العام Source: تقرير إجمالي المناصب بالمنشأة (بتنسيق XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG D PQH Positionen in Organisation - Übersicht Imported from BI Publisher Application: Public Sector HR Source: Positionen in Organisation - Übersicht (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG E PQH Resumen de Posición de Organización Imported from BI Publisher Application: Public Sector HR Source: Resumen de Posición de Organización (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG F PQH Etat Synthèse des postes de l'organisation Imported from BI Publisher Application: Public Sector HR Source: Etat Synthèse des postes de l'organisation (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG I PQH Rapporto Sintetico posizione nell'organizzazione Imported from BI Publisher Application: Public Sector HR Source: Rapporto Sintetico posizione nell'organizzazione (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG JA PQH 組織職階要約レポート Imported from BI Publisher Application: Public Sector HR Source: 組織職階要約レポート(XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG KO PQH 조직 Position 요약 보고서 Imported from BI Publisher Application: Public Sector HR Source: 조직 Position 요약 보고서(XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG PTB PQH Relatório Sumariado da Posição Organizacional Imported from BI Publisher Application: Public Sector HR Source: Relatório Sumariado da Posição Organizacional (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG RU PQH Сводный отчет о штатных единицах в организации Imported from BI Publisher Application: Государственный сектор: персонал Source: Сводный отчет о штатных единицах в организации (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG S PQH Organisationstjänst - översiktsrapport Imported from BI Publisher Application: Public Sector HR Source: Organisationstjänst - översiktsrapport (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG TR PQH Organizasyon Pozisyonu Özet Raporu Imported from BI Publisher Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Organizasyon Pozisyonu Özet Raporu (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG US PQH Organizational Position Summary Imported from BI Publisher Application: Public Sector HR Source: Organizational Position Summary Report (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG ZHS PQH 组织的职位汇总报表 Imported from BI Publisher Application: Public Sector HR Source: 组织的职位汇总报表 (XML) Short Name: PQHWSPCH_XML DB package: PQH_PQHWSPCH_XMLP_PKG BI Publisher :business_group_id :c_business_group_name :c_report_subtitle :cp_business_group_name :cp_currency :cp_hierarchy_name :cp_position_type :cp_session_dt :p_business_group_id :p_conc_request_id :p_currency_code :p_effective_date :p_end_date :p_organization_id :p_position_id :p_position_type :p_report_title :p_session_date :p_start_date :p_variance_percent 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') AR مجموعة الأعمال D Unternehmensgruppe E Grupo de Trabajo F Entité professionnelle I Business group JA ビジネス・グループ KO 업무 그룹 PTB Grupo Funcional RU Бизнес-группа S Verksamhetsgrupp TR İş Grubu US Business Group ZHS 业务组 2 10 :p_effective_date Date Y AR تاريخ الفعالية D Gültigkeitsdatum E Fecha en Vigor F Date de début de validité I Data validità JA 有効日 KO 유효 일자 PTB Data de Efetivação RU Дата действия S Giltighetsdatum TR Geçerlilik Tarihi US Effective Date ZHS 有效日期 3 20 :p_position_type LOV Oracle PQH_POSITION_BUDGET_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PQH_POSITION_TYPE' order by value,description Y AR نوع المنصب D Positionsart E Tipo de Posición F Type de poste I Tipo di posizione JA 職階タイプ KO Position 유형 PTB Tipo de Posição RU Тип штатной единицы S Tjänstetyp TR Pozisyon Tipi US Position Type ZHS 职位类型 4 30 :p_variance_percent Number AR نسبة التباين D Prozentuale Abweichung E Porcentaje de Desviación F Ecarts en pourcentage I Percentuale scostamento JA 差異パーセント KO 차이 퍼센트 PTB Percentual de Variação RU Процент расхождения S Avvikelse i procent TR Fark Yüzdesi US Variance Percent ZHS 差异百分比 5 40 :p_start_date Date sysdate Y AR تاريخ البداية D Startdatum E Fecha de Inicio F Date de début I Data inizio JA 開始日 KO 시작 일자 PTB Data Inicial RU Начальная дата S Startdatum TR Başlangıç Tarihi US Start Date ZHS 起始日期 6 50 :p_end_date Date sysdate Y AR تاريخ النهاية D Enddatum E Fecha de Finalización F Date de fin I Data fine JA 終了日 KO 종료 일자 PTB Data Final RU Конечная дата S Slutdatum TR Bitiş Tarihi US End Date ZHS 终止日期 7 60 :p_currency_code LOV Oracle PQH_CURRENCY Y select currency_code id, name value, null description from fnd_currencies_active_v where currency_code!='STAT' order by name Y AR العملة D Währung E Divisa F Devise I Divisa JA 通貨 KO 통화 PTB Moeda RU Валюта S Valuta TR Para Birimi US Currency ZHS 币种