WMS — Warehouse Management
133 documented tables · 96 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
WMS_DB_OBJECTS |
WMS Database Objects | hub |
WMS_PARAMETERS_B |
WMS Parameters | hub |
WMS_CROSSDOCK_CRITERIA_B |
Table to store WMS Crossdock Criteria | hub-leaning |
WMS_OBJECTS_B |
WMS Business Objects | hub-leaning |
WMS_DB_OBJECT_REFERENCES |
WMS Database Object References | hub-leaning |
WMS_RULES_B |
WMS Rules | hub |
WMS_LICENSE_PLATE_NUMBERS |
Used to store the information related to a container instance (LPN) | hub |
WMS_DEVICES_B |
Device DefinitionTable | hub-leaning |
WMS_PAGE_FIELDS_B |
WMS Mobile Page Fields Configuration | hub-leaning |
WMS_STRATEGIES_B |
WMS Strategies | hub |
WMS_TASK_FILTER_B |
Task Filter Definitions | hub-leaning |
WMS_LABEL_FIELDS_B |
This table stores the list of all accepted label fields for a specific Label Type defined in the lookups. Wh | hub-leaning |
WMS_PAGE_TEMPLATES_B |
Page Templates | hub-leaning |
WMS_RULE_TRACE_HEADERS |
WMS Rule Trace Headers | hub-leaning |
WMS_LABEL_FORMATS |
This table stores a list of all label formats defined in the system for a label type. During label printing e | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
WMS_CONTAINER_PUB |
PUB | 17 | 41 packages |
WMS_DATA_TYPE_DEFINITIONS_PUB |
PUB | 0 | 14 packages |
WMS_TXNRSN_ACTIONS_PUB |
PUB | 7 | 7 packages |
WMS_CARTNZN_PUB |
PUB | 27 | 7 packages |
WMS_RE_CUSTOM_PUB |
PUB | 9 | 6 packages |
WMS_XDOCK_PEGGING_PUB |
PUB | 9 | 6 packages |
WMS_SHIPPING_TRANSACTION_PUB |
PUB | 50 | 6 packages |
WMS_SHIPPING_INTERFACE_GRP |
GRP | 6 | 6 packages |
WMS_CONTAINER_GRP |
GRP | 4 | 5 packages |
WMS_WCS_DEVICE_GRP |
GRP | 6 | 4 packages |