Showing posts with label oracle apps om tables. Show all posts
Showing posts with label oracle apps om 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