Oracle R12 Order Management key table details & descriptions

Oracle R12 Order Management key table details & descriptions

Entered
OE_ORDER_HEADERS_ALL	This table records the sale order header details
OE_ORDER_LINES_ALL	This table records the sale order line details
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
Full Transaction
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

Customer Information
HZ_PARTIES	This table stores basic information about customers
HZ_PARTY_SITES	This table links a party (HZ_PARTIES)and a location (HZ_LOCATIONS) and stores locations-Specific party information such as a person’s mail etc.
HZ_LOCATIONS	This table stores information about an address & provides physical location information about parties and customer accounts.
HZ_CUST_ACCOUNTS	This table stores the customer’s account number
HZ_CUST_ACCT_SITES_ALL	This table stores all customer account sites across all operating units. Customer account sites are addresses, for customer accounts, where the deploying company does business with its customers.
HZ_CUST_SITE_USES_ALL	This table stores business purposes assigned to customer account sites. Each customer account site can have one or more purposes.
RA_CUSTOMERS	This table stores Customer Name, Number & ID
Price Details
QP_LIST_HEADERS_B	This table stores the header information for all Price lists.
QP_LIST_LINES	This table stores the line information for all Price lists.
Items On Hand Qty
MTL_ONHAND_QUANTITIES	To check On Hand Qty Items.
Payment Terms
RA_TERMS	Payment terms
Sales Order Holds
OE_HOLD_DEFINITIONS	This table stores information about hold name and its validity period
OE_HOLD_AUTHORIZATIONS	This table stores information about who has the authority to apply and release holds.
OE_HOLD_SOURCES_ALL	This table stores information of the hold source criteria.
OE_ORDER_HOLDS_ALL	This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases.
Hold Release
OE_HOLD_RELEASES_ALL	Hold released Sales Order
Credit Check Details
OE_CREDIT_CHECK_RULES	To get the Credit Check Against Customer.
Cancel Orders
OE_ORDER_LINES_ALL	Cancel Order Details.
Automatic Numbering System
AR_SYSTEM_PARAMETES_ALL	You can check Automatic Numbering is enabled/disabled
Document Sequence
FND_DOCUMENT_SEQUENCES	Document Sequence Numbers
FND_DOC_SEQUENCE_CATEGORIES	This table stores information about document categories that are defined for various products in the Oracle Applications product suite. Each row includes an identifier of the application to which the category belongs, the name of the category, the category code, the name of the database table storing the category, and a description for the category.
FND_DOC_SEQUENCE_ASSIGNMENTS	This table stores information about assignments of document sequences to various documents.
Default Rules For Price List
OE_DEF_ATTR_DEF_RULES	Price List Default Rules
End User Details
CSI_T_PARTY_DETAILS	To capture End user Details
Sales Credit
OE_SALES_CREDITS	Sales Credit Information
Attaching Documents
FND_ATTACHED_DOCUMENTS	Attached Documents and Text information
FND_DOCUMENTS_TL	Fnd documents short text
Blanket Sales Order
OE_BLANKET_HEADERS_ALL	This table stores the common Attributes between sales order and sales agreements at header level
OE_BLANKET_LINES_ALL	This table stores the common Attributes between sales order and sales agreements at line level
Processing Constraints
OE_PC_ASSIGNMENTS	Sales order Shipment Schedule Processing Constraints