Oracle
Apps Order Management Tables
|
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 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
|
No comments:
Post a Comment