OE — Order Entry
108 documented tables · 228 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
SO_PRICE_LISTS_B |
Price lists | hub-leaning |
SO_RESULTS_B |
Cycle action results for order cycles | hub-leaning |
SO_ORDER_TYPES_115_ALL |
Order types | hub |
SO_HEADERS_ALL |
Order header information | hub |
SO_ACTIONS |
Cycle actions for order cycles | hub |
SO_ENTITIES |
Entities for pricing, holds, and notes | hub |
SO_LINES_ALL |
Order lines | hub-leaning |
WSH_DEPARTURES |
Shipping departures | hub |
SO_REPORTS |
Oracle Order Entry/Shipping reports | hub |
SO_REPORT_SETS |
Document sets to be printed from Ship Confirm Delivery and Ship Confirm Departure windows | hub-leaning |
SO_SALES_CREDIT_TYPES_115 |
Sales credit types | hub |
WSH_DELIVERIES |
Shipping deliveries | hub |
SO_ATTRIBUTES |
Attributes used in security rules and standard value rules sets | hub-leaning |
SO_NOTE_USAGES |
Note usages | hub-leaning |
SO_DISCOUNTS |
Discounts for use in price adjustments | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
OE_DEBUG_PUB |
PUB | 15 | 524 packages |
OE_MSG_PUB |
PUB | 37 | 482 packages |
OE_ORDER_PUB |
PUB | 43 | 301 packages |
OE_HOLDS_PUB |
PUB | 18 | 50 packages |
OE_WSH_BULK_GRP |
GRP | 0 | 37 packages |
OE_VERIFY_PAYMENT_PUB |
PUB | 29 | 29 packages |
OE_ORDER_GRP |
GRP | 14 | 21 packages |
OE_BULK_MSG_PUB |
PUB | 20 | 18 packages |
OE_PRICING_CONT_PUB |
PUB | 3 | 16 packages |
OE_INVOICE_PUB |
PUB | 19 | 15 packages |