ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F5403869E053B46B63588994Y SELECT wnd.organization_id, wnd.delivery_id deliv, wnd.name del_name, wnd.creation_date credate, wsh_util_core.get_location_description(wnd.ultimate_dropoff_location_id, 'NEW UI CODE') ship_to, wsh_util_core.get_location_description(wnd.intmed_ship_to_location_id, 'NEW UI CODE') int_med_ship_to, wsh_util_core.derive_shipment_priority(wnd.delivery_id) as shippri, wdd.delivery_detail_id, wdd.requested_quantity, decode(wdd.released_status,'Y',nvl(wdd.picked_quantity,wdd.requested_quantity),NULL) picked_qty, wdd.shipped_quantity, wdd.source_header_number, wdd.batch_id, wdd.container_flag, decode(wdd.inventory_item_id, NULL, decode(:P_ITEM_DISPLAY,'D',wdd.item_description,'F',msik.concatenated_segments, msik.concatenated_segments||' '||wdd.item_description), decode(:P_ITEM_DISPLAY,'D',msi.description,'F',msik.concatenated_segments, msik.concatenated_segments||' '||msi.description) ) item_description, wdd.inventory_item_id, wpb.name batchname, wpb.creation_date reldate, msi.organization_id, msik.organization_id, hca.account_number customer, mp.organization_code, flv.meaning as shipmeth, wl.meaning as srcys, &F_SORT_SELECT, WSH_WSHRDOPN_XMLP_PKG.cf_shipment_priorityformula(wsh_util_core.derive_shipment_priority ( wnd.delivery_id )) CF_shipment_priority, WSH_WSHRDOPN_XMLP_PKG.cf_lpnformula(wdd.container_flag) CF_CONTAINER_FLAG FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda, wsh_delivery_details wdd, wsh_picking_batches wpb , mtl_system_items_vl msi, mtl_system_items_kfv msik, wsh_lookups wl, ( SELECT cust_acct.cust_account_id, 'C' consignee_flag, cust_acct.account_number account_number FROM hz_cust_accounts cust_acct UNION SELECT pv.vendor_id cust_account_id, 'V' consignee_flag, pv.segment1 account_number FROM po_vendors pv ) hca, mtl_parameters mp, fnd_lookup_values_vl flv WHERE wnd.status_code IN ('OP', 'SR', 'SC', 'SA') AND wda.delivery_id = wnd.delivery_id AND wda.delivery_id IS NOT NULL AND wda.delivery_detail_id = wdd.delivery_detail_id AND wdd.batch_id = wpb.batch_id(+) AND wdd.organization_id = msi.organization_id(+) AND wdd.inventory_item_id = msi.inventory_item_id(+) AND wdd.organization_id = msik.organization_id(+) AND wdd.inventory_item_id = msik.inventory_item_id(+) AND wdd.source_code = wl.lookup_code AND wl.lookup_type = 'SOURCE_SYSTEM' AND wnd.customer_id = hca.cust_account_id(+) AND nvl(wnd.consignee_flag,'C') = hca.consignee_flag(+) AND wnd.organization_id = mp.organization_id(+) AND nvl(wnd.shipment_direction, 'O') IN ('O', 'IO') AND wnd.delivery_type = 'STANDARD' AND wdd.container_flag IN ('N', 'Y') AND wdd.organization_id = :p_organization_id AND flv.lookup_type(+) = 'SHIP_METHOD' AND flv.lookup_code(+) = wnd.ship_method_code AND flv.view_application_id(+) = 3 &F_WHERE order by 19 ASC,22 ASC,7 ASC,2 ASC,18 ASC,4 ASC,21 ASC,5 ASC,6 ASC,3 ASC,23 ASC,24 ASC,12 ASC ,&F_SORT_ORDER WSH WSHRDOPN_XML AR WSH تقرير عمليات التسليم المفتوحة (بتنسيق XML) Application: تنفيذ الشحن Source: تقرير عمليات التسليم المفتوحة (بتنسيق XML) Short Name: WSHRDOPN_XML DB package: WSH_WSHRDOPN_XMLP_PKG D WSH Offene Auslieferungen Application: Shipping Execution Source: Offene Auslieferungen (XML) Short Name: WSHRDOPN_XML DB package: WSH_WSHRDOPN_XMLP_PKG F WSH Etat Livraisons en cours Application: Shipping Execution Source: Etat Livraisons en cours (XML) Short Name: WSHRDOPN_XML DB package: WSH_WSHRDOPN_XMLP_PKG US WSH Open Deliveries Application: Shipping Execution Source: Open Deliveries Report (XML) Short Name: WSHRDOPN_XML DB package: WSH_WSHRDOPN_XMLP_PKG ZHS WSH 打开交货报表 Application: 发运管理系统 Source: 打开交货报表 (XML) Short Name: WSHRDOPN_XML DB package: WSH_WSHRDOPN_XMLP_PKG BI Publisher &f_sort_order &f_sort_select &f_where :cp_p_batch_no :cp_p_customer :cp_p_from_creation_date :cp_p_item_display :cp_p_item_no :cp_p_ship_method :cp_p_shipto_location :cp_p_sort_order :cp_p_to_creation_date :cp_temp :cp_warehouse_name :cp_whse_longname :f_sort_order :f_sort_select :f_where :p_batch_number :p_conc_request_id :p_customer_id :p_from_creation_date :p_item_display :p_item_id :p_organization_id :p_ship_method_code :p_ship_to :p_sort_by :p_to_creation_date 1 10 :p_batch_number LOV Oracle WSH_SRS_MOVE_ORDERS Y select request_number id, request_number value, null description from mtl_txn_request_headers order by request_number AR اسم المجموعة D Stapelbezeichnung F Nom du lot US Batch Name ZHS 批名 2 20 :p_customer_id LOV Oracle WSH_SRS_CONSIGNEES Y Y select consignee_id id, party_name value, customer_number description from wsh_consignees_v order by value,description AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称 3 30 :p_from_creation_date Date AR تاريخ التكوين (من) D Erstellungsdatum (Von) F Date de création - Du US Creation Date(Low) ZHS 创建日期（下限） 4 40 :p_to_creation_date Date AR تاريخ التكوين (إلى) D Erstellungsdatum (Bis) F Date de création - Au US Creation Date(High) ZHS 创建日期（上限） 5 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 F Affichage article US Item Display ZHS 物料显示 6 60 :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 F Entrepôt US Warehouse ZHS 仓库 7 70 :p_ship_method_code LOV Oracle WSH_SRS_FREIGHT_CARRIER Y Y select lookup_code id, meaning value, description description from fnd_lookup_values_vl where view_application_id=3 and lookup_type='SHIP_METHOD' and exists (select 1 from wsh_carrier_services wcs,wsh_carriers wc where wcs.ship_method_code=lookup_code and wcs.carrier_id=wc.carrier_id and nvl(wc.generic_flag,'N')='N') order by lookup_code AR طريقة الشحن D Versandart F Mode d'expédition US Ship Method ZHS 发运方法 8 80 :p_ship_to LOV Oracle WSH_SRS_LOCATIONS_ALL Y select wsh_location_id id, ui_short_location_code value, ui_location_code description from wsh_locations_v order by ui_short_location_code AR شحن إلى D Liefern an F Livraison US Ship To ZHS 收货方 9 90 :p_sort_by LOV Oracle WSH_OPN_SORT_BY Y select lookup_code id, meaning value, null description from wsh_lookups where lookup_type='OPN_SORT_BY' order by lookup_code select meaning from wsh_lookups where lookup_type = 'OPN_SORT_BY' and lookup_code ='D' Y AR ترتيب الفرز D Sortierfolge F Ordre de tri US Sort Order ZHS 排序顺序