Oracle R12 shipping status query

•By admin

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

SQL Querysql
1--Delivery status
2SELECT STATUS_CODE, meaning, delivery_id
3  FROM wsh_new_deliveries wnd, 
4       apps.fnd_lookup_values_vl flv
5 WHERE     flv.LOOKUP_CODE = wnd.STATUS_CODE
6       AND lookup_type = 'DELIVERY_STATUS'
7       AND delivery_id = 1000;
8       
9       
10--Shipping status
11SELECT RELEASED_STATUS, meaning, delivery_detail_id
12  FROM wsh_delivery_details wdd, 
13       apps.fnd_lookup_values_vl flv
14 WHERE flv.LOOKUP_CODE = wdd.RELEASED_STATUS 
15   AND lookup_type = 'PICK_STATUS'
16   AND delivery_detail_id = 215353;