ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D4710751A9E05362FB09050512Y select org.name customer_name, ho.name hold_name, hs.hold_until_date, hs.hold_comment, h.order_number, h.ordered_date order_date, h.transactional_curr_code currency_code, nvl(l.ordered_quantity,0) * nvl(l.unit_selling_price,0) amount, oh.header_id, oh.line_id, oh.order_hold_id, l.item_identifier_type, &rp_item_flex_all_seg item_flex, l.inventory_item_id, l.ordered_item_id, l.ordered_item, ONT_OEXOHOHS_XMLP_PKG.c_show_amountformula(oh.header_id, :C_line_or_order) C_show_amount, ONT_OEXOHOHS_XMLP_PKG.c_line_or_orderformula(oh.order_hold_id) C_line_or_order, ONT_OEXOHOHS_XMLP_PKG.c_amountformula(nvl ( l.ordered_quantity , 0 ) * nvl ( l.unit_selling_price , 0 )) C_amount, ONT_OEXOHOHS_XMLP_PKG.C_FORMATTED_FLEX_VALUE_p C_FORMATTED_FLEX_VALUE, ONT_OEXOHOHS_XMLP_PKG.Item_dspFormula(l.item_identifier_type,:c_master_org,l.inventory_item_id,l.ordered_item_id,l.ordered_item,SI.ORGANIZATION_ID) Item_dsp from oe_sold_to_orgs_v org, mtl_system_items_vl si, oe_order_holds_all oh, oe_order_lines_all l, oe_order_headers h, oe_hold_definitions ho, oe_hold_sources_all hs where &P_where_flex &lp_customer_where &lp_hold_where and oh.header_id = h.header_id and h.sold_to_org_id = org.organization_id and (h.cancelled_flag is null or h.cancelled_flag = 'N') and h.open_flag='Y' and oh.hold_source_id = hs.hold_source_id and hs.hold_id = ho.hold_id and h.header_id = l.header_id(+) and l.open_flag = 'Y' and l.line_id = nvl(oh.line_id,l.line_id) and l.service_reference_line_id is null and l.inventory_item_id = si.inventory_item_id and oh.hold_release_id is null and nvl(si.organization_id,0) = :c_master_org and nvl(h.org_id,0) = nvl(:p_org_id,0) and nvl(l.org_id,0) = nvl(:p_org_id,0) order by org.name,ho.name,h.order_number, si.description ONT OEXOHOHS_XML AR ONT تقرير الإيقافات المستحقة Imported from BI Publisher Description: تقرير الإيقافات المستحقة Application: إدارة الطلبات Source: تقرير الإيقافات المستحقة (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG D ONT Aktuelle Auftragssperren Imported from BI Publisher Description: Aktuelle Auftragssperren Application: Order Management Source: Aktuelle Auftragssperren (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG E ONT Informe Retenciones Pendientes Imported from BI Publisher Description: Informe Retenciones Pendientes Application: Order Management Source: Informe Retenciones Pendientes (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG F ONT Etat Blocages en attente Imported from BI Publisher Description: Etat Blocages en attente Application: Order Management Source: Etat Blocages en attente (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG I ONT Rapporto Blocchi in sospeso Imported from BI Publisher Description: Rapporto Blocchi in sospeso Application: Order Management Source: Rapporto Blocchi in sospeso (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG JA ONT 未処理保留レポート Imported from BI Publisher Description: 未処理保留レポート Application: Order Management Source: 未処理保留レポート(XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG KO ONT 보류 현황 보고서 Imported from BI Publisher Description: 보류 현황 보고서 Application: Order Management Source: 보류 현황 보고서(XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG PTB ONT Relatório de Retenções Pendentes Imported from BI Publisher Description: Relatório de Retenções Pendentes Application: Gerenciamento de Ordens Source: Relatório de Retenções Pendentes (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG RU ONT Отчет о действующих блокировках Imported from BI Publisher Description: Отчет о действующих блокировках Application: Управление заказами Source: Отчет о действующих блокировках (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG S ONT Utestående spärrar - rapport Imported from BI Publisher Description: Utestående spärrar - rapport Application: Order Management Source: Utestående spärrar - rapport (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG TR ONT Bekleyen Durdurmalar Raporu Imported from BI Publisher Description: Bekleyen Durdurmalar Raporu Application: Sipariş Yönetimi(1) Source: Bekleyen Durdurmalar Raporu (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG US ONT Outstanding Holds Imported from BI Publisher Description: Outstanding Holds Report Application: Order Management Source: Outstanding Holds Report (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG ZHS ONT 未解决的暂挂报表 Imported from BI Publisher Description: 未解决的暂挂报表 Application: 订单管理 Source: 未解决的暂挂报表 (XML) Short Name: OEXOHOHS_XML DB package: ONT_OEXOHOHS_XMLP_PKG BI Publisher &lp_customer_where &lp_hold_where &p_where_flex &rp_item_flex_all_seg :c_formatted_flex_value :c_line_or_order :c_master_org :lp_customer_where :lp_hold_where :operating_unit :p_conc_request_id :p_cust_name_hi :p_cust_name_lo :p_enable_trace :p_flex_or_desc :p_hold_name_hi :p_hold_name_lo :p_item_flex_code :p_item_hi :p_item_lo :p_item_structure_num :p_mix_precision :p_org_id :p_sob_id :p_where_flex :rp_item_flex_all_seg 1 -30 :p_sob_id Number select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) from dual Y AR معرف دفتر الأستاذ معرف دفتر الأستاذ D Buchkennung Buchkennung E Id Libro Mayor Identificador de libro mayor F ID livre ID livre I Id libro contabile Id del libro contabile JA 元帳ID 元帳ID KO 원장 ID 원장 ID PTB Id do Razão Id do Razão RU Идентификатор книги Идентификатор книги S Huvudboks-id Huvudboks-id TR Defter No Defter No US Ledger Id Ledger Id ZHS 分类帐标识 分类帐标识 2 -20 :p_item_flex_code Char fnd_profile.value('OE_ID_FLEX_CODE') Y AR رمز الصنف المرن الرمز المرن للصنف المخزني D Artikel-FlexFeld-Schlüssel FlexFeld-Schlüssel Lagerartikel E Código de Estructura de Artículo Código de Estructura de Artículo de Inventario F Code clé article Code clé article stocké I Codice flexfield Articolo Codice del flexfield Articolo di magazzino JA 品目フレックス・コード 在庫品目フレックス・コード KO 품목 가변 코드 재고 품목 가변 코드 PTB Código Flex. do Item Código do Flexf. de Item do Inventário RU Код ГП позиции Код ГП позиции запасов S Artikelflexkod Flexkod för lagerartikel TR Kalem Esnek Kodu Envanter Kalemi Esnek Kodu US Item Flex Code Inventory Item Flex Code ZHS 项目弹性域代码 库存物料弹性代码 3 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 4 10 :p_cust_name_lo LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name AR اسم العميل (من) اسم العميل (من) D Von Kunde Von Kunde E Nombre del Cliente (De) Nombre del Cliente (De) F Nom client (De) Nom client (De) I Nome cliente - Da Nome cliente - Da JA 顧客名 (自) 顧客名 (自) KO 고객명(부터) 고객명(부터) PTB Nome do Cliente (De) Nome do Cliente (De ) RU Имя заказчика с Имя заказчика с S Kundnamn (från) Kundnamn från TR Müşteri Adı (İlk) Müşteri Adı (İlk) US Customer Name (From) Customer Name (From ) ZHS 客户名称（自） 客户名称（自） 5 20 :p_cust_name_hi LOV Oracle ONT_SRS_CUSTOMER_NAME Y Y select party_name id, party_name value, null description from hz_parties where exists (select null from hz_cust_accounts ha where ha.party_id=hz_parties.party_id) order by party_name select :$flex$.customer_name_from from dual AR اسم العميل (إلى) اسم العميل (إلى) D Bis Kunde Bis Kunde E Nombre del Cliente (A) Nombre del Cliente (A) F Nom client (A) Nom client (A) I Nome cliente - A Nome cliente - A JA 顧客名 (至) 顧客名 (至) KO 고객명(까지) 고객명(까지) PTB Nome do Cliente (Até) Nome do Cliente (Até) RU Имя заказчика по Имя заказчика по S Kundnamn (till) Kundnamn (till) TR Müşteri Adı (Son) Müşteri Adı (Son) US Customer Name (To) Customer Name (To) ZHS 客户名称（至） 客户名称（至） 6 30 :p_hold_name_lo LOV Oracle ONT_SRS_HOLD_NAME Y select name id, name value, null description from oe_hold_definitions order by name AR اسم الإيقاف (من) اسم الإيقاف (من) D Von Sperre Von Sperre E Nombre de Retención (De) Nombre de Retención (De) F Code blocage (Du) Code blocage (Du) I Nome blocco - Da Nome blocco - Da JA 保留名 (自) 保留名 (自) KO 보류명(부터) 보류명(부터) PTB Nome da Retenção (De) Nome da Retenção (De) RU Имя блокировки с Имя блокировки с S Spärrnamn (från) Spärrnamn (från) TR Durdurma Adı (İlk) Durdurma Adı (İlk) US Hold Name (From) Hold Name (From) ZHS 暂挂名（自） 暂挂名（自） 7 40 :p_hold_name_hi LOV Oracle ONT_SRS_HOLD_NAME Y select name id, name value, null description from oe_hold_definitions order by name select :$flex$.hold_name_from from dual AR اسم الإيقاف (إلى) اسم الإيقاف (إلى) D Bis Sperre Bis Sperre E Nombre de Retención (A) Nombre de Retención (A) F Nom blocage (A) Nom blocage (A) I Nome blocco - A Nome blocco - A JA 保留名 (至) 保留名 (至) KO 보류명(까지) 보류명(까지) PTB Nome da Retenção (Até) Nome da Retenção (Até) RU Имя блокировки по Имя блокировки по S Spärrnamn (till) Spärrnamn (till) TR Durdurma Adı (Son) Durdurma Adı (Son) US Hold Name (To) Hold Name (To) ZHS 暂挂名（至） 暂挂名（至） 8 50 :p_item_lo Char AR الصنف (من) الصنف (من) D Von Artikel Von Artikel E Artículo (De) Artículo (De) F Article (De) Article (De) I Articolo - Da Articolo - Da JA 品目 (自) 品目 (自) KO 품목(부터) 품목(부터) PTB Item (De) Item (De) RU Позиция с Позиция с S Artikel (från) Artikel (från) TR Kalem (İlk) Kalem (İlk) US Item (From) Item (From) ZHS 项目（自） 项目（自） 9 60 :p_item_hi Char AR الصنف (إلى) الصنف (إلى) D Bis Artikel Bis Artikel E Artículo (A) Artículo (A) F Article (A) Article (A) I Articolo - A Articolo - A JA 品目 (至) 品目 (至) KO 품목(까지) 품목(까지) PTB Item (Até) Item (Até) RU Позиция по Позиция по S Artikel (till) Artikel (till) TR Kalem (Son) Kalem (Son) US Item (To) Item (To) ZHS 项目（至） 项目（至） 10 70 :p_flex_or_desc LOV Oracle ONT_SRS_ITEM_DISPLAY_CODE Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='ITEM_DISPLAY_CODE' order by value,description select meaning from oe_lookups where lookup_type='ITEM_DISPLAY_CODE' and lookup_code='D' Y AR عرض الصنف عرض الصنف D Artikelanzeige Artikelanzeige E Presentación de Artículo Presentación de Artículo F Affichage article Affichage article I Visualizzazione articolo Visualizzazione articolo JA 品目表示 品目表示 KO 품목 표시 품목 표시 PTB Exibição do Item Exibição do Item RU Вывод позиции Вывод позиции S Artikelvisning Artikelvisning TR Kalem Görüntüleme Kalem Görüntüleme US Item Display Item Display ZHS 项目显示 项目显示 11 80 :p_mix_precision Number fnd_profile.value('CURRENCY:MIXED_PRECISION') Y AR الدقة المختلطة الدقة المختلطة D Untersch. Kommastellen Untersch. Kommastellen E Precisión Mixta Precisión Mixta F Précision mixte Précision mixte I Precisione combinata Precisione combinata JA 精度の混合 精度の混合 KO 혼합 소수점자리 혼합 소수점자리 PTB Precisão Mista Precisão Mista RU Смешанная точность Смешанная точность S Blandad precision Blandad precision TR Karma Duyarlılık Karma Duyarlılık US Mixed Precision Mixed Precision ZHS 混合精确度 混合精确度