ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D472BC51A9E05362FB09050512 SELECT det.inventory_item_id c_inv_item_id , &p_customer_item_number c_customer_item_number , fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flex', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') c_item_flex , msi.description c_item_description , det.customer_item_id c_customer_item_id , decode(:P_STANDALONE ,'N', det.source_header_number,nvl(det.reference_number,det.source_header_number)) c_so_number , decode(:P_STANDALONE,'N',det.source_line_number , nvl(det.reference_line_number,det.source_line_number)) c_so_line_number , det.cust_po_number c_po_number , sum ( round(nvl(det.requested_quantity,0),:p_quantity_precision)) c_req_qty , sum (round(nvl(det.requested_quantity2,0), :p_quantity_precision)) c_req_qty2 , det.requested_quantity_uom c_req_qty_uom , det.requested_quantity_uom2 c_req_qty_uom2 , det.src_requested_quantity_uom c_src_req_uom , det.src_requested_quantity_uom2 c_src_req_uom2 , det.requested_quantity_uom2 c_secondary_qty_shipped_uom , det.requested_quantity_uom2 c_secondary_qty_unshipped_uom ,avg( round(nvl(det.src_requested_quantity,0),:p_quantity_precision) )c_src_req_qty ,avg( round(nvl(det.src_requested_quantity2,0),:p_quantity_precision) ) c_src_req_qty2 , sum(round(nvl(det.shipped_quantity,0),:p_quantity_precision) ) c_ship_qty ,sum( round(nvl(det.shipped_quantity2,0),:p_quantity_precision)) c_ship_qty2 ,sum( round(nvl(det.delivered_quantity,0),:p_quantity_precision) ) c_del_qty ,sum( round(nvl(det.src_requested_quantity,0)-nvl(det.shipped_quantity,0)-nvl(det.requested_quantity,0),:p_quantity_precision) )c_back_qty , sum(round(nvl(det.src_requested_quantity2,0)-nvl(det.shipped_quantity2,0)-nvl(det.requested_quantity2,0),:p_quantity_precision) )c_back_qty2 , det.customer_id c_customer_id , det.source_code c_src_code , det.source_header_id c_src_hdr_id , to_char(det.source_header_id) c_src_hdr_chr , det.source_line_id c_src_line_id , det.lot_number c_lot_number , det.preferred_grade c_preferred_grade , det.shipping_instructions c_ship_instructions , det.packing_instructions c_pack_instructions ,det.organization_id c_organization_id ,det.source_header_id attach_order_id ,det.mcc_code c_mcc_code, WSH_WSHRDPAK_XMLP_PKG.cf_item_descriptionformula(msi.description, det.inventory_item_id, det.organization_id) CF_Item_description, WSH_WSHRDPAK_XMLP_PKG.cf_item_numformula(fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flex', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), det.inventory_item_id, :C_DEL_ORG_ID) CF_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_cust_item_numformula(det.customer_item_id) CF_CUST_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_requestor_nameformula(det.source_line_id) CF_requestor_name, WSH_WSHRDPAK_XMLP_PKG.cf_unshipped_qtyformula(det.source_line_id) CF_UNSHIPPED_QTY, WSH_WSHRDPAK_XMLP_PKG.cf_cum_qtyformula(:C_DEL_CUSTOMER_ID, det.customer_id, det.source_line_id) CF_CUM_QTY, WSH_WSHRDPAK_XMLP_PKG.CP_internal_sales_order_p CP_internal_sales_order FROM wsh_delivery_details det , wsh_delivery_assignments_v das , mtl_system_items_vl msi ,mtl_customer_items mci WHERE det.delivery_detail_id=das.delivery_detail_id AND det.container_flag='N' AND das.delivery_id is not null AND das.delivery_id=:c_q2_delivery_id AND det.inventory_item_id is not null &p_organizationid_1 AND msi.organization_id=det.organization_id AND msi.inventory_item_id (+) =det.inventory_item_id AND mci.customer_item_id (+)= det.customer_item_id AND EXISTS (select 'EXISTS' from bom_inventory_components bic where bic.component_item_id = det.inventory_item_id and bic.include_on_ship_docs = 1 and bic.component_sequence_id = ( select component_sequence_id from oe_order_lines_all where line_id = det.source_line_id) and det.top_model_line_id is not null UNION select 'EXISTS' from dual where det.top_model_line_id is null UNION select 'EXISTS' from dual where msi.auto_created_config_flag = 'Y' and det.top_model_line_id is not null UNION select 'EXISTS' from dual where det.top_model_line_id = det.source_line_id UNION select 'EXISTS' from dual where det.top_model_line_id is not null and det.ato_line_id is not null) group by fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_flex', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ,det.inventory_item_id , msi.description ,&p_customer_item_number , det.customer_item_id , decode(:P_STANDALONE ,'N', det.source_header_number,nvl(det.reference_number,det.source_header_number)) , decode(:P_STANDALONE,'N',det.source_line_number , nvl(det.reference_line_number,det.source_line_number)) , det.cust_po_number , det.requested_quantity_uom , det.requested_quantity_uom2 , det.src_requested_quantity_uom , det.src_requested_quantity_uom2 , det.customer_id , det.source_code , det.source_header_id , det.source_line_id , det.lot_number , det.preferred_grade , det.shipping_instructions , det.packing_instructions , det.organization_id , det.mcc_code UNION SELECT det.inventory_item_id c_inv_item_id , NULL c_customer_item_number , NULL c_item_flex , det.item_description c_item_description , det.customer_item_id c_customer_item_id --standalone changes , decode(:P_STANDALONE ,'N', det.source_header_number,nvl(det.reference_number,det.source_header_number)) c_so_number , decode(:P_STANDALONE,'N',det.source_line_number , nvl(det.reference_line_number,det.source_line_number)) c_so_line_number , det.cust_po_number c_po_number , sum ( round(nvl(det.requested_quantity,0),:p_quantity_precision)) c_req_qty , sum (round(nvl(det.requested_quantity2,0), :p_quantity_precision)) c_req_qty2 , det.requested_quantity_uom c_req_qty_uom , det.requested_quantity_uom2 c_req_qty_uom2 , det.src_requested_quantity_uom c_src_req_uom , det.src_requested_quantity_uom2 c_src_req_uom2 , det.requested_quantity_uom2 c_secondary_qty_shipped_uom , det.requested_quantity_uom2 c_secondary_qty_unshipped_uom ,avg( round(nvl(det.src_requested_quantity,0),:p_quantity_precision) )c_src_req_qty ,avg( round(nvl(det.src_requested_quantity2,0),:p_quantity_precision) ) c_src_req_qty2 , sum(round(nvl(det.shipped_quantity,0),:p_quantity_precision) ) c_ship_qty ,sum( round(nvl(det.shipped_quantity2,0),:p_quantity_precision)) c_ship_qty2 ,sum( round(nvl(det.delivered_quantity,0),:p_quantity_precision) ) c_del_qty ,sum( round(nvl(det.src_requested_quantity,0)-nvl(det.shipped_quantity,0)-nvl(det.requested_quantity,0),:p_quantity_precision) )c_back_qty , sum(round(nvl(det.src_requested_quantity2,0)-nvl(det.shipped_quantity2,0)-nvl(det.requested_quantity2,0),:p_quantity_precision) )c_back_qty2 , det.customer_id c_customer_id , det.source_code c_src_code , det.source_header_id c_src_hdr_id , to_char(det.source_header_id) c_src_hdr_chr , det.source_line_id c_src_line_id , det.lot_number c_lot_number , det.preferred_grade c_preferred_grade , det.shipping_instructions c_ship_instructions , det.packing_instructions c_pack_instructions ,det.organization_id c_organization_id ,det.source_header_id attach_order_id ,det.mcc_code c_mcc_code, WSH_WSHRDPAK_XMLP_PKG.cf_item_descriptionformula(NULL, det.inventory_item_id, det.organization_id) CF_Item_description, WSH_WSHRDPAK_XMLP_PKG.cf_item_numformula(NULL, det.inventory_item_id, :C_DEL_ORG_ID) CF_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_cust_item_numformula(det.customer_item_id) CF_CUST_ITEM_NUM, WSH_WSHRDPAK_XMLP_PKG.cf_requestor_nameformula(det.source_line_id) CF_requestor_name, WSH_WSHRDPAK_XMLP_PKG.cf_unshipped_qtyformula(det.source_line_id) CF_UNSHIPPED_QTY, WSH_WSHRDPAK_XMLP_PKG.cf_cum_qtyformula(:C_DEL_CUSTOMER_ID, det.customer_id, det.source_line_id) CF_CUM_QTY, WSH_WSHRDPAK_XMLP_PKG.CP_internal_sales_order_p CP_internal_sales_order FROM wsh_delivery_details det , wsh_delivery_assignments_v das WHERE det.delivery_detail_id=das.delivery_detail_id AND det.container_flag='N' AND das.delivery_id is not null AND das.delivery_id=:c_q2_delivery_id &p_organizationid_1 AND det.inventory_item_id is null group by NULL ,det.inventory_item_id , det.item_description , det.customer_item_id --standalone , decode(:P_STANDALONE ,'N', det.source_header_number,nvl(det.reference_number,det.source_header_number)) , decode(:P_STANDALONE,'N',det.source_line_number , nvl(det.reference_line_number,det.source_line_number)) , det.cust_po_number , det.requested_quantity_uom , det.requested_quantity_uom2 , det.src_requested_quantity_uom , det.src_requested_quantity_uom2 , det.customer_id , det.source_code , det.source_header_id , det.source_line_id , det.lot_number , det.preferred_grade , det.shipping_instructions , det.packing_instructions , det.organization_id ,det.mcc_code ORDER BY 27 ASC,26 ASC,2 ASC,3 ASC,4 ASC Y WSH WSHRDPAK_XML AR WSH تقرير بطاقة التعبئة (بتنسيق XML) Imported from BI Publisher Description: تقرير بطاقة التعبئة Application: تنفيذ الشحن Source: تقرير بطاقة التعبئة (بتنسيق XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG D WSH Packzettel Imported from BI Publisher Description: Packzettel Application: Shipping Execution Source: Packzettel (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG E WSH Informe Nota de Embalaje Imported from BI Publisher Description: Informe Nota de Embalaje Application: Shipping Execution Source: Informe Nota de Embalaje (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG F WSH Etat des bordereaux d'expédition Imported from BI Publisher Description: Etat des bordereaux d'expédition Application: Shipping Execution Source: Etat des bordereaux d'expédition (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG I WSH Rapporto Documento di trasporto Imported from BI Publisher Description: Rapporto documento di trasporto Application: Shipping Execution Source: Rapporto Documento di trasporto (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG JA WSH 梱包伝票レポート Imported from BI Publisher Description: 梱包伝票レポート Application: Shipping Execution Source: 梱包伝票レポート(XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG KO WSH 포장 명세 보고서 Imported from BI Publisher Description: 포장 명세 보고서 Application: Shipping Execution Source: 포장 명세 보고서(XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG PTB WSH Relatório de Romaneio Imported from BI Publisher Description: Relatório do Romaneio Application: Execução da Entrega Source: Relatório de Romaneio (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG RU WSH Упаковочный лист Imported from BI Publisher Description: Упаковочный лист Application: Выполнение отгрузки Source: Упаковочный лист (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG S WSH Följesedelsrapport Imported from BI Publisher Description: Följesedelsrapport Application: Shipping Execution Source: Följesedelsrapport (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG TR WSH Paketleme Fişi Raporu Imported from BI Publisher Description: Paketleme Fişi Raporu Application: Sevkiyat Yönetimi Source: Paketleme Fişi Raporu (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG US WSH Packing Slip Imported from BI Publisher Description: Packing Slip Report Application: Shipping Execution Source: Packing Slip Report (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG ZHS WSH 装箱单报表 Imported from BI Publisher Description: 装箱单报表 Application: 发运管理系统 Source: 装箱单报表 (XML) Short Name: WSHRDPAK_XML DB package: WSH_WSHRDPAK_XMLP_PKG BI Publisher &p_customer_item_number &p_organizationid_1 :c_del_customer_id :c_del_org_id :c_q2_delivery_id :cp_bill_address_line_1 :cp_bill_address_line_2 :cp_bill_address_line_3 :cp_bill_address_line_4 :cp_bill_country :cp_bill_postal_code :cp_bill_region :cp_bill_to_contact_id :cp_bill_town_or_city :cp_draft_or_final :cp_internal_sales_order :cp_print_date :cp_rlm_print_cum_data :cp_ship_to_contact_id :cp_source_code :cp_warehouse_name :p_conc_request_id :p_customer_item_number :p_delivery_date_high :p_delivery_date_low :p_delivery_id :p_display_unshipped :p_doc_type :p_entity_name_oed :p_entity_name_oeh :p_entity_name_wdd :p_entity_name_wnd :p_freight_code :p_func_name :p_item_display :p_item_flex :p_order_by :p_organization_id :p_organizationid :p_organizationid_1 :p_print_cust_item :p_print_mode :p_quantity_precision :p_sort :p_standalone :p_tax_vat_flag 1 -20 :p_quantity_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점 이하 자리수 수량 소수점 이하 자리수 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar Duyarlılığı US Quantity Precision Quantity Precision ZHS 数量精确度 数量精确度 2 10 :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') Y 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 仓库 仓库 3 20 :p_delivery_id LOV Oracle WSH_MGD_SRS_PACK_DELIVERIES Y select delivery_id id, delivery_name value, null description from wsh_pack_slip_v where organization_id=:$flex$.wsh_srs_organizations and exists (select 1 from wsh_delivery_assignments wda where wda.delivery_id=wsh_pack_slip_v.delivery_id) order by delivery_name Y AR اسم التسليم اسم التسليم D Auslieferungsbezeichnung Auslieferungsbezeichnung E Nombre de Entrega Nombre de Entrega F Code livraison Code livraison I Nome consegna Nome consegna JA 搬送名 搬送名 KO 납품명 납품명 PTB Nome da Distribuição Nome da Distribuição RU Имя доставки Имя доставки S Leveransnamn Leveransnamn TR Teslimat Adı Teslimat Adı US Delivery Name Delivery Name ZHS 交货名称 交货名称 4 30 :p_print_cust_item LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'N' Y AR طباعة صنف العميل طباعة صنف العميل D Kundenartikel drucken Kundenartikel drucken E Imprimir Artículo del Cliente Imprimir Artículo del Cliente F Imprimer article client Imprimer article client I Stampa articolo cliente Stampa articolo cliente JA 顧客品目の印刷 顧客品目の印刷 KO 고객 품목 인쇄 고객 품목 인쇄 PTB Imprimir Item do Cliente Imprimir Item do Cliente RU Печать позиции заказчика Печать позиции заказчика S Skriv ut kundartikel Skriv ut kundartikel TR Müşteri Envanter Kalemi Yadır Müşteri Envanter Kalemi Yadır US Print Customer Item Print Customer Item ZHS 打印客户物料 打印客户物料 5 40 :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 Option Artikelanzeige E Presentación del Artículo Opción de Presentación de Artículo F Affichage article Option d'affichage d'article I Visualizzazione articolo Opzione visualizzazione articolo JA 品目表示 品目表示オプション KO 품목 표시 품목 표시 옵션 PTB Exibição do Item Opção de Exibição do Item RU Вывод позиции Режим вывода позиции S Artikelvisning Artikelformatalternativ TR Kalem Görüntüleme Envanter Kalemi Görünüm Seçeneği US Item Display Item Display Option ZHS 物料显示 项显示选项 6 50 :p_print_mode LOV Oracle WSH_MGD_PACK_MODE Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='PACK_MODE' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'PACK_MODE' and lookup_code = 'DRAFT' Y AR طور الطباعة طور الطباعة D Druckmodus Druckmodus E Modo de Impresión Modo de Impresión F Mode d'impression Mode d'impression I Modalità di stampa Modalità di stampa JA モードの印刷 モードの印刷 KO 인쇄 모드 인쇄 모드 PTB Modo de Impressão Modo de Impressão RU Режим печати Режим печати S Utskriftsläge Utskriftsläge TR Yazdırma Modu Yazdırma Modu US Print Mode Print Mode ZHS 打印模式 打印模式 7 60 :p_sort LOV Oracle WSH_MGD_PACK_SORT Y select lookup_code id, meaning value, description description from wsh_lookups where lookup_type='PACK_SORT' and enabled_flag='Y' order by meaning select meaning from wsh_lookups where lookup_type = 'PACK_SORT' and lookup_code = 'INV' Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Ordenación F Tri par Option de tri I Ordina per Opzione di ordinamento JA ソート・キー ソート・オプション KO 정렬 기준 정렬 옵션 PTB Classificar por Opção de Classificação RU Сортировка Параметр сортировки S Sortera efter Sorteringsalternativ TR Sıralama Bazı Sıralama Seçeneği US Sort by Sort Option ZHS 排序依据 排序选项 8 70 :p_delivery_date_low Date AR تاريخ التسليم (من) تاريخ التسليم (من) D Von Auslieferungsdatum Von Auslieferungsdatum E De Fecha de Entrega De Fecha de Entrega F Date de livraison (Du) Date de livraison (Du) I Data consegna (minimo) Data consegna (minimo) JA 搬送日 (自) 搬送日 (自) KO 납품 일자(하한) 납품 일자(하한) PTB Data da Distribuição (Inferior) Data da Distribuição (Inferior) RU Дата доставки с Дата доставки с S Leveransdatum (från) Leveransdatum (från) TR Teslimat Tarihi (Alt Değer) Teslimat Tarihi (Alt Değer) US Delivery Date (Low) Delivery Date (Low) ZHS 交货日期（下限） 交货日期（下限） 9 80 :p_delivery_date_high Date AR تاريخ التسليم (إلى) تاريخ التسليم (إلى) D Bis Auslieferungsdatum Bis Auslieferungsdatum E A Fecha de Entrega A Fecha de Entrega F Date de livraison (Au) Date de livraison (Au) I Data consegna (massimo) Data consegna (massimo) JA 搬送日 (至) 搬送日 (至) KO 납품 일자(상한) 납품 일자(상한) PTB Data da Distribuição (Superior) Data da Distribuição (Superior) RU Дата доставки по Дата доставки по S Leveransdatum (till) Leveransdatum (till) TR Teslimat Tarihi (Üst Değer) Teslimat Tarihi (Üst Değer) US Delivery Date (High) Delivery Date (High) ZHS 交货日期（上限） 交货日期（上限） 10 90 :p_display_unshipped LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR عرض الأصناف غير المشحونة عرض الأصناف غير المشحونة D Nicht gelieferte Artikel anzeigen Nicht gelieferte Artikel anzeigen E Mostrar Artículos sin Enviar Mostrar Artículos sin Enviar F Afficher les articles non livrés Afficher les articles non livrés I Visualizza articoli non spediti Visualizza articoli non spediti JA 未出荷品目の表示 未出荷品目の表示 KO 미출하 품목 표시 미출하 품목 표시 PTB Itens de Exibição dos Dias-Limite Itens de Exibição dos Dias-Limite RU Вывод неотгруженных позиций Вывод неотгруженных позиций S Visa artiklar som inte har levererats Visa artiklar som inte har levererats TR Sevkedilmeyen Kalemleri Göster Sevkedilmeyen Kalemleri Göster US Display Unshipped Items Display Unshipped Items ZHS 显示未发运项目 显示未发运项目 :$flex$.wsh_srs_organizations Warehouse Delivery Name