ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4710551A9E05362FB09050512Y select h.order_number, h.ordered_date, l.line_category_code category, fu.user_name, l.item_identifier_type, l.inventory_item_id, l.ordered_item_id, l.ordered_item, DECODE(l.line_category_code,'RETURN',nvl(l.unit_selling_price,0) * nvl(l.ordered_quantity,0) * -1, nvl(l.unit_selling_price,0) * nvl(l.ordered_quantity,0)) line_amt , h.transactional_curr_code, l.charge_periodicity_code, &rp_item_flex_all_seg item_flex, ONT_OEXOEUBK_XMLP_PKG.c_periodicity_dspformula(l.charge_periodicity_code) C_periodicity_dsp, ONT_OEXOEUBK_XMLP_PKG.Item_dspFormula(l.inventory_item_id,l.item_identifier_type,l.ordered_item_id,MSI.ORGANIZATION_ID,l.ordered_item) Item_dsp from fnd_user fu, oe_order_lines_all l, oe_order_headers_all h, mtl_system_items_vl msi where h.header_id = l.header_id and l.inventory_item_id = msi.inventory_item_id and msi.organization_id = nvl(l.ship_from_org_id,:c_master_org) and h.created_by = fu.user_id and l.booked_flag ='N' and (l.cancelled_flag ='N' or l.cancelled_flag is null) and l.open_flag ='Y' --and nvl(h.org_id,0) = nvl(:p_organization_id,0) and nvl(h.org_id,0) = nvl(:p_organization_id1,0) &lp_created_by &lp_order_date &lp_order_category &lp_line_category UNION ALL select h.order_number, h.ordered_date, h.order_category_code category, fu.user_name, null, null, null, null, 0 line_amt, h.transactional_curr_code, null, null, ONT_OEXOEUBK_XMLP_PKG.c_periodicity_dspformula(null) C_periodicity_dsp, null Item_dsp from oe_order_headers_all h, fnd_user fu where h.created_by = fu.user_id and h.booked_flag ='N' and (h.cancelled_flag ='N' or h.cancelled_flag is null) and h.open_flag = 'Y' --and nvl(h.org_id,0) = nvl(:p_organization_id,0) and nvl(h.org_id,0) = nvl(:p_organization_id1,0) and not exists (select null from oe_order_lines_all l1 where l1.header_id = h.header_id ) &lp_created_by &lp_order_date &lp_order_category &lp_order_by ONT OEXOEUBK_XML AR ONT تقرير الطلبات غير المحجوزة Imported from BI Publisher Description: تقرير الطلبات غير المحجوزة Application: إدارة الطلبات Source: تقرير الطلبات غير المحجوزة (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG D ONT Nicht gebuchte Aufträge Imported from BI Publisher Description: Nicht gebuchte Aufträge Application: Order Management Source: Nicht gebuchte Aufträge (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG E ONT Informe Pedidos Sin Registrar Imported from BI Publisher Description: Informe Pedidos Sin Registrar Application: Order Management Source: Informe Pedidos Sin Registrar (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG F ONT Etat Commandes non validées Imported from BI Publisher Description: Etat Commandes non validées Application: Order Management Source: Etat Commandes non validées (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG I ONT Rapporto Ordini non registrati Imported from BI Publisher Description: Rapporto Ordini non registrati Application: Order Management Source: Rapporto Ordini non registrati (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG JA ONT 未記帳受注レポート Imported from BI Publisher Description: 未記帳受注レポート Application: Order Management Source: 未記帳受注レポート(XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG KO ONT 확정되지 않은 주문 보고서 Imported from BI Publisher Description: Unbooked 주문 보고서 Application: Order Management Source: 확정되지 않은 주문 보고서(XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG PTB ONT Relatório de Ordens Não Registradas Imported from BI Publisher Description: Relatório de Ordens Não Registradas Application: Gerenciamento de Ordens Source: Relatório de Ordens Não Registradas (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG RU ONT Отчет о неразмещенных заказах Imported from BI Publisher Description: Отчет о неразмещенных заказах Application: Управление заказами Source: Отчет о неразмещенных заказах (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG S ONT Obokade order - rapport Imported from BI Publisher Description: Obokade order - rapport Application: Order Management Source: Obokade order - rapport (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG TR ONT Ayrılmamış Siparişler Raporu Imported from BI Publisher Description: Kayıtlı Olmayan Siparişler Raporu Application: Sipariş Yönetimi(1) Source: Ayrılmamış Siparişler Raporu (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG US ONT Unbooked Orders Imported from BI Publisher Description: Unbooked Orders Report Application: Order Management Source: Unbooked Orders Report (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG ZHS ONT 未登记订单报表 Imported from BI Publisher Description: 未登记订单报表 Application: 订单管理 Source: 未登记订单报表 (XML) Short Name: OEXOEUBK_XML DB package: ONT_OEXOEUBK_XMLP_PKG BI Publisher &lp_created_by &lp_line_category &lp_order_by &lp_order_category &lp_order_date &rp_item_flex_all_seg :c_master_org :c_periodicity_dsp_flag :lp_created_by :lp_created_by_range :lp_line_category :lp_order_by :lp_order_by_mean :lp_order_category :lp_order_date :lp_order_date_range :operating_unit :p_conc_request_id :p_created_by_high :p_created_by_low :p_item_flex_code :p_item_structure_num :p_line_category :p_one_time :p_order_by :p_order_category :p_order_date_high :p_order_date_low :p_organization_id :p_organization_id1 :p_print_description :p_sob_id :rp_company_name :rp_data_found :rp_dummy_item :rp_functional_currency :rp_item_flex_all_seg :rp_print_description :rp_report_name :rp_sub_title 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 Artikel-FlexFeld-Schlüssel E Código de Estructura de Artículo Código de Estructura de Artículo F Code clé article Code clé article I Codice flexfield Articolo Codice flexfield Articolo JA 品目フレックス・コード 品目フレックス・コード KO 품목 가변 코드 품목 가변 코드 PTB Código Flex. do Item Código Flex. do Item RU Код ГП позиции Код ГП позиции S Artikelflexkod Artikelflexkod TR Kalem Esnek Kodu Kalem Esnek Kodu US Item Flex Code 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_order_by LOV Oracle ONT_SRS_OEXOEUBK_SORTBY Y select lookup_code id, meaning value, null description from oe_lookups where lookup_type='OEXOEUBK ORDER BY' order by meaning select meaning from oe_lookups where lookup_type='OEXOEUBK ORDER BY' AND lookup_code='ORDER_NUMBER' Y AR فرز بواسطة فرز بواسطة الخيارات D Sortieren nach Sortieroptionen E Ordenar por Opciones de Ordenación F Tri par Options de tri I Ordina per Opzioni di ordinamento JA ソート・キー ソート・キー・オプション KO 정렬 기준 정렬 기준 옵션 PTB Classificar por Classificar por Opções RU Сортировка Параметры сортировки S Sortera efter Sorteringsalternativ TR Sıralama Ölçütü Sıralama Bazı seçenekleri US Sort By Sort By options ZHS 排序依据 排序依据选项 5 20 :p_created_by_low LOV Oracle ONT_SRS_AOL_USER Y select user_name id, user_name value, null description from fnd_user order by user_name AR مكون بواسطة (من) مكون بواسطة (من) D Von Erstellt von Von Erstellt von E Creado por (De) Creado por (De) F Créé par (De) Créé par (De) I Creato da - Da Creato da - Da JA 作成者 (自) 作成者 (自) KO 생성자(부터) 생성자(부터) PTB Criado Por (De) Criado Por (De) RU Создано с Создано с S Skapad av (från) Skapad av (från) TR Oluşturan (İlk) Oluşturan (İlk) US Created By (From) Created By (From) ZHS 创建者（自） 创建者（自） 6 30 :p_created_by_high LOV Oracle ONT_SRS_AOL_USER Y select user_name id, user_name value, null description from fnd_user order by user_name select :$flex$.created_by_from from sys.dual AR مكون بواسطة (إلى) مكون بواسطة (إلى) D Bis Erstellt von Bis Erstellt von E Creado por (A) Creado por (A) F Créé par (A) Créé par (A) I Creato da - A Creato da - A JA 作成者 (至) 作成者 (至) KO 생성자(까지) 생성자(까지) PTB Criado por (Até) Criado por (Até) RU Создано по Создано по S Skapad av (till) Skapad av (till) TR Oluşturan (Son) Oluşturan (Son) US Created By (To) Created By (To) ZHS 创建者（至） 创建者（至） 7 40 :p_order_date_low Date AR تاريخ الطلب (من) تاريخ الطلب (من) D Von Auftragsdatum Von Auftragsdatum E Fecha de Pedido (De) Fecha de Pedido (De) F Date commande (Du) Date commande (Du) I Data ordine - Da Data ordine - Da JA 受注日 (自) 受注日 (自) KO 주문 일자(부터) 주문 일자(부터) PTB Data da Ordem (De) Data da Ordem (De) RU Дата заказа с Дата заказа с S Orderdatum (från) Orderdatum (från) TR Sipariş Tarihi (İlk) Sipariş Tarihi (İlk) US Order Date (From) Order Date (From) ZHS 订单日期（自） 订单日期（自） 8 50 :p_order_date_high Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.order_date_from)) from sys.dual AR تاريخ الطلب (إلى) تاريخ الطلب (إلى) D Bis Auftragsdatum Bis Auftragsdatum E Fecha de Pedido (A) Fecha de Pedido (A) F Date commande (Au) Date commande (Au) I Data ordine - A Data ordine - A JA 受注日 (至) 受注日 (至) KO 주문 일자(까지) 주문 일자(까지) PTB Data da Ordem (Até) Data da Ordem (Até) RU Дата заказа по Дата заказа по S Orderdatum (till) Orderdatum (till) TR Sipariş Tarihi (Son) Sipariş Tarihi (Son) US Order Date (To) Order Date (To) ZHS 订单日期（至） 订单日期（至） 9 60 :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 订单类别 订单类别 10 70 :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 行类别 行类别 11 80 :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 项目显示 项目显示