OA_OM Critical Tables

OE_ORDER_HEADERS_ALL

Contains order header information

OE_ORDER_LINES_ALL

Contains order line information

OE_ORDER_HOLDS_ALL

Stores on-hold order and line information and the link to hold sources and releases

OE_TRANSACTION_TYPES_ALL

Stores information about order and line transaction types

OE_WORKFLOW_ASSIGNMENTS

Associates assignments to order types and line types.

OE_PC_VTMPLTS

Stores the constraint validation templates used in constraint conditions

OE_PC_RSETS

Stores the constraint record sets. Constraint conditions can be built to validate against any or all records in this record set.

OE_AK_OBJECTS_EXT

Contains extension tables to AK_OBJECTS to store additional data

OE_AK_OBJ_ATTR_EXT

Contains extension tables to AK Object Attributes to store additional data

OE_ORDER_SOURCES

Contains Feeder System Names that create orders in OM tables

MTL_SYSTEM_ITEMS

Inventory master file (in version 11.03 only)

MTL_SYSTEM_ITEMS_B

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

QP_LIST_LINES

Stores all list lines for lists in QP_LIST_HEADERS_B

QP_LIST_HEADERS_B

Stores the header information for all lists

RA_CUSTOMERS

Holds all customer header information

RA_SITE_USES_ALL

Hold information about the site uses

OE_DROP_SHIP_SOURCES

Stores relationship between order lines, associated Oracle purchasing requisitions and Oracle purchasing purchase orders

RCV_SHIPMENT_LINES

Stores receiving shipment information

MTL_RELATED_ITEMS

Master file of inventory definitions