Search Results wms_devices_b




Overview
Explore in AI Chat

Overview

WMS_DEVICES_B is the base (language-independent) definition table for warehouse devices in the Oracle E-Business Suite Warehouse Management (WMS) module. It stores the configured characteristics of each device — such as barcode scanners, RF terminals, label printers, and material-handling equipment — that is registered against a specific warehouse organization. Because it is a "_B" table, it holds the descriptive attributes, while translatable text (device name and description) is held in the companion WMS_DEVICES_TL table.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as hub-leaning. It functions as a central entity hub keyed on the surrogate device identifier, with most of its 38 columns acting as descriptive satellite attributes and a modest set of outbound and inbound links to other warehouse objects.

Key Information Stored

The table also carries standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the 15 generic ATTRIBUTE columns with ATTRIBUTE_CATEGORY for extensibility.

Common Use Cases and Queries

Typical uses include listing active devices by organization, auditing device configuration, and joining to MTL_PARAMETERS to resolve the owning warehouse. A representative query returns enabled devices for a warehouse:

SELECT d.DEVICE_ID, d.DEVICE_MODEL, d.ENABLED_FLAG
FROM   WMS.WMS_DEVICES_B d
WHERE  d.ORGANIZATION_ID = :org_id
AND    d.ENABLED_FLAG = 'Y';

Reporting scenarios include reconciliation of devices by type, capacity planning via BATCH_LIMIT, and resolving human-readable names by joining to WMS_DEVICES_TL on DEVICE_ID for the appropriate language. Auditing queries frequently filter on the LAST_UPDATE_DATE and LAST_UPDATED_BY columns to trace configuration changes.

Related Objects

  • WMS_DEVICES_TL — stores translatable device names/descriptions; join on WMS_DEVICES_TL.DEVICE_ID = WMS_DEVICES_B.DEVICE_ID.
  • MTL_PARAMETERS — the warehouse organization master; join on WMS_DEVICES_B.ORGANIZATION_ID = MTL_PARAMETERS.ORGANIZATION_ID.
  • WMS_BUS_EVENT_DEVICES — maps business events to devices; references WMS_DEVICES_B.DEVICE_ID.
  • WMS_DEVICE_REQUESTS_HIST — historical device request records keyed by DEVICE_ID, useful for activity reporting.

These relationships confirm WMS_DEVICES_B as the hub for device configuration data referenced across WMS device transactions.