Oracle R12 shipping status query

Oracle R12 shipping status query
wsh_delivery_details RELEASED_STATUS
wsh_new_deliveries STATUS_CODE
Oracle apps shipping status and delivery status

--Delivery status
SELECT STATUS_CODE, meaning, delivery_id
  FROM wsh_new_deliveries wnd, 
       apps.fnd_lookup_values_vl flv
 WHERE     flv.LOOKUP_CODE = wnd.STATUS_CODE
       AND lookup_type = 'DELIVERY_STATUS'
       AND delivery_id = 1000;
       
       
--Shipping status
SELECT RELEASED_STATUS, meaning, delivery_detail_id
  FROM wsh_delivery_details wdd, 
       apps.fnd_lookup_values_vl flv
 WHERE flv.LOOKUP_CODE = wdd.RELEASED_STATUS 
   AND lookup_type = 'PICK_STATUS'
   AND delivery_detail_id = 215353;

Related posts:

• Sales order line status query in Oracle apps
• Query to get price list details in Oracle EBS
• Query to find all APIs of Oracle Apps modules
• Oracle R12 shipping status query
• Query to get customer tax registration details in R12
• Query to get Sales order and lines details in Oracle Apps
• Query to find serial number material transactions details
• Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
• Query to find Sales Orders that are shipped but not invoiced
• Query to get Customer Bank Account Details
• AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
• Query to find shipset and fulfilment set

Upload your own post and refer it anywhere anytime: