ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B851A9E05362FB09050512Y select wdd.inventory_item_id, &LP_ITEM_DISPLAY_VALUE item_info, wdd.item_description, wdd.organization_id, wdd.source_code, wdd.source_header_number, sum(nvl(wdd.requested_quantity,0)) backordered_quantity, max(wts.actual_departure_date) last_shipped_date, nvl(wdd.unit_price, 0) unit_price, wdd.currency_code currency_code, wdd.requested_quantity_uom, wdd.source_header_type_name order_type, WSH_WSHRDBSR_XMLP_PKG.cf_warehouseformula(wdd.organization_id) CF_WAREHOUSE, WSH_WSHRDBSR_XMLP_PKG.cf_item_descriptionformula(wdd.inventory_item_id, wdd.organization_id, wdd.item_description) CF_ITEM_DESCRIPTION, WSH_WSHRDBSR_XMLP_PKG.cf_last_shipped_dateformula(wdd.organization_id, wdd.source_header_number) CF_LAST_SHIPPED_DATE, WSH_WSHRDBSR_XMLP_PKG.cf_shipped_qtyformula(wdd.currency_code, wdd.organization_id, wdd.inventory_item_id, wdd.source_header_number, wdd.source_header_type_name, wdd.requested_quantity_uom, nvl ( wdd.unit_price , 0 )) CF_Shipped_qty, WSH_WSHRDBSR_XMLP_PKG.cf_shipped_amtformula(WSH_WSHRDBSR_XMLP_PKG.cf_shipped_qtyformula(wdd.currency_code, wdd.organization_id, wdd.inventory_item_id, wdd.source_header_number, wdd.source_header_type_name, wdd.requested_quantity_uom, nvl ( wdd.unit_price , 0 )), nvl ( wdd.unit_price , 0 )) CF_shipped_amt, WSH_WSHRDBSR_XMLP_PKG.cf_bo_amtformula(sum ( nvl ( wdd.requested_quantity , 0 ) ), nvl ( wdd.unit_price , 0 )) CF_bo_amt from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_legs wdl, wsh_trip_stops wts where wdd.released_status = 'B' and wdd.source_code = 'OE' and wdd.delivery_detail_id = wda.delivery_detail_id and nvl(wdd.line_direction, 'O') IN ('O', 'IO') and wda.delivery_id = wdl.delivery_id(+) and wdl.pick_up_stop_id = wts.stop_id(+) &lp_organization_id &lp_header_number &lp_order_type GROUP BY wdd.inventory_item_id, &LP_ITEM_DISPLAY_VALUE, wdd.item_description, wdd.organization_id, wdd.source_code, wdd.source_header_number, wdd.source_header_type_name, wdd.requested_quantity_uom, wdd.unit_price, wdd.currency_code ORDER BY 4 ASC,1 ASC,2 ASC ,wdd.organization_id, item_info, wdd.source_code, wdd.source_header_number WSH WSHRDBSR_XML AR WSH تقرير إجمالي المتأخرات (بتنسيق XML) Imported from BI Publisher Description: تقرير إجمالي المتأخرات Application: تنفيذ الشحن Source: تقرير إجمالي المتأخرات (بتنسيق XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG D WSH Nachlieferungen - Übersicht Imported from BI Publisher Description: Nachlieferungen - Übersicht Application: Shipping Execution Source: Nachlieferungen - Übersicht (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG E WSH Informe Resumen de Pedidos No Satisfechos Imported from BI Publisher Description: Informe Resumen de Pedidos No Satisfechos Application: Shipping Execution Source: Informe Resumen de Pedidos No Satisfechos (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG F WSH Etat Synthèse des reliquats Imported from BI Publisher Description: Etat Synthèse des reliquats Application: Shipping Execution Source: Etat Synthèse des reliquats (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG I WSH Rapporto Sintetico ordini inevasi Imported from BI Publisher Description: Rapporto Sintetico ordini inevasi Application: Shipping Execution Source: Rapporto Sintetico ordini inevasi (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG JA WSH バックオーダー要約レポート Imported from BI Publisher Description: バックオーダー要約レポート Application: Shipping Execution Source: バックオーダー要約レポート(XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG KO WSH 미납주문 요약 보고서 Imported from BI Publisher Description: 미납주문 요약 보고서 Application: Shipping Execution Source: 미납주문 요약 보고서(XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG PTB WSH Relatório Resumido de Backorder Imported from BI Publisher Description: Relatório Sumariado de Backorder Application: Execução da Entrega Source: Relatório Resumido de Backorder (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG RU WSH Сводный отчет об отложенных заказах Imported from BI Publisher Description: Сводный отчет об отложенных заказах Application: Выполнение отгрузки Source: Сводный отчет об отложенных заказах (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG S WSH Restorder - översiktsrapport Imported from BI Publisher Description: Restorder - översiktsrapport Application: Shipping Execution Source: Restorder - översiktsrapport (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG TR WSH Sipariş Bakiyesi Özet Raporu Imported from BI Publisher Description: Sipariş Bakiyesi Özet Raporu Application: Sevkiyat Yönetimi Source: Sipariş Bakiyesi Özet Raporu (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG US WSH Backorder Summary Imported from BI Publisher Description: Backorder Summary Report Application: Shipping Execution Source: Backorder Summary Report (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG ZHS WSH 延交订单汇总报表 Imported from BI Publisher Description: 延交订单汇总报表 Application: 发运管理系统 Source: 延交订单汇总报表 (XML) Short Name: WSHRDBSR_XML DB package: WSH_WSHRDBSR_XMLP_PKG BI Publisher &lp_header_number &lp_item_display_value &lp_order_type &lp_organization_id :lp_header_number :lp_item_display_value :lp_item_flex_all_seg_high :lp_item_flex_all_seg_low :lp_move_order :lp_order_type :lp_organization_id :lp_structure_num :p_conc_request_id :p_header_id_high :p_header_id_low :p_item_display :p_item_flex_code :p_order_num_high :p_order_num_low :p_organization_id :p_transaction_type_id :p_user_id :rp_company_name :rp_data_found :rp_flex_or_desc :rp_item_flex_all_seg :rp_order_by :rp_order_num_high :rp_order_num_low :rp_order_range :rp_order_type_name :rp_report_name :rp_sub_title :rp_user_id :rp_warehouse 1 -20 :p_item_flex_code Char MSTK 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 项目弹性域代码 项目弹性域代码 2 10 :p_transaction_type_id LOV Oracle WSH_SRS_ORDER_TYPE Y select order_type_id id, order_type_name value, null description from wsh_order_types_regular_v order by order_type_name AR نوع الحركة نوع الحركة D Transaktionsart Transaktionsart E Tipo de Transacción Tipo de Transacción F Type de mouvement Type de mouvement I Tipo di transazione Tipo di transazione JA トランザクション・タイプ トランザクション・タイプ KO 트랜잭션 유형 트랜잭션 유형 PTB Tipo de Transação Tipo de Transação RU Тип транзакции Тип транзакции S Transaktionstyp Transaktionstyp TR İşlem Tipi İşlem Tipi US Transaction Type Transaction Type ZHS 事务处理类型 事务处理类型 3 20 :p_order_num_low LOV Oracle WSH_SRS_ORDER_NUMBERS Y select order_number id, order_number value, null description from oe_order_headers_all where order_type_id=:$flex$.wsh_srs_order_type order by order_number AR رقم أمر المبيعات (من) رقم الطلب (من) D Von Kundenauftragsnummer Von Auftragsnummer E De Número de Pedido de Venta De Número de Pedido F Numéro de commande client (De) Numéro commande - De I Numero ordine di vendita (minimo) Numero ordine (minimo) JA 受注番号 (自) 受注番号 (自) KO 판매 주문 번호 (하한) 주문번호(하한) PTB Número da Ordem de Venda (Inferior) Número da Ordem (Inferior) RU Номер заказа на продажу с Номер заказа с S Från kundordernummer Ordernummer (från) TR Satış Siparişi Numarası (Alt Değer) Sipariş Numarası (Alt Değer) US Sales Order Number (Low) Order Number (Low) ZHS 销售订单编号（下限） 订单编号（下限） 4 30 :p_order_num_high LOV Oracle WSH_SRS_ORDER_NUMBERS Y select order_number id, order_number value, null description from oe_order_headers_all where order_type_id=:$flex$.wsh_srs_order_type order by order_number AR رقم أمر المبيعات (إلى) رقم الطلب (إلى) D Bis Kundenauftragsnummer Bis Auftragsnummer E A Número de Pedido de Venta A Número de Pedido F Numéro de commande client (A) Numéro commande - A I Numero ordine di vendita (massimo) Numero ordine (massimo) JA 受注番号 (至) 受注番号 (至) KO 판매 주문 번호 (상한) 주문번호(상한) PTB Número da Ordem de Venda (Superior) Número da Ordem (Superior) RU Номер заказа на продажу по Номер заказа по S Till kundordernummer Ordernummer (till) TR Satış Siparişi Numarası (Üst Değer) Sipariş Numarası (Üst Değer) US Sales Order Number (High) Order Number (High) ZHS 销售订单编号（上限） 订单编号（上限） 5 40 :p_organization_id LOV Oracle WSH_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions order by organization_code select organization_code from org_organization_definitions where organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') AR المستودع المستودع D Lagerorganisation Lagerorganisation E Almacén Almacén F Entrepôt Entrepôt I Magazzino Magazzino JA 倉庫 倉庫 KO 창고 창고 PTB Depósito Depósito RU Склад Склад S Lager Lager TR Temin Yeri Temin Yeri US Warehouse Warehouse ZHS 仓库 仓库 6 50 :p_item_display LOV Oracle WSH_MGD_ITEM_DISPLAY Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='ITEM_DISPLAY' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'ITEM_DISPLAY' and lookup_code = 'D' Y AR عرض الصنف طباعة الصنف المخزني الوصفي أو المرن D Artikelanzeige Lagerartikel-Beschreibung oder FlexFeld drucken E Presentación del Artículo Imprimir Descripción de Artículo de Inventario o Estructura F Affichage article Imprimer description ou clé d'article stocké I Visualizzazione articolo Stampa la descrizione o il flexfield dell'articolo di magazzino JA 品目表示 在庫品目摘要またはフレックスの印刷 KO 품목 표시 재고 품명 또는 가변 PTB Exibição do Item Imprimir Descrição ou Flex. do Item de Inventário RU Вывод позиции Печать описания или ГП позиции запасов S Artikelvisning Skriv ut beskr. av lagerart. eller flexfält TR Kalem Görüntüleme Envanter Kalemi Tanımlamasını veya Esnekalanını Yazdırır. US Item Display Print Inventory Item Description or Flex ZHS 物料显示 打印库存物料说明或弹性域