ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471F151A9E05362FB09050512 select hr_general.decode_lookup('PQH_BUDGET_ENTITY', information8) entity_code, hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE', information9) uom, -- ':'||hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE', information9) uom, information9 uomcode, log_context name, to_char(fnd_date.canonical_to_date(information10),'DD-MON-YYYY') under_budgeted_date, NVL(to_number(information3),0) budgeted_amount, NVL(to_number(information4),0) reallocation_amount, NVL(to_number(information5),0) actual_amount, NVL(to_number(information6),0) commitment_amount, Decode(Information9,'MONEY', ((nvl(information3,0) + nvl(information4,0)) - (nvl(information5,0) + nvl(information6,0)) ), ( (Nvl(Information3,0) + Nvl(Information4,0)) - ((Nvl(Information5,0))))) under_budgeted_amount, PQH_PQUBGTEN_XMLP_PKG.cf_amount_format_maskformula(':' || hr_general.decode_lookup ( 'BUDGET_MEASUREMENT_TYPE' , information9 )) CF_AMOUNT_FORMAT_MASK from pqh_process_log where module_cd = 'POSITION_BUDGET_ANALYSIS' and information12 = 'REPORT' and information11 like :P_BATCH_NAME||'%' order by uomcode,entity_code,uom,name,budgeted_amount,reallocation_amount,actual_amount,commitment_amount,under_budgeted_amount,under_budgeted_date Y PQH PQUBGTEN_XML AR PQH تقرير الكيانات التي تقل عن الموازنة (بتنسيق XML) Imported from BI Publisher Description: تقرير كيانات تقل عن الموازنة للوحدة Application: الموارد البشرية للقطاع العام Source: تقرير الكيانات التي تقل عن الموازنة (بتنسيق XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG D PQH Zu niedrig budgetierte Objekte auswerten Imported from BI Publisher Description: Zu niedrig budgetierte Objekte für eine Einheit auswerten Application: Public Sector HR Source: Zu niedrig budgetierte Objekte auswerten (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG E PQH Entidades con Presupuesto Insuficiente Imported from BI Publisher Description: Informe de entidades con presupuesto insuficiente para una unidad Application: Public Sector HR Source: Entidades con Presupuesto Insuficiente (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG F PQH Etat des entités sous-budgétées Imported from BI Publisher Description: Etat des entités sous-budgétées pour une unité Application: Public Sector HR Source: Etat des entités sous-budgétées (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG I PQH Entità con budget insufficienti Imported from BI Publisher Description: Crea rapporto su entità con budget insufficiente per un'unità Application: Public Sector HR Source: Entità con budget insufficienti (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG JA PQH 予算不足エンティティ・レポート Imported from BI Publisher Description: 予算不足エンティティ・レポート(1単位) Application: Public Sector HR Source: 予算不足エンティティ・レポート(XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG KO PQH 미달 예산 개체 보고서 Imported from BI Publisher Description: 단위에 대한 미달 예산 개체 보고서 Application: Public Sector HR Source: 미달 예산 개체 보고서(XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG PTB PQH Informar Relatório de Entidades Previstas em Orçamento Imported from BI Publisher Description: Relatório de Entidades Previstas em Orçamento para uma unidade Application: Public Sector HR Source: Informar Relatório de Entidades Previstas em Orçamento (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG RU PQH Отчет об объектах с недостаточным финансированием Imported from BI Publisher Description: Отчет об объектах с недостаточным финансированием для единицы Application: Государственный сектор: персонал Source: Отчет об объектах с недостаточным финансированием (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG S PQH Rapportera underbudgeterade enheter Imported from BI Publisher Description: Rapportera underbudgeterade enheter för en enhet Application: Public Sector HR Source: Rapportera underbudgeterade enheter (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG TR PQH Rapor Bütçenin Altında Tüzel Kişilikler Imported from BI Publisher Description: Birim için Bütçelenen Tüzel Kişilikler Altında Raporlar Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Rapor Bütçenin Altında Tüzel Kişilikler (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG US PQH Report Under Budgeted Entities Imported from BI Publisher Description: Report Under Budgeted Entities for a unit Application: Public Sector HR Source: Report Under Budgeted Entities (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG ZHS PQH 报告预算不足的实体 Imported from BI Publisher Description: 报告某单位预算不足的实体 Application: Public Sector HR Source: 报告预算不足的实体 (XML) Short Name: PQUBGTEN_XML DB package: PQH_PQUBGTEN_XMLP_PKG BI Publisher :cp_bg_name :cp_entity_name :cp_no_data :cp_org_structure_name :cp_report_title :cp_start_org_name :cp_sysdate :cp_uom :p_batch_name :p_business_group_id :p_conc_request_id :p_effective_date :p_effective_date_t :p_end_date :p_entity_code :p_org_structure_id :p_start_date :p_start_org_id :p_unit_of_measure 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR مجموعة الأعمال مجموعة الأعمال D Unternehmensgruppe Unternehmensgruppe E Grupo de Trabajo Grupo de trabajo F Entité professionnelle Entité professionnelle I Business group Business group JA ビジネス・グループ ビジネス・グループ KO 업무 그룹 업무 그룹 PTB Grupo Funcional Grupo Funcional RU Бизнес-группа Бизнес-группа S Verksamhetsgrupp Verksamhetsgrupp TR İş Grubu İş Grubu US Business Group Business Group ZHS 业务组 业务组 2 10 :p_batch_name Char Y AR اسم المجموعة اسم المجموعة D Stapelbezeichnung Stapelbezeichnung E Nombre de Lote Nombre de lote F Nom du lot Nom du lot I Nome batch Nome del batch JA バッチ名 バッチ名 KO 배치명 배치명 PTB Nome do Lote Nome do Lote RU Имя пакета Имя пакета S Batchnamn Batchnamn TR İşlem Grubu Adı İşlem Grubu Adı US Batch Name Batch Name ZHS 批名 批名 3 20 :p_effective_date Date Y AR P_EFFECTIVE_DATE تاريخ الفعالية D P_EFFECTIVE_DATE Gültigkeitsdatum E P_EFFECTIVE_DATE Fecha en vigor F P_EFFECTIVE_DATE Date de début de validité I P_EFFECTIVE_DATE Data di validità JA P_EFFECTIVE_DATE 有効日 KO P_EFFECTIVE_DATE 유효 일자 PTB P_EFFECTIVE_DATE Data de Efetivação RU P_EFFECTIVE_DATE Дата действия S P_EFFECTIVE_DATE Giltighetsdatum TR P_EFFECTIVE_DATE Geçerlilik Tarihi US P_EFFECTIVE_DATE Effective Date ZHS P_EFFECTIVE_DATE 有效日期 4 30 :p_start_date Date Y AR تاريخ البداية تاريخ البداية D Startdatum Startdatum E Fecha de Inicio Fecha de inicio F Date de début Date de début I Data inizio Data di inizio JA 開始日 開始日 KO 시작 일자 시작 일자 PTB Data Inicial Data Inicial RU Начальная дата Начальная дата S Startdatum Startdatum TR Başlangıç Tarihi Başlangıç Tarihi US Start Date Start Date ZHS 起始日期 起始日期 5 40 :p_end_date Date Y AR تاريخ النهاية تاريخ النهاية D Enddatum Enddatum E Fecha de Finalización Fecha de finalización F Date de fin Date de fin I Data fine Data fine JA 終了日 終了日 KO 종료 일자 종료 일자 PTB Data Final Data Final RU Конечная дата Конечная дата S Slutdatum Slutdatum TR Bitiş Tarihi Bitiş Tarihi US End Date End Date ZHS 终止日期 终止日期 6 50 :p_entity_code LOV Oracle PQH_BUDGET_ENTITY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type in ('PQH_BUDGET_ENTITY','UNDER_BDGT_EXTRA_TYPES') and enabled_flag='Y' and lookup_code not in ('-10000','OPEN') order by meaning Y AR P_ENTITY_CODE الكيان الأساسي D P_ENTITY_CODE Primäres Objekt E P_ENTITY_CODE Entidad principal F P_ENTITY_CODE Entité principale I P_ENTITY_CODE Entità principale JA P_ENTITY_CODE 主エンティティ KO P_ENTITY_CODE 1차 개체 PTB P_ENTITY_CODE Entidade Principal RU P_ENTITY_CODE Основная единица S P_ENTITY_CODE Primär enhet TR P_ENTITY_CODE Birincil Tüzel Kişilik US P_ENTITY_CODE Primary Entity ZHS P_ENTITY_CODE 主要实体 7 60 :p_unit_of_measure LOV Oracle PQH_BUDGET_MEASURE_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='BUDGET_MEASUREMENT_TYPE' and enabled_flag='Y' order by meaning Y AR وحدة قياس الموازنة وحدة قياس الموازنة D Einheit Budgetkennzahl Einheit Budgetkennzahl E Unidad de Medida de Presupuesto Unidad de medida de presupuesto F Unité de mesure du budget Unité de mesure du budget I Unità valutazione budget Unità valutazione budget JA 予算計画測定単位 予算計画測定単位 KO 예산 측정 단위 예산 측정 단위 PTB Unidade de Medição do Orçamento Unidade de Medição do Orçamento RU Единица бюджетного показателя Единица бюджетного показателя S Nyckeltalsenhet för budget Nyckeltalsenhet för budget TR Bütçe Ölçüm Birimi Bütçe Ölçüm Birimi US Budget Measurement Unit Budget Measurement Unit ZHS 预算度量单位 预算度量单位 8 70 :p_org_structure_id LOV Oracle PQH_ORGANIZATION_HIERARCHY Y select pos.organization_structure_id id, pos.name value, null description from per_organization_structures pos where :$flex$.p_entity_code.id in ('ORGANIZATION','POSITION','ALL') and ( pos.business_group_id=fnd_global.per_business_group_id or pos.business_group_id is null ) order by pos.organization_structure_id AR P_ORG_STRUCTURE_ID التدرج الوظيفي للمنشأة D P_ORG_STRUCTURE_ID Organisationshierarchie E P_ORG_STRUCTURE_ID Jerarquía de organizaciones F P_ORG_STRUCTURE_ID Hiérarchie des organisations I P_ORG_STRUCTURE_ID Gerarchia organizzazione JA P_ORG_STRUCTURE_ID 組織階層 KO P_ORG_STRUCTURE_ID 조직 계층 PTB P_ORG_STRUCTURE_ID Hierarquia da Organização RU P_ORG_STRUCTURE_ID Иерархия организации S P_ORG_STRUCTURE_ID Organisationshierarki TR P_ORG_STRUCTURE_ID Organizasyon Hiyerarşisi US P_ORG_STRUCTURE_ID Organization Hierarchy ZHS P_ORG_STRUCTURE_ID 组织层次结构 9 80 :p_start_org_id LOV Oracle PQH_POS_CNTRL_ORGS Y select u.organization_id id, utl.name value, null description from hr_all_organization_units_tl utl,hr_all_organization_units u,per_organization_structures str,per_org_structure_versions ver where exists ( select null from per_org_structure_elements e where e.org_structure_version_id=ver.org_structure_version_id and (e.organization_id_child=u.organization_id or e.organization_id_parent=u.organization_id) ) and u.organization_id=utl.organization_id and utl.language=userenv('LANG') and str.organization_structure_id=ver.organization_structure_id and :$flex$.p_org_structure_id=str.organization_structure_id and fnd_date.canonical_to_date(:$flex$.p_effective_date) between ver.date_from and hr_general.end_of_time order by utl.name AR منشأة البداية منشأة البداية D Startorganisation Startorganisation E Organización Inicial Organización inicial F Organisation de départ Organisation de départ I Organizzazione iniziale Organizzazione iniziale JA 開始組織 開始組織 KO 시작 조직 시작 조직 PTB Organização Inicial Organização Inicial RU Начальная организация Начальная организация S Startorganisation Startorganisation TR Başlangıç Organizasyonu Başlangıç Organizasyonu US Starting Organization Starting Organization ZHS 起始组织 起始组织 :$flex$.p_effective_date P_EFFECTIVE_DATE Y Starting Organization :$flex$.p_entity_code.id P_ENTITY_CODE P_ORG_STRUCTURE_ID :$flex$.p_org_structure_id P_ORG_STRUCTURE_ID Starting Organization