Search Results wms_license_plate_numbers

Overview

The WMS_LICENSE_PLATE_NUMBERS table is a core data object within the Oracle E-Business Suite Warehouse Management (WMS) module, serving as the master repository for container instances. In Oracle WMS, a container is known as a License Plate Number (LPN), a unique identifier for a physical entity used to store, track, and move material. This table stores the fundamental attributes and current state of every LPN created in the system across all organizations. Its role is central to enabling advanced warehousing functionalities such as cartonization, nested LPNs (parent-child relationships), directed putaway and picking, and mobile transactions, forming the backbone of containerized inventory tracking in Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the system-generated LPN_ID, which uniquely identifies each container. Critical columns define the LPN's characteristics and location, including LICENSE_PLATE_NUMBER (the user-facing identifier), ORGANIZATION_ID, and SUBINVENTORY_CODE. It tracks the LPN's contents via INVENTORY_ITEM_ID, REVISION, and LOT_NUMBER. The table also manages the LPN's physical and logical placement through LOCATOR_ID and records its hierarchical nesting via PARENT_LPN_ID and OUTERMOST_LPN_ID. Status columns like LPN_STATUS, SEALED_STATUS, and CONTENT_LPN_ID are vital for controlling workflow and transaction validity. Additional columns capture weights, dates, and the context of the LPN's creation (e.g., generated from a shipment or task).

Common Use Cases and Queries

This table is essential for operational reporting, data validation, and troubleshooting. Common scenarios include tracing the complete lineage of a nested LPN, identifying all LPNs in a specific location, or finding LPNs containing a particular item or lot. A frequent query pattern retrieves an LPN's basic details and current location:

• SELECT license_plate_number, inventory_item_id, lot_number, subinventory_code, locator_id FROM wms_license_plate_numbers WHERE organization_id = :org_id AND license_plate_number = :lpn;

Another critical use case is validating LPN status before a transaction, such as confirming an LPN is not voided or already shipped. Analysts also query this table to report on container utilization, aging, or to reconcile physical inventory counts by joining to related cycle count and physical adjustment tables.

Related Objects

As indicated by its extensive foreign key relationships, WMS_LICENSE_PLATE_NUMBERS is deeply integrated with the Inventory foundation. It references master tables like MTL_SYSTEM_ITEMS_B, MTL_SECONDARY_INVENTORIES, MTL_ITEM_LOCATIONS, MTL_LOT_NUMBERS, and MTL_SERIAL_NUMBERS. Crucially, it has a recursive relationship with itself to model LPN nesting. It is referenced as a parent by transactional tables such as WMS_LPN_CONTENTS (for detailed material within an LPN), MTL_SERIAL_NUMBERS, and physical inventory tables (MTL_CYCLE_COUNT_ENTRIES, MTL_PHYSICAL_ADJUSTMENTS). For historical tracking, the WMS_LPN_HIST table stores a record of state changes. Key APIs for LPN creation and manipulation, like INV_LPN_PUB, primarily interact with this underlying table.