ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472B551A9E05362FB09050512 select wdd.currency_code currency_code, wdd.inventory_item_id line_item, wdd.date_requested, nvl(wdd.source_line_set_id,wdd.source_line_id) source_line_set_id, &LP_ORDER_BY sort_by, wdd.source_header_number order_number, wdd.source_header_id source_header_id, substrb(party.party_name,1,50) customer_name, cust_acct.account_number customer_number, wdd.source_line_id, wdd.src_requested_quantity ordered_qty, wdd.src_requested_quantity_uom order_UOM, wdd.source_line_number line_number, wdd.top_model_line_id option_number, &rp_item_flex_all_seg item_code, wdd.inventory_item_id, wdd.item_description, wdd.source_code, wdd.shipment_priority_code, wdd.requested_quantity_uom, sum(nvl(wdd.requested_quantity,0)) backordered_quantity, wdd.date_scheduled, wdd.organization_id, ood.organization_name, WSH_WSHRDBDR_XMLP_PKG.cf_curr_enabledformula(:CS_COUNT_SORT_ENABLED, :CS_SUM_SORT_ENABLED) CF_CURR_ENABLED, WSH_WSHRDBDR_XMLP_PKG.cf_sort_enabledformula(:CS_COUNT_DUOM, :CS_SUM_DUOM) CF_SORT_ENABLED, WSH_WSHRDBDR_XMLP_PKG.cf_distinct_uomformula(wdd.source_header_number) CF_DISTINCT_UOM, WSH_WSHRDBDR_XMLP_PKG.cf_source_codeformula(wdd.source_code) CF_source_code, /* WSH_WSHRDBDR_XMLP_PKG.cf_line_ordered_amtformula(WSH_WSHRDBDR_XMLP_PKG.cf_line_ordered_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id )), wdd.unit_price) CF_LINE_ORDERED_AMT,*/ WSH_WSHRDBDR_XMLP_PKG.cf_line_ordered_amtformula(WSH_WSHRDBDR_XMLP_PKG.cf_line_ordered_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id )),WSH_WSHRDBDR_XMLP_PKG.cf_selling_priceformula(wdd.source_line_id)) CF_LINE_ORDERED_AMT, WSH_WSHRDBDR_XMLP_PKG.cf_line_ordered_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id )) CF_LINE_ORDERED_QTY, WSH_WSHRDBDR_XMLP_PKG.cf_line_shipped_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id) CF_LINE_SHIPPED_QTY, WSH_WSHRDBDR_XMLP_PKG.cf_line_item_displayformula(wdd.inventory_item_id, wdd.organization_id, wdd.item_description) CF_LINE_ITEM_DISPLAY, WSH_WSHRDBDR_XMLP_PKG.cf_line_bo_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id) CF_LINE_BO_QTY, /* WSH_WSHRDBDR_XMLP_PKG.cf_line_bo_amtformula( WSH_WSHRDBDR_XMLP_PKG.cf_line_bo_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id), wdd.unit_price) CF_LINE_BO_AMT,*/ WSH_WSHRDBDR_XMLP_PKG.cf_line_bo_amtformula( WSH_WSHRDBDR_XMLP_PKG.cf_line_bo_qtyformula(nvl ( wdd.source_line_set_id , wdd.source_line_id ), wdd.source_header_id, wdd.requested_quantity_uom, wdd.src_requested_quantity_uom, wdd.inventory_item_id),WSH_WSHRDBDR_XMLP_PKG.cf_selling_priceformula(wdd.source_line_id)) CF_LINE_BO_AMT, WSH_WSHRDBDR_XMLP_PKG.cf_days_lateformula(WSH_WSHRDBDR_XMLP_PKG.cf_promise_dateformula(wdd.source_line_id)) CF_days_late, WSH_WSHRDBDR_XMLP_PKG.cf_promise_dateformula(wdd.source_line_id) CF_promise_date, WSH_WSHRDBDR_XMLP_PKG.cf_item_displayformula(wdd.inventory_item_id, wdd.organization_id, wdd.item_description) CF_ITEM_DISPLAY, WSH_WSHRDBDR_XMLP_PKG.cf_selling_priceformula(wdd.source_line_id) CF_selling_price from org_organization_definitions ood, hz_parties party, hz_cust_accounts cust_acct, &lp_item_from &lp_country_from wsh_delivery_details wdd, mtl_system_items_vl si where wdd.inventory_item_id = si.inventory_item_id (+) and wdd.organization_id = si.organization_id and wdd.released_status = 'B' and wdd.replenishment_status is null -- bug#6689448 ( replenishment project) and cust_acct.party_id = party.party_id and wdd.customer_id = cust_acct.cust_account_id and wdd.organization_id = ood.organization_id and wdd.source_code = :P_SOURCE_SYSTEM &lp_item_id &lp_item_where -- &lp_inventory &lp_header_number &lp_order_type &lp_customer &lp_warehouse &lp_created_by &lp_country_where -- &lp_source_code group by wdd.currency_code, wdd.inventory_item_id, wdd.date_requested, substrb(party.party_name,1,50), ood.organization_name, wdd.source_header_number, wdd.source_header_id, cust_acct.account_number, wdd.source_line_id, wdd.src_requested_quantity, wdd.src_requested_quantity_uom, wdd.source_line_number, wdd.top_model_line_id, wdd.inventory_item_id, wdd.item_description, wdd.source_code, wdd.shipment_priority_code, wdd.requested_quantity_uom, wdd.date_scheduled, wdd.organization_id, wdd.source_line_set_id, &rp_item_flex_all_seg ORDER BY 1 ASC,5 ASC,23 ASC,24 ASC,9 ASC,8 ASC,6 ASC,18 ASC,2 ASC,12 ASC,4 ASC , wdd.currency_code , &LP_ORDER_BY Y WSH WSHRDBDR_XML AR WSH تقرير تفاصيل المتأخرات (بتنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل المتأخرات Application: تنفيذ الشحن Source: تقرير تفاصيل المتأخرات (بتنسيق XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG D WSH Nachlieferungen - Details Imported from BI Publisher Description: Nachlieferungen - Details Application: Shipping Execution Source: Nachlieferungen - Details (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG E WSH Informe de Detalle de Pedidos No Satisfechos Imported from BI Publisher Description: Informe Detalle de Pedidos No Satisfechos Application: Shipping Execution Source: Informe de Detalle de Pedidos No Satisfechos (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG F WSH Etat Détail des reliquats Imported from BI Publisher Description: Etat Détail des reliquats Application: Shipping Execution Source: Etat Détail des reliquats (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG I WSH Rapporto Dettagli ordini inevasi Imported from BI Publisher Description: Rapporto Dettagli ordini inevasi Application: Shipping Execution Source: Rapporto Dettagli ordini inevasi (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG JA WSH バックオーダー詳細レポート Imported from BI Publisher Description: バックオーダー詳細レポート Application: Shipping Execution Source: バックオーダー詳細レポート(XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG KO WSH 미납주문 상세내역 보고서 Imported from BI Publisher Description: 미납주문 상세내역 보고서 Application: Shipping Execution Source: 미납주문 상세내역 보고서(XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG PTB WSH Relatório Detalhado de Backorder Imported from BI Publisher Description: Relatório Detalhado de Backorder Application: Execução da Entrega Source: Relatório Detalhado de Backorder (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG RU WSH Подробный отчет об отложенных заказах Imported from BI Publisher Description: Подробный отчет об отложенных заказах Application: Выполнение отгрузки Source: Подробный отчет об отложенных заказах (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG S WSH Restorderdetaljer Imported from BI Publisher Description: Restorderdetaljer Application: Shipping Execution Source: Restorderdetaljer (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG TR WSH Sipariş Bakiyesi Detay Raporu Imported from BI Publisher Description: Sipariş Bakiyesi Detay Raporu Application: Sevkiyat Yönetimi Source: Sipariş Bakiyesi Detay Raporu (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG US WSH Backorder Detail Imported from BI Publisher Description: Backorder Detail Report Application: Shipping Execution Source: Backorder Detail Report (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG ZHS WSH 延交订单明细报表 Imported from BI Publisher Description: 延交订单明细报表 Application: 发运管理系统 Source: 延交订单明细报表 (XML) Short Name: WSHRDBDR_XML DB package: WSH_WSHRDBDR_XMLP_PKG BI Publisher &lp_country_from &lp_country_where &lp_created_by &lp_customer &lp_header_number &lp_inventory &lp_item_from &lp_item_id &lp_item_where &lp_order_by &lp_order_type &lp_source_code &lp_warehouse &rp_item_flex_all_seg :cs_count_duom :cs_count_sort_enabled :cs_sum_duom :cs_sum_sort_enabled :dlate :lp_country_from :lp_country_where :lp_created_by :lp_customer :lp_header_number :lp_inventory :lp_item_flex_all_seg :lp_item_flex_all_seg_high :lp_item_from :lp_item_id :lp_item_where :lp_order_by :lp_order_category :lp_order_type :lp_sort_by :lp_source_code :lp_structure_num :lp_warehouse :lp_warehouse_group :lp_warehouse_id_select :lp_warehouse_name_select :p_conc_request_id :p_created_by_id :p_customer_id :p_header_id_high :p_header_id_low :p_item_cate_set_id :p_item_category_id :p_item_display :p_item_flex_code :p_item_id :p_item_structure_num :p_order_num_high :p_order_num_low :p_organization_id :p_ship_to_country_code :p_sort_by :p_source_system :p_transaction_type_id :rp_category :rp_category_set :rp_customer :rp_data_found :rp_flex_or_desc :rp_item :rp_item_flex_all_seg :rp_item_flex_all_seg_where :rp_order_by :rp_order_num_high :rp_order_num_low :rp_order_range :rp_order_type_name :rp_report_name :rp_sort_by :rp_source_system :rp_sub_title :rp_territory_code :rp_user :rp_user_id :rp_warehouse :rp_warehouse_id 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_source_system LOV Oracle WSH_SRS_SOURCE_SYSTEM Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='SOURCE_SYSTEM' and enabled_flag='Y' and lookup_code not in ('PO','OSP') order by meaning Select meaning from WSH_LOOKUPS where lookup_code = 'OE' and lookup_type = 'SOURCE_SYSTEM' Y AR النظام المصدر النظام المصدر D Herkunftssystem Herkunftssystem E Sistema de Origen Sistema de Origen F Système d'origine Système d'origine I Sistema di origine Sistema di origine JA ソース・システム ソース・システム KO 출처 시스템 출처 시스템 PTB Sistema de Origem Sistema de Origem RU Исходная система Исходная система S Källsystem Källsystem TR Kaynak Sistem Kaynak Sistem US Source System Source System ZHS 源系统 源系统 3 20 :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 仓库 仓库 4 30 :p_item_id Char AR الصنف الصنف D Artikel Artikel E Artículo Artículo F Article Article I Articolo Articolo JA 品目 品目 KO 품목 품목 RU Позиция Позиция S Artikel Artikel TR Kalem Kalem US Item Item ZHS 物品 物品 5 40 :p_item_cate_set_id LOV Oracle WSH_SRS_ITEM_CAT_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by category_set_name AR مجموعة فئات الصنف مجموعة فئات الصنف D ArtikelkategorieSet ArtikelkategorieSet E Juego de Categorías de Artículos Juego de Categorías de Artículos F Jeu de catégories article Jeu de catégories article I Serie categorie articolo Serie categorie articolo JA 品目カテゴリ・セット 品目カテゴリ・セット KO 품목 범주 세트 품목 범주 세트 PTB Conjunto de Categorias do Item Conjunto de Categorias do Item RU Набор категорий позиций Набор категорий позиций S Artikelkategoriuppsättning Artikelkategoriuppsättning TR Kalem Kategori Kümesi Kalem Kategori Kümesi US Item Category Set Item Category Set ZHS 项目类别集 项目类别集 6 50 :p_item_category_id LOV Oracle WSH_SRS_ITEM_CATEGORIES Y select category_id id, description value, null description from mtl_categories where category_id in (select distinct ic.category_id from mtl_item_categories ic where ic.organization_id=:$flex$.wsh_srs_organizations and ic.category_set_id=:$flex$.wsh_srs_item_cat_set) order by description AR فئة الصنف فئة الصنف D Artikelkategorie Artikelkategorie E Categoría de Artículo Categoría de Artículo F Catégorie article Catégorie article I Categoria articolo Categoria articolo JA 品目カテゴリ 品目カテゴリ KO 품목 범주 품목 범주 PTB Categoria do Item Categoria do Item RU Категория позиции Категория позиции S Artikelkategori Artikelkategori TR Kalem Kategorisi Kalem Kategorisi US Item Category Item Category ZHS 物品类别 物品类别 7 60 :p_customer_id LOV Oracle WSH_SRS_CUSTOMERS_NEW Y Y select cust_acct.cust_account_id id, substrb(party.party_name,1,50) value, cust_acct.account_number description from hz_parties party,hz_cust_accounts cust_acct where party.party_id=cust_acct.party_id order by party.party_name AR العميل العميل D Kunde Kunde E Cliente Cliente F Client Client I Cliente Cliente JA 顧客 顧客 KO 고객 고객 PTB Cliente Cliente RU Заказчик Заказчик S Kund Kund TR Müşteri Müşteri US Customer Customer ZHS 客户 客户 8 70 :p_transaction_type_id LOV Oracle WSH_SOURCE_TYPES Y select source_type_id id, source_type_name value, description description from wsh_source_types_v where source_system=:$flex$.wsh_srs_source_system order by value,description AR نوع عنوان المصدر نوع عنوان المصدر D Kopfart Herkunft Kopfart Herkunft E Tipo de Cabecera de Origen Tipo de Cabecera de Origen F Type d'en-tête d'origine Type d'en-tête d'origine I Tipo intestazione origine Tipo intestazione origine JA ソース・ヘッダー・タイプ ソース・ヘッダー・タイプ KO 출처 헤더 유형 출처 헤더 유형 PTB Tipo de Cabeçalho de Origem Tipo de Cabeçalho de Origem RU Тип заголовка источника Тип заголовка источника S Källhuvudtyp Källhuvudtyp TR Kaynak Başlığı Tipi Kaynak Başılığı Tipi US Source Header Type Source Header Type ZHS 来源题头类型 来源题头类型 9 80 :p_order_num_low LOV Oracle WSH_SOURCE_NUMBERS Y select source_number id, source_number value, null description from wsh_source_numbers_v where source_system=:$flex$.wsh_srs_source_system and source_type_id=:$flex$.wsh_source_types order by value,description AR رقم عنوان المصدر من رقم عنوان المصدر من D Kopfnummer Herkunft von Kopfnummer Herkunft von E De Número de Cabecera de Origen De Número de Cabecera de Origen F Numéro d'en-tête d'origine (De) Numéro d'en-tête d'origine (De) I Numero intestazione origine - Da Numero intestazione origine - Da JA ソース・ヘッダー番号:自 ソース・ヘッダー番号:自 KO 출처 헤더 번호: 부터 출처 헤더 번호: 부터 PTB Número do Cabeçalho de Origem - De Número do Cabeçalho de Origem - De RU Номер заголовка источника с Номер заголовка источника с S Källhuvudnummer från Källhuvudnummer från TR İlk Kaynak Başlığı Numarası İlk Kaynak Başlığı Numarası US Source Header Number From Source Header Number From ZHS 来源题头编号自 来源题头编号自 10 90 :p_order_num_high LOV Oracle WSH_SOURCE_NUMBERS Y select source_number id, source_number value, null description from wsh_source_numbers_v where source_system=:$flex$.wsh_srs_source_system and source_type_id=:$flex$.wsh_source_types order by value,description AR رقم عنوان المصدر إلى رقم عنوان المصدر إلى D Kopfnummer Herkunft bis Kopfnummer Herkunft bis E A Número de Cabecera de Origen A Número de Cabecera de Origen F Numéro d'en-tête d'origine (A) Numéro d'en-tête d'origine (A) I Numero intestazione origine - A Numero intestazione origine - A JA ソース・ヘッダー番号:至 ソース・ヘッダー番号:至 KO 출처 헤더 번호: 까지 출처 헤더 번호: 까지 PTB Número do Cabeçalho de Origem - Até Número do Cabeçalho de Origem - Até RU Номер заголовка источника по Номер заголовка источника по S Källhuvudnummer till Källhuvudnummer till TR Son Kaynak Başlığı Numarası Son Kaynak Başlığı Numarası US Source Header Number To Source Header Number To ZHS 来源题头编号至 来源题头编号至 11 100 :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 物料显示 打印库存物料说明或弹性域 12 110 :p_created_by_id LOV Oracle WSH_SRS_USERS Y select user_id id, user_name value, null description from fnd_user order by user_name AR تكوين بواسطة تكوين بواسطة D Erstellt von Erstellt von E Creado por Creado por F Créé par Créé par I Creato da Creato da JA 作成者 作成者 KO 생성자 생성자 PTB Criado por Criado por RU Создано Создано S Skapad av Skapad av TR Oluşturan Oluşturan US Created By Created By ZHS 创建者 创建者 13 120 :p_ship_to_country_code LOV Oracle WSH_SRS_COUNTRIES Y select territory_code id, territory_short_name value, null description from fnd_territories_vl order by territory_short_name AR شحن إلى الدولة شحن إلى الدولة D Zu belieferndes Land Zu belieferndes Land E País de Envío País de Envío F Pays de livraison Pays de livraison I Paese di spedizione Paese di spedizione JA 出荷先国 出荷先国 KO 납품처 국가 납품처 국가 PTB País para Entrega País para Entrega RU Страна получателя товара Страна получателя товара S Leveransadress - land Leveransadress - land TR Sevk Varış Ülkesi Sevk Varış Ülkesi US Ship To Country Ship To Country ZHS 收货方所在国家（地区） 收货方所在国家（地区） 14 130 :p_sort_by LOV Oracle WSH_WSHRDBDR_SORT_BY Y select lookup_code id, meaning value, null description from wsh_lookups where lookup_type='WSH_WSHRDBDR_SORT_BY' and enabled_flag='Y' order by meaning AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Esası Sıralama Esası US Sort By Sort By ZHS 排序依据 排序依据 :$flex$.wsh_source_types Source Header Type Source Header Number From :$flex$.wsh_source_types Source Header Type Source Header Number To :$flex$.wsh_srs_item_cat_set Item Category Set Item Category :$flex$.wsh_srs_organizations Warehouse Item Category :$flex$.wsh_srs_source_system Source System Source Header Number From :$flex$.wsh_srs_source_system Source System Source Header Number To :$flex$.wsh_srs_source_system Source System Source Header Type