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
|
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
|
Friday, 10 May 2013
order management flow tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment