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