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）限制的操作单元。 C6E085D470FC51A9E05362FB09050512Y SELECT party.party_name cust , cust_acct.account_number custno, h.order_number ordernum, ot.name order_type, h.cust_po_number purchase, h.ordered_date order_date, decode(l.line_category_code,'ORDER',nvl(sum(l.ordered_quantity),0),0) ordqty, decode(l.line_category_code,'ORDER', nvl(sum(l.shipped_quantity),0),0) shipqty, decode(l.line_category_code,'ORDER',decode(l.shippable_flag,'Y', nvl(sum(l.ordered_quantity),0) - nvl(sum(l.shipped_quantity),0), nvl(sum(l.ordered_quantity),0) - nvl(sum(l.fulfilled_quantity),0)),0) ostandqty, decode(l.line_category_code,'ORDER',NVL(SUM(l.ordered_quantity2),0),0) ordqty2, decode(l.line_category_code,'ORDER',NVL(SUM(l.shipped_quantity2),0),0) shipqty2, decode(l.line_category_code,'ORDER',decode(l.shippable_flag,'Y', NVL(SUM(l.ordered_quantity2),0) - NVL(SUM(l.shipped_quantity2),0), nvl(sum(l.ordered_quantity2),0) - nvl(sum(decode(l.fulfilled_quantity2,9.99E125,NULL,l.fulfilled_quantity2)),0)),0) ostandqty2, min( l.item_identifier_type) item_identifier_type, &rp_item_flex_all_seg item_flex, min(l.inventory_item_id) inventory_item_id, min(l.ordered_item_id) ordered_item_id, min(l.ordered_item) ordered_item, decode(l.line_category_code,'RETURN',nvl(sum(l.ordered_quantity),0),0) retqty, decode(l.line_category_code,'RETURN',NVL(SUM(l.ordered_quantity2),0),0) retqty2, l.order_quantity_uom Unit, l.ordered_quantity_uom2 unit2, MIN(l.preferred_grade) grade, l.charge_periodicity_code, ONT_OEXOEITR_XMLP_PKG.cf_charge_periodicityformula(l.charge_periodicity_code) CF_charge_periodicity, --&item_dsp item_dsp, ONT_OEXOEITR_XMLP_PKG.cf_unit2formula(l.ordered_quantity_uom2) CF_unit2, ONT_OEXOEITR_XMLP_PKG.cf_unit1formula(l.order_quantity_uom) CF_unit1, ONT_OEXOEITR_XMLP_PKG.Item_dspFormula(min( l.item_identifier_type),:c_master_org,min(l.inventory_item_id),min(l.ordered_item_id),min(l.ordered_item),SI.ORGANIZATION_ID, SI.INVENTORY_ITEM_ID) item_dsp FROM oe_order_headers_all h, hz_parties party , hz_cust_accounts cust_acct , oe_order_lines_all l, oe_transaction_types_tl ot , mtl_system_items_b_kfv si , mtl_system_items_tl st WHERE cust_acct.cust_account_id = h.sold_to_org_id AND cust_acct.party_id=party.party_id AND h.header_id = l.header_id AND h.order_type_id = ot.transaction_type_id AND ot.language = userenv('LANG') AND si.organization_id = :c_master_org AND si.inventory_item_id = st.inventory_item_id AND si.organization_id = st.organization_id AND st.language = userenv('LANG') AND l.inventory_item_id = si.inventory_item_id AND nvl(l.org_id,0) = nvl(:p_org_id,0) AND nvl(h.org_id,0) = nvl(:p_org_id,0) &lp_customer_name &lp_order_date &lp_order_num &lp_order_type &lp_openonly and &lp_item &lp_order_category &lp_line_category GROUP BY &RP_ITEM_FLEX_ALL_SEG, SI.description, party.party_name, cust_acct.account_number, h.order_number, ot.name, h.cust_po_number, h.ordered_date, l.line_category_code, l.order_quantity_uom, l.ordered_quantity_uom2, l.charge_periodicity_code, l.shippable_flag, --&item_dsp, SI.ORGANIZATION_ID, SI.INVENTORY_ITEM_ID --ORDER BY -- party.party_name ORDER BY item_dsp,23 ASC,20 ASC,21 ASC,1 ASC , party.party_name ONT OEXOEITR_XML AR ONT تقرير الطلبات حسب الصنف Imported from BI Publisher Description: تقرير الطلبات بواسطة الصنف Application: إدارة الطلبات Source: تقرير الطلبات حسب الصنف (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG D ONT Aufträge nach Artikeln Imported from BI Publisher Description: Aufträge nach Artikeln Application: Order Management Source: Aufträge nach Artikeln (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG E ONT Informe Pedidos por Artículo Imported from BI Publisher Description: Informe Pedidos por Artículo Application: Order Management Source: Informe Pedidos por Artículo (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG F ONT Etat Commandes par article Imported from BI Publisher Description: Etat Commandes par article Application: Order Management Source: Etat Commandes par article (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG I ONT Rapporto Ordini per articolo Imported from BI Publisher Description: Rapporto Ordini per articolo Application: Order Management Source: Rapporto Ordini per articolo (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG JA ONT 品目別受注レポート Imported from BI Publisher Description: 品目別受注レポート Application: Order Management Source: 品目別受注レポート(XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG KO ONT 품목별 주문 보고서 Imported from BI Publisher Description: 품목별 주문 보고서 Application: Order Management Source: 품목별 주문 보고서(XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG PTB ONT Relatório de Ordens por Item Imported from BI Publisher Description: Relatório de Ordens por Item Application: Gerenciamento de Ordens Source: Relatório de Ordens por Item (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG RU ONT Отчет о заказах по позициям Imported from BI Publisher Description: Отчет о заказах по позициям Application: Управление заказами Source: Отчет о заказах по позициям (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG S ONT Order efter artikel - rapport Imported from BI Publisher Description: Order efter artikel - rapport Application: Order Management Source: Order efter artikel - rapport (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG TR ONT Kaleme Göre Sipariş Raporu Imported from BI Publisher Description: Kaleme göre Sipariş Raporu Application: Sipariş Yönetimi(1) Source: Kaleme Göre Sipariş Raporu (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG US ONT Orders by Item Imported from BI Publisher Description: Orders by Item Report Application: Order Management Source: Orders by Item Report (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG ZHS ONT 按项目列出的订单报表 Imported from BI Publisher Description: 按物料列出的订单报表 Application: 订单管理 Source: 按项目列出的订单报表 (XML) Short Name: OEXOEITR_XML DB package: ONT_OEXOEITR_XMLP_PKG BI Publisher &item_dsp &lp_customer_name &lp_item &lp_line_category &lp_openonly &lp_order_category &lp_order_date &lp_order_num &lp_order_type &rp_item_flex_all_seg :c_master_org :cp_unit1 :cp_unit2 :l_order_type_high :l_order_type_low :lp_customer_name :lp_item :lp_item_flex_code_high :lp_item_flex_code_low :lp_line_category :lp_miss_num :lp_openonly :lp_order_category :lp_order_date :lp_order_num :lp_order_type :operating_unit :p_conc_request_id :p_customer_name_high :p_customer_name_low :p_item_flex_code :p_item_hi :p_item_low :p_item_structure_num :p_line_category :p_one_time :p_openonly :p_order_by :p_order_category :p_order_date_high :p_order_date_high_t :p_order_date_low :p_order_date_low_t :p_order_num_high :p_order_num_low :p_order_type_high :p_order_type_low :p_org_id :p_print_description :p_print_flex_or_desc :p_sob_id :rp_company_name :rp_customer_range :rp_data_found :rp_functional_currency :rp_item_flex_all_seg :rp_item_flex_aprompt :rp_item_flex_code :rp_item_flex_lprompt :rp_item_range :rp_openonly :rp_order_by :rp_order_date_range :rp_order_range :rp_print_description :rp_report_name :rp_sub_title :rp_type_range 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_customer_name_low 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_customer_name_high 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_order_num_low Number AR رقم الطلب (من) رقم الطلب (من) D Von Auftragsnummer Von Auftragsnummer E Número de Pedido (De) Número de Pedido (De) F Numéro commande (De) Numéro commande (De) I Numero ordine - Da Numero ordine - Da JA 受注番号 (自) 受注番号 (自) KO 주문 번호(부터) 주문 번호(부터) PTB Número de Ordem (De) Número de Ordem (De) RU Номер заказа с Номер заказа с S Ordernummer (från) Ordernummer (från) TR Sipariş Numarası (İlk) Sipariş Numarası (İlk) US Order Number (From) Order Number (From) ZHS 订单编号（自） 订单编号（自） 7 40 :p_order_num_high Number select :$flex$.order_number_from from sys.dual AR رقم الطلب (إلى) رقم الطلب (إلى) D Bis Auftragsnummer Bis Auftragsnummer E Número de Pedido (A) Número de Pedido (A) F Numéro commande (A) Numéro commande (A) I Numero ordine - A Numero ordine - A JA 受注番号 (至) 受注番号 (至) KO 주문 번호(까지) 주문 번호(까지) PTB Número de Ordem (Até) Número de Ordem (Até) RU Номер заказа по Номер заказа по S Ordernummer (till) Ordernummer (till) TR Sipariş Numarası (Son) Sipariş Numarası (Son) US Order Number (To) Order Number (To) ZHS 订单编号（至） 订单编号（至） 8 50 :p_order_date_low Date AR تاريخ الطلب (من) تاريخ الطلب من D Von Auftragsdatum Von Auftragsdatum E Fecha de Pedido (De) De Fecha de Pedido F Date commande (Du) Date commande - Du I Data ordine - Da Data ordine (minimo) JA 受注日 (自) 受注日:自 KO 주문 일자(부터) 주문일자 하한 PTB Data da Ordem (De) Data da Ordem - Inferior RU Дата заказа с Дата заказа с S Orderdatum (från) Från orderdatum TR Sipariş Tarihi (İlk) Sipariş Tarihi Alt Değeri US Order Date (From) Order Date Low ZHS 订单日期（自） 订单日期下限 9 60 :p_order_date_high Date SELECT fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.order_date_from)) from DUAL AR تاريخ الطلب (إلى) تاريخ الطلب إلى D Bis Auftragsdatum Bis Auftragsdatum E Fecha de Pedido (A) A Fecha de Pedido F Date commande (Au) Date commande - Au I Data ordine - A Data ordine (massimo) JA 受注日 (至) 受注日:至 KO 주문 일자(까지) 주문일자 상한 PTB Data da Ordem (Até) Data da Ordem - Superior RU Дата заказа по Дата заказа по S Orderdatum (till) Till orderdatum TR Sipariş Tarihi (Son) Sipariş Tarihi Üst Değeri US Order Date (To) Order Date High ZHS 订单日期（至） 订单日期上限 10 70 :p_item_low 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 项目（自） 项目（自） 11 80 :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 项目（至） 项目（至） 12 90 :p_order_category LOV Oracle ONT_SRS_ORDER_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_ORDER_CATEGORY' order by meaning select meaning from oe_lookups where lookup_type='REPORT_ORDER_CATEGORY' and lookup_code='SALES' AR فئة الطلب فئة الطلب D Auftragskategorie Auftragskategorie E Categoría de Pedido Categoría de Pedido F Catégorie de commande Catégorie de commande I Categoria ordine Categoria ordine JA 受注カテゴリ 受注カテゴリ KO 주문 범주 주문 범주 PTB Categoria da Ordem Categoria da Ordem RU Категория заказа Категория заказа S Orderkategori Orderkategori TR Sipariş Kategorisi Sipariş Kategorisi US Order Category Order Category ZHS 订单类别 订单类别 13 100 :p_line_category LOV Oracle ONT_SRS_LINE_CATEGORY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' order by meaning select meaning from oe_lookups where lookup_type='REPORT_LINE_DISPLAY' and lookup_code='SALES' AR فئة السطر فئة السطر D Positionskategorie Positionskategorie E Categoría de Línea Categoría de Línea F Catégorie de ligne Catégorie de ligne I Categoria linea Categoria linea JA 明細カテゴリ 明細カテゴリ KO 라인 범주 라인 범주 PTB Categoria da Linha Categoria da Linha RU Категория строки Категория строки S Radkategori Radkategori TR Satır Kategorisi Satır Kategorisi US Line Category Line Category ZHS 行类别 行类别 14 110 :p_print_description 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 项目显示 项目显示 15 120 :p_openonly LOV Oracle OM: Yes or No Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning AR إظهار الطلبات المفتوحة فقط الطلبات المفتوحة فقط D Nur offene Aufträge Nur offene Aufträge E Mostrar Sólo Pedidos Abiertos Sólo Pedidos Abiertos F Afficher commandes en cours uniquement Commandes en cours uniquement I Mostra solo ordini aperti Solo ordini aperti JA オープン受注のみ表示 オープン受注のみ KO 개설 주문만 표시 개설 주문만 PTB Mostrar Apenas Ordens em Aberto Somente Ordens em Aberto RU Показывать только открытые заказы Только открытые заказы S Visa endast öppna order Endast uteliggande order TR Sadece Açık Siparişleri Göster Sadece Açık Siparişler US Show Open Orders Only Open Orders Only ZHS 仅显示打开的订单 仅限于未完成订单 16 130 :p_order_type_low LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y select ot.order_type_id id, ot.name value, null description from oe_order_types_v ot,hr_operating_units ou where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name AR نوع الطلب (من) نوع الطلب (من) D Von Auftragsart Von Auftragsart E Tipo de Pedido (De) Tipo de Pedido (De) F Type commande (De) Type commande (De) I Tipo di ordine - Da Tipo di ordine - Da JA 受注タイプ (自) 受注タイプ (自) KO 주문 유형(부터) 주문 유형(부터) PTB Tipo da Ordem (De) Tipo da Ordem (De) RU Тип заказа с Тип заказа с S Ordertyp (från) Ordertyp (från) TR Sipariş Tipi (İlk) Sipariş Tipi (İlk) US Order Type (From) Order Type (From) ZHS 订单类型（自） 订单类型（自） 17 140 :p_order_type_high LOV Oracle ONT_MOAC_SRS_ORDER_TYPES Y select ot.order_type_id id, ot.name value, null description from oe_order_types_v ot,hr_operating_units ou where ot.org_id=ou.organization_id and (:$flex$.ont_moac_srs_organizations:null is null or :$flex$.ont_moac_srs_organizations:null=ot.org_id) order by ot.name AR نوع الطلب (إلى) نوع الطلب (إلى) D Bis Auftragsart Bis Auftragsart E Tipo de Pedido (A) Tipo de Pedido (A) F Type commande (A) Type commande (A) I Tipo di ordine - A Tipo di ordine - A JA 受注タイプ (至) 受注タイプ (至) KO 주문 유형(까지) 주문 유형(까지) PTB Tipo da Ordem (Até) Tipo da Ordem (Até) RU Тип заказа по Тип заказа по S Ordertyp (till) Ordertyp (till) TR Sipariş Tipi (Son) Sipariş Tipi (Son) US Order Type (To) Order Type (To) ZHS 订单类型（至） 订单类型（至）