WMS Tables (133)
WMS - Warehouse Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
WMS_ALLOCATIONS_GTMP |
24 | |
WMS_API_HOOKED_ENTITIES |
17 | |
WMS_API_HOOK_CALLS |
15 | |
WMS_API_HOOK_SIGNATURES |
11 | |
WMS_ASN_DETAILS |
26 | Stored the WMS related information about the ASN shipped |
WMS_BFLOW_LABEL_TYPE |
32 | This table stores the business flow to label types relationship. This relationship is mandatory for labels to print from business flows like |
WMS_BUS_EVENT_DEVICES |
31 | This table stores the mapping between business event and devices. |
WMS_CAROUSEL_CONFIGURATION |
29 | Standard WHO Column |
WMS_CAROUSEL_DIRECTIVE_QUEUE |
39 | |
WMS_CROSSDOCK_CRITERIA_B |
22 | Table to store WMS Crossdock Criteria |
WMS_CROSSDOCK_CRITERIA_TL |
10 | Translation table for WMS Crossdock Criteria |
WMS_DB_OBJECTS |
29 | WMS Database Objects |
WMS_DB_OBJECTS_PARENTS |
25 | WMS Database Object Parents |
WMS_DB_OBJECT_JOINS |
28 | WMS Database Object Joining Condition |
WMS_DB_OBJECT_REFERENCES |
25 | WMS Database Object References |
WMS_DB_OBJ_REF_MEMBERS |
27 | WMS Database Object Reference Members |
WMS_DEPARTMENT_SUBINVENTORIES |
27 | This is a cross reference table for departments and subinventories. |
WMS_DEVICES_B |
38 | Device DefinitionTable |
WMS_DEVICES_TL |
10 | This table stores translatable columns.Device_Id is the link between this table and the table WMS_DEVICES_B. |
WMS_DEVICE_ASSIGNMENT_TEMP |
11 | Device assignment temporary table |
WMS_DEVICE_REQUESTS |
31 | |
WMS_DEVICE_REQUESTS_HIST |
42 | History Table for device request. This table stores all the device requests that have been submitted. |
WMS_DIRECT_SHIP_TEMP |
21 | Temporary table for processing the LPNs to be directly shipped bypassing Pick Release/Pick Confirm. |
WMS_DISPATCHED_TASKS |
49 | Dispatched Tasks Table |
WMS_DISPATCHED_TASKS_ARCH |
65 | Archive Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed |
WMS_DISPATCHED_TASKS_HISTORY |
68 | History Table for WMS_DISPATCHED_TASKS. Stores information about all tasks that have been completed |
WMS_DISPATCH_TASKS_GTMP |
3 | |
WMS_DOCK_APPOINTMENTS_B |
23 | Base table for WMS dock assignment form. It stores dock door (locator) ID, trip stop ID for outbound appointment, start time, end time, and |
WMS_DOCK_APPOINTMENTS_TL |
10 | WMS dock assignment translation table. Its base table is WMS_DOCK_APPOINTMENTS_B. |
WMS_DS_CT_WT_GTEMP |
10 | |
WMS_ELS_EXP_RESOURCE |
30 | This is the table which wil be populated by all the expected work when the Concurrent program Expected Resource Requirement Analysis will be |
WMS_ELS_EXP_RESOURCE_GTEMP |
6 | |
WMS_ELS_GROUPED_TASKS_B |
38 | This table is for storing all the setup information for the grouped tasks. |
WMS_ELS_GROUPED_TASKS_GTMP |
15 | |
WMS_ELS_GROUPED_TASKS_TL |
9 | This table is for storing all the translatable setup information like description for the grouped tasks. |
WMS_ELS_INDIVIDUAL_TASKS_B |
52 | This table is for storing all the setup information for the individual tasks. |
WMS_ELS_INDIVIDUAL_TASKS_TL |
9 | This table is for storing all the translatable setup information like description for the individual tasks. |
WMS_ELS_NON_TRACKED_USERS |
24 | This table will hold the information for the list of non-tracked users for the organization. |
WMS_ELS_PARAMETERS |
29 | This table will hold the global setup informnation for a labor management enabled warehouse. |
WMS_ELS_RATINGS_SETUP |
12 | This table will hold the ratings setup informnation for a labor management enabled warehouse. |
WMS_ELS_RESOURCE_SETUP |
10 | This table will hold the resource setup informnation for different activity and activity details for a labor management enabled warehouse. |
WMS_ELS_TRX_SRC |
43 | This table will hold all the details for labor tracked transactions for a labor management enabled warehouse. Additionally the table will al |
WMS_EPC |
20 | Stores EPC cross-reference information |
WMS_EXCEPTIONS |
39 | Table to capture task exceptions |
WMS_EXCEPTIONS_TEMP |
86 | |
WMS_FREIGHT_COST_TEMP |
18 | Temporary table to store Freight Cost Information for LPN or Delivery or Trip and process for direct ship of LPN. |
WMS_LABEL_FIELDS_B |
32 | This table stores the list of all accepted label fields for a specific Label Type defined in the lookups. While designing alabel format fo |
WMS_LABEL_FIELDS_TL |
11 | This table stores translatabke columns. Labek_field_id is the link between this table and the table WMS_LABEL_FIELDS_B. |
WMS_LABEL_FIELD_VARIABLES |
30 | This table stores all the label field variables that are required in a cerain label format. |
WMS_LABEL_FORMATS |
39 | This table stores a list of all label formats defined in the system for a label type. During label printing execution using the rules engin |
WMS_LABEL_REQUESTS |
55 | This table stores information about label printing requests. These records are used by rules engine to provide label format based on the lab |
WMS_LABEL_REQUESTS_HIST |
69 | History Table for label request. This table stores all the label requests that have been submitted. |
WMS_LABEL_SET_FORMATS |
8 | This table is key to Label-set feature in WMS. It stores formats and set relationship. |
WMS_LICENSE_PLATE_NUMBERS |
57 | Used to store the information related to a container instance (LPN) |
WMS_LOCATIONS_LOCATORS |
8 | WMS Configuration |
WMS_LPN_CONTENTS |
46 | Used to store all of the information related to the contents of a container |
WMS_LPN_CONTENTS_INTERFACE |
110 | Open interface table for preprocessing LPNs shipped with ASN |
WMS_LPN_HISTORIES |
60 | Used to store the history information related to the container's past transactions |
WMS_LPN_INTERFACE |
57 | Used to provide the information related to a container instance (LPN) for a transaction |
WMS_LPN_PROCESS_TEMP |
2 | Temporary table used to store the generated lpn values after call of the Generate_LPN api. API will pass back a process_id that indicates w |
WMS_MATERIAL_TXN_TRACE |
228 | This is history table for mtl_material_transaction_temp. - This for WMS internal Use only. |
WMS_MSG_COMPONENTS |
15 | |
WMS_MSG_TEMPLATES |
11 | |
WMS_OBJECTS_B |
26 | WMS Business Objects |
WMS_OBJECTS_TL |
11 | Translation Table for WMS Business Objects |
WMS_OP_DESTINATION_SEL_APIS |
10 | |
WMS_OP_OPERATION_INSTANCES |
45 | Not intended for use in Release 11.5.9 |
WMS_OP_OPERTN_INSTANCES_ARCH |
41 | Not intended for use in Release 11.5.9 |
WMS_OP_OPERTN_INSTANCES_HIST |
45 | Not intended for use in Release 11.5.9 |
WMS_OP_PLANS_B |
35 | Table to store header level Operation Plan Information |
WMS_OP_PLANS_TL |
11 | Standard MLS TL Table for WMS_OP_PLANS_B |
WMS_OP_PLAN_DETAILS |
49 | Table to store operation plan details |
WMS_OP_PLAN_INSTANCES |
40 | Not intended for use in Release 11.5.9 |
WMS_OP_PLAN_INSTANCES_ARCH |
33 | Not intended for use in Release 11.5.9 |
WMS_OP_PLAN_INSTANCES_HIST |
39 | Not intended for use in Release 11.5.9 |
WMS_ORDERED_TASKS |
17 | |
WMS_ORG_HIERARCHY_OBJS |
25 | WMS Strategy Search Order |
WMS_PACKAGING_HIST |
48 | This is history table for packaging. |
WMS_PACKING_MATERIAL_GTEMP |
64 | |
WMS_PAGE_FIELDS_B |
18 | WMS Mobile Page Fields Configuration |
WMS_PAGE_FIELDS_TL |
11 | WMS Mobile Page Fields Configuration |
WMS_PAGE_FIELD_VALUES |
10 | Page Field Values |
WMS_PAGE_TEMPLATES_B |
30 | Page Templates |
WMS_PAGE_TEMPLATES_TL |
12 | Translated Table for Page Templates |
WMS_PAGE_TEMPLATE_FIELDS |
27 | Page Template Fields |
WMS_PARAMETERS_B |
47 | WMS Parameters |
WMS_PARAMETERS_TL |
11 | Translation Table for WMS Parameters |
WMS_PRINTER_IP_DEF |
8 | Table to associate IP Address/Port to the Printer |
WMS_PUTAWAY_GROUP_TASKS_GTMP |
71 | |
WMS_REPL_DEMAND_GTMP |
18 | |
WMS_RESTRICTIONS |
36 | WMS Restrictions |
WMS_RULES_B |
33 | WMS Rules |
WMS_RULES_TL |
11 | Translation tables for WMS Rules |
WMS_RULE_CONSISTENCIES |
25 | WMS Rule Consistencies |
WMS_RULE_LIST_PACKAGE |
23 | WMS Rule List Package Table is used to keep track the latest Rules List packages |
WMS_RULE_TRACE_HEADERS |
20 | WMS Rule Trace Headers |
WMS_RULE_TRACE_LINES |
39 | WMS Rule Trace Lines |
WMS_SAVED_QUERIES |
12 | WMS Saved Queries |
WMS_SELECTION_CRITERIA_TXN |
41 | Selection Criteria /Assignment Matrix Table |
WMS_SERIAL_NUMBERS_TRACE |
74 | WMS_SERIAL_NUMBERS_TEMP is a history table . - This for WMS internal Use only. |
WMS_SHIPPING_TRANSACTION_TEMP |
24 | Temporary table used in mobile ship confirmation |
WMS_SKIP_TASK_EXCEPTIONS |
37 | Table to capture task exceptions for skipping task |
WMS_SORT_CRITERIA |
26 | WMS Sort Criteria |
WMS_STAGINGLANES_ASSIGNMENTS |
27 | This table stores the staging lane to dock door relationship. |
WMS_STRATEGIES_B |
30 | WMS Strategies |
WMS_STRATEGIES_TL |
11 | Translation Table for WMS Strategies |
WMS_STRATEGY_ASSIGNMENTS |
39 | WMS Strategy Assignments |
WMS_STRATEGY_MEMBERS |
32 | WMS Strategy Members |
WMS_TASKS_TEMP |
87 | |
WMS_TASK_FILTER_B |
24 | Task Filter Definitions |
WMS_TASK_FILTER_DTL |
25 | Filter Constraints |
WMS_TASK_FILTER_TL |
11 | Translated Task Filters |
WMS_TRANSACTIONS_TEMP |
29 | WMS Detailing Temporary Table |
WMS_TRANSACTION_LOTS_TRACE |
91 | WMS_TRANSACTION_LOTS is history table - This for WMS internal Use only. |
WMS_TXN_CONTEXT_TEMP |
7 | WMS Detailing Context Temporary Table |
WMS_WAVEPLAN_TASKS_TEMP |
121 | |
WMS_WP_EXCEPTIONS_GTMP |
18 | |
WMS_WP_LABOR_GTMP |
8 | |
WMS_WP_LINES_GTMP |
80 | |
WMS_WP_ORDERS_GTMP |
11 | |
WMS_WP_REC_REQUESTS_GTMP |
9 | |
WMS_WP_REQUESTS_GTMP |
9 | |
WMS_WP_RESERVATIONS_GTMP |
87 | |
WMS_WP_RULES_SIMULATION |
8 | |
WMS_WP_TASKS_GTMP |
72 | |
WMS_WP_TP_MMTT |
2 | |
WMS_WP_WAVE_DETAILS_GTMP |
25 | |
WMS_WSH_WDD_GTEMP |
168 | |
WMS_XDOCK_PEGGING_GTMP |
20 | |
WMS_XDOCK_SOURCE_ASSIGNMENTS |
9 | WMS Crossdock Criteria source type assignments |
WMS_ZONES_B |
27 | |
WMS_ZONES_TL |
10 | |
WMS_ZONE_LOCATORS |
10 |