Pick release tables in oracle apps

Pick release tables in oracle apps

In this post , We will be discussing about the pick release tables in oracle apps. We do pick release the sales order when we want to request the material from Inventory for Shipping. Pick release internally create the Move order request for the FG inventory item from FGI Sub Inventory to Staging Sub inventory in oracle apps. When any sales order shipment pick release, we do get this information in wsh_delivery_details table. As such, there is no specific pick release tables in oracle apps but I will try to share some of the important pick release tables which do parts in the Pick release process in oracle apps.

Pick release Process tables in oracle apps

1.WSH_DELIVERY_DETAILS

2.WSH_NEW_DELIVERIES

3. MTL_TXN_REQUEST_HEADERS

4. MTL_TXN_REQUEST_LINES

WSH_DELIVERY_DETAILS :-

To find out the Pick release sales order lines or shipments , we need to use this table wsh_delivery_details using column Released_status=’S’. So the Delivery lines having Released_status=’S’ will be the pick released sales order lines in oracle apps. Here below is the Released_status short code values which do store in the wsh_delivery_details table. Using Released_status, we can identify the status of the current shipment in oracle apps.

B: Back ordered- Line failed to be allocated in Inventory
C: Shipped -Line has been shipped
D: Cancelled -Line is Cancelled
N: Not Ready for Release -Line is not ready to be released
R: Ready to Release: Line is ready to be released
S: Released to Warehouse: Line has been released to Inventory for processing
X: Not Applicable- Line is not applicable for Pick Release
Y: Staged- Line has been picked and staged by Inventory

SQL Query using pick release tables in oracle apps

select A3.* from apps.WSH_DELIVERY_DETAILS A1,

APPS.MTL_TXN_REQUEST_LINES A2,

MTL_TXN_REQUEST_HEADERS A3

WHERE A1.MOVE_ORDER_LINE_ID=A2.LINE_ID

AND A2.HEADER_ID=A3.HEADER_ID