Search Results subinventory_status_code

Overview

The WMS_ZONE_LOCATORS_TEMP view is an Oracle E-Business Suite database object owned by the APPS schema and delivered as part of the Warehouse Management (WMS) product family. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2. The view exposes the contents of the temporary table WMS_ZONE_LOCATORS_GTMP, presenting zone-to-locator association data in a read-friendly structure that includes both coded values and their decoded meanings. Because the underlying object is a global temporary table, the view is not intended as a persistent store of configuration or transaction data; rather, it serves as a staging and presentation layer used during interactive zone and locator definition or validation sessions.

Functionally, the view supports the WMS zone definition and locator assignment workflows. Records populate the temporary table through PL/SQL processing, and the view makes those intermediate results available for display, validation, or downstream consumption. This pattern is common in WMS, where users select subinventories, locators, picking and dropping sequences, and statuses within a zone setup session before committing to base tables.

Underlying Base Objects

The view is defined directly over a single documented base object: the synonym WMS_ZONE_LOCATORS_GTMP, which resolves to the global temporary table of the same name. The view text selects a fixed set of columns and aliases ROWID as ROW_ID for row identification. There are no joins documented in the view definition; all decoding between codes and meanings (for example, SUBINVENTORY_TYPE versus SUBINVENTORY_TYPE_MEANING) is performed upstream, with the temporary table already containing both forms. Consequently, WMS_ZONE_LOCATORS_TEMP is best understood as a stable projection over transient data, isolating consumers from the underlying synonym name and ROWID handling.

Key Columns

• ROW_ID — The ROWID of the corresponding temporary-table row, useful for row-level identification within a session.
• ORGANIZATION_ID — Inventory organization context for the zone and locator records.
• SUBINVENTORY_CODE and INVENTORY_LOCATION_ID — The subinventory and its source locator.
• LOCATOR_NAME — Display name of the locator.
• PICKING_ORDER and DROPPING_ORDER — Sequence values governing pick and put-away traversal within the zone.
• SUBINVENTORY_TYPE and SUBINVENTORY_TYPE_MEANING — Coded and decoded subinventory type; this column is directly relevant to the search term subinventory_type.
• INVENTORY_LOCATION_TYPE and LOCATOR_TYPE_MEANING — Location type code and its meaning.
• SUBINVENTORY_STATUS, SUBINVENTORY_STATUS_CODE, LOCATOR_STATUS, and LOCATOR_STATUS_CODE — Enabled/disabled status indicators in coded and descriptive form.
• LOCATOR_DISABLE_DATE — Effective date on which a locator becomes unavailable.
• MESSAGE and MESSAGE_ID — Diagnostic or validation messages associated with the staged row, supporting error reporting during zone setup.

Common Use Cases and Queries

Typical usage occurs during zone definition debugging, validation of subinventory-to-locator assignments, and diagnostics of picking or dropping sequence configuration. Because the data is session-scoped, queries are generally executed from the same session that populated the temporary table.

To inspect staged locator assignments for a specific organization and subinventory type:

SELECT organization_id, subinventory_code, locator_name,
       subinventory_type, subinventory_type_meaning,
       picking_order, dropping_order
FROM   apps.wms_zone_locators_temp
WHERE  organization_id = :org_id
AND    subinventory_type = :sub_type
ORDER BY subinventory_code, picking_order;

To surface validation messages generated during zone setup:

SELECT s.inventory_location_id, s.locator_name,
       s.message_id, s.message
FROM   apps.wms_zone_locators_temp s
WHERE  s.message IS NOT NULL;

To list enabled locators pending assignment:

SELECT locator_name, locator_status, locator_status_code
FROM   apps.wms_zone_locators_temp
WHERE  locator_status_code = 'A';

These patterns support integration testing and troubleshooting of WMS zone configuration without querying the temporary table directly.