Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "example Analysis of EBS OM Shipping status wsh_delivery_details.RELEASED_STATUS", which is easy to understand and clear. I hope it can help you solve your doubts. Let me lead you to study and learn the article "sample Analysis of EBS OM Shipping status wsh_delivery_details.RELEASED_STATUS".

The wsh_delivery_details table is used to store the shipping details of the items that record the sales order. The field RELEASED_STATUS identifies the status of the shipment, which usually has a value of RMagneSmeny.

Check the meaning of this field through a script:

SELECT Lookup_Type, Lookup_Code, Meaning, Description, View_Application_Id, Decode (View_Application_Id, 660, 'ONT', 665,' WSH', 201, 'PO', 401,' INV', 200 'AP', 222,101AR', 101,' GL', 661, 'QP', 0,' FND', 702, 'BOM', 140,' OFA' 700,' MFG') Application FROM Apps.Fnd_Lookup_Values Lv WHERE LANGUAGE = Userenv ('LANG')-- AND View_Application_Id = 665 AND Security_Group_Id = 0 AND Lookup_Type =' PICK_STATUS' ORDER BY 1,2,5

The results are as follows:

LOOKUP_TYPELOOKUP_CODEMEANINGDESCRIPTIONVIEW_APPLICATION_IDAPPLICATIONPICK_STATUSB delayed delivery failed allocation line in inventory management system 665WSHPICK_STATUSC shipped run 665WSHPICK_STATUSD cancelled line 665WSHPICK_STATUSE requested replenishment line completed replenishment line completed supplementary 665WSHPICK_STATUSI connected sending line and connected to Oracle Order Management and Oracle Inventory. 665WSHPICK_STATUSK has planned to ship directly the X terminal line has been planned 665WSHPICK_STATUSL has closed the receiving bank 665WSHPICK_STATUSN not ready to issue 665WSHPICK_STATUSP has cleared the line from the source system 665WSHPICK_STATUSR ready to release 665WSHPICK_STATUSS has been issued to the warehouse has sent the line to the inventory management system for processing 665WSHPICK_STATUSX is not suitable for picking warehouse to issue 665WSHPICK_STATUSY Batch shipment / confirm that the inventory management system has picked up the warehouse and run it wholesale. 665WSH above is all the contents of the article "sample Analysis of EBS OM Shipping status wsh_delivery_details.RELEASED_STATUS". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.