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

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
Get Customer information include Name, 
Contacts, Address and Phone
HZ_PARTY_SITES

HZ_LOCATIONS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_SITES_ALL

HZ_CUST_SITE_USES_ALL

RA_CUSTOMERS

Price Details
QP_LIST_HEADERS_B
To Get Item Price Details.
QP_LIST_LINES

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
Order Hold and Managing Details
OE_HOLD_AUTHORIZATIONS

OE_HOLD_SOURCES_ALL

OE_ORDER_HOLDS_ALL

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

FND_DOC_SEQUENCE_ASSIGNMENTS

Default Rules For Price List
OE_DEF_ATTR_DEF_RULES
Price List Default Rules
OE_DEF_ATTR_CONDNS

AK_OBJECT_ATTRIBUTES

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_AL
Blanket Sales Order Information.
OE_BLANKET_LINES_ALL

Processing Constraints
OE_PC_ASSIGNMENTS
Sales order Shipment schedule Processing Constraints
OE_PC_EXCLUSIONS