Showing posts with label order management tables. Show all posts
Showing posts with label order management tables. Show all posts

Oracle Apps Order Management Tables


Check the blog page: Oracle Apps Order Management setups & flows

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