Friday 10 May 2013

order management flow tables



Entered
OE_ORDER_HEADERS_ALL
1 record created in header table
OE_ORDER_LINES_ALL
Lines for particular records
OE_PRICE_ADJUSTMENTS
When discount gets applied
OE_ORDER_PRICE_ATTRIBS
If line has price attributes then populated
OE_ORDER_HOLDS_ALL
If any hold applied for order like credit check etc
Booked
OE_ORDER_HEADERS_ALL
Booked_Flag=Y, Order booked.
WSH_DELIVERY_DETAILS
Released_Status Ready to release
Pick Released
WSH_DELIVERY_DETAILS
Released_Status=Y Released to Warehouse (Line has been released to Inventory for processing)
WSH_PICKING_BATCHES
After batch is created for pick release
MTL_RESERVATIONS
This is only soft reservations. No physical movement of stock

Full Transaction
MTL_MATERIAL_TRANSACTIONS
No records in MTL_MATERIAL_TRANSACTIONS
MTL_TXN_REQUEST_HEADERS
MTL_TXN_REQUEST_LINES
WSH_DELIVERY_DETAILS
Released to warehouse
WSH_NEW_DELIVERIES
If Auto-Create is Yes then data populated
WSH_DELIVERY_ASSIGNMENTS
Deliveries get assigned
Pick Confirmed
WSH_DELIVERY_DETAILS
Released_Status=Y Hard Reservations. Picked the stock. Physical movement of stock
Ship Confirmed
WSH_DELIVERY_DETAILS
Released_Status=C ;Shipped ;Delivery Note get printed Delivery assigned to trip stop quantity will be decreased
MTL_MATERIAL_TRANSACTIONS
On the ship confirm form, check Ship all box
WSH_NEW_DELIVERIES
If Defer Interface is checked then OM & inventory not updated. If Defer Interface is not checked: Shipped
OE_ORDER_LINES_ALL
Shipped_Quantity get populated
WSH_DELIVERY_LEGS
1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
OE_ORDER_HEADERS_ALL
If all the lines get shipped then only flag N
Auto Invoice
WSH_DELIVERY_DETAILS
Released_Status=I Need to run workflow background process.
RA_INTERFACE_LINES_ALL
Data will be populated after work flow process.
RA_CUSTOMER_TRX_ALL
After running Auto Invoice Master Program for
RA_CUSTOMER_TRX_LINES_ALL
Specific batch transaction tables get populated

No comments:

Post a Comment