ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E151A9E05362FB09050512Y select budget_name, budgeted_entity, budget_style, budget_calendar_name, budget_calendar_frequency, budget_start_date, budget_end_date, budget_version_number, budget_version_start_date, budget_version_end_date, position_name, budget_measurement_type, budget_period_name, budget_period_budgeted_value, budget_period_cmmtmnt_value, budget_period_actual_value, budget_unit_Id, pqh_mgmt_rpt_pkg.get_pos_org(position_id) Organization_name, PQH_PQHWSBPR_XMLP_PKG.cf_act_performula(budget_period_budgeted_value, budget_period_actual_value) CF_act_per, PQH_PQHWSBPR_XMLP_PKG.cf_com_performula(budget_period_budgeted_value, budget_period_cmmtmnt_value) CF_com_per, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value) cf_projected_exp, PQH_PQHWSBPR_XMLP_PKG.cf_proj_performula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value)) CF_proj_per, PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_amtformula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value)) cf_def_ex_amt, PQH_PQHWSBPR_XMLP_PKG.cf_format_maskformula(budget_unit_Id) CF_format_mask, PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_performula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_amtformula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value))) CF_def_ex_per from pqh_budget_details_v where budget_version_id = :p_budget_version_id and (:p_record_type='A' or budget_period_budgeted_value is not null) PQH PQHWSBPR_XML AR PQH تقرير تفاصيل مناصب فترات الموازنات (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية للقطاع العام Source: تقرير تفاصيل مناصب فترات الموازنات (بتنسيق XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG D PQH Budgetperiode - Positionsdetails Imported from BI Publisher Application: Public Sector HR Source: Budgetperiode - Positionsdetails (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG E PQH Detalles de Posición de Período Presupuestario Imported from BI Publisher Application: Public Sector HR Source: Detalles de Posición de Período Presupuestario (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG F PQH Etat détaillé des postes par période budgétaire Imported from BI Publisher Application: Public Sector HR Source: Etat détaillé des postes par période budgétaire (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG I PQH Rapporto Dettagli posizione periodo budget Imported from BI Publisher Application: Public Sector HR Source: Rapporto Dettagli posizione periodo budget (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG JA PQH 予算計画期間職階詳細レポート Imported from BI Publisher Application: Public Sector HR Source: 予算計画期間職階詳細レポート(XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG KO PQH 예산 기간 Position 상세내역 보고서 Imported from BI Publisher Application: Public Sector HR Source: 예산 기간 Position 상세내역 보고서(XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG PTB PQH Relatório Detalhado de Posições do Período Orçamentário Imported from BI Publisher Application: Public Sector HR Source: Relatório Detalhado de Posições do Período Orçamentário (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG RU PQH Подробный отчет о штатных единицах в организации за бюджетный период Imported from BI Publisher Application: Государственный сектор: персонал Source: Подробный отчет о штатных единицах в организации за бюджетный период (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG S PQH Detaljrapport över tjänster i given budgetperiod Imported from BI Publisher Application: Public Sector HR Source: Detaljrapport över tjänster i given budgetperiod (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG TR PQH Bütçe Dönemi Pozisyon Detayı Raporu Imported from BI Publisher Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Bütçe Dönemi Pozisyon Detayı Raporu (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG US PQH Budget Period Position Detail Imported from BI Publisher Application: Public Sector HR Source: Budget Period Position Detail Report (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG ZHS PQH 预算期间职位详细信息报表 Imported from BI Publisher Application: Public Sector HR Source: 预算期间职位详细信息报表 (XML) Short Name: PQHWSBPR_XML DB package: PQH_PQHWSBPR_XMLP_PKG BI Publisher :c_business_group_name :c_report_subtitle :cp_budget_name :cp_budget_version :cp_currency_code :cp_record_value :cp_session_dt :p_budget_version_id :p_business_group_id :p_conc_request_id :p_effective_date :p_record_type :p_report_title :p_session_date 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') US P_business_group_id 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_budget_version_id LOV Oracle PQH_BUDGET_VER_NUMBER Y select budget_version_id id, budget_name ||' - '||version_number value, null description from pqh_budgets bgt,pqh_budget_versions bvr where bgt.budget_id=bvr.budget_id and bgt.business_group_id=fnd_global.per_business_group_id order by bgt.budget_name,version_number Y AR اسم الموازنة D Budgetbezeichnung E Nombre de Presupuesto F Nom du budget I Nome budget JA 予算計画名 KO 예산명 PTB Nome do Orçamento RU Имя бюджета S Budget TR Bütçe Adı US Budget Name ZHS 预算名称 4 30 :p_record_type LOV Oracle PQH_BUDGET_DETAIL_RECORD_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PQH_BUDGET_DETAIL_RECORD_TYPE' order by value,description Select meaning from hr_lookups where lookup_type='PQH_BUDGET_DETAIL_RECORD_TYPE' and lookup_code='A' Y AR نوع السجل D Datensatzart E Tipo de Registro F Type d'enregistrement I Tipo di record JA レコード・タイプ KO 레코드 유형 PTB Tipo de Registro RU Тип записи S Posttyp TR Kayıt Tipi US Record Type ZHS 记录类型