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
|
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
|
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
| |
