OA_OE Critical Tables

SO_HEADERS_ALL

Contains order header information

SO_LINES_ALL

Contains order line information

SO_LINE_DETAILS

Stores lower level details about order lines

MTL_SYSTEM_ITEMS

Inventory master file (in version 11.03 only)

MTL_SYSTEM_ITEMS_B

Inventory master file (in version 11i or later only)

SO_PRICE_LISTS

Contains price list definitions, which are included in header data

SO_PRICE_LIST_LINES

Stores actual price for a particular inventory line item along with other details about that item's price

RA_CUSTOMERS

Holds all customer header information

SO_PICKING_BATCHES_ALL

Stores pick list batches, which used for grouping pick lists together

SO_PICKING_HEADERS_ALL

Pick list header information that are associated with orders

SO_PICKING_LINES_ALL

Pick list lines that are associated with SO_LINES

SO_PICKING_LINE_DETAILS

Pick list line details, which include lot locator details for a picklist that is associated with SO_LINE_DETAILS

SO_ORDER_HOLDS_ALL

Used to indicate orders or lines on hold