Search Results wms_lpn_contents

Overview

The WMS_LPN_CONTENTS table is a core transactional data object within the Oracle E-Business Suite Warehouse Management (WMS) module. It serves as the definitive repository for tracking the specific inventory contents stored within any container, known as a License Plate Number (LPN). An LPN is a logical or physical container, such as a carton, pallet, or tote, used to group and manage inventory items. This table is fundamental to the system's ability to maintain detailed visibility into the hierarchical nesting of containers and the precise quantity, lot, revision, and subinventory location of every item within the warehouse. Its integrity is critical for all warehouse operations, including picking, packing, shipping, and cycle counting.

Key Information Stored

The table's primary key, LPN_CONTENT_ID, uniquely identifies each record of an item within a container. Essential columns include PARENT_LPN_ID, which links to the container in WMS_LICENSE_PLATE_NUMBERS, and the combination of INVENTORY_ITEM_ID and ORGANIZATION_ID, which links to the master item definition in MTL_SYSTEM_ITEMS_B. For detailed inventory tracking, the table stores LOT_NUMBER and REVISION, linking to MTL_LOT_NUMBERS and MTL_ITEM_REVISIONS_B respectively. Crucially, it holds the QUANTITY of the specific item/lot/revision within the parent LPN. Other columns track the source transaction and detail lines that created the content record, enabling full transaction history traceability.

Common Use Cases and Queries

A primary use case is generating a detailed packing list or contents report for a given LPN. This is essential for shipping verification and receiving. Another critical scenario is tracing inventory for lot recalls or quality holds, where queries must traverse from a lot number to every LPN containing it. Developers often query this table to validate inventory availability for a pick wave or to calculate the total quantity of an item across all containers in a specific subinventory. A foundational query pattern is:

• SELECT wlc.lpn_content_id, wlc.parent_lpn_id, msib.segment1 item_code, wlc.lot_number, wlc.revision, wlc.quantity FROM wms_lpn_contents wlc JOIN mtl_system_items_b msib ON wlc.inventory_item_id = msib.inventory_item_id AND wlc.organization_id = msib.organization_id WHERE wlc.parent_lpn_id = :p_lpn_id;

This table is also central to APIs and processes that break down or consolidate LPNs, as these operations directly insert, update, or delete records in WMS_LPN_CONTENTS.

Related Objects

The WMS_LPN_CONTENTS table maintains strict referential integrity through documented foreign key relationships with other core inventory tables. The primary relationship is with WMS_LICENSE_PLATE_NUMBERS via the PARENT_LPN_ID column, defining the container. It references the item master through MTL_SYSTEM_ITEMS_B on the composite key of INVENTORY_ITEM_ID and ORGANIZATION_ID. For lot-controlled items, it links to MTL_LOT_NUMBERS using INVENTORY_ITEM_ID, ORGANIZATION_ID, and LOT_NUMBER. Similarly, for revision-controlled items, it references MTL_ITEM_REVISIONS_B using INVENTORY_ITEM_ID, ORGANIZATION_ID, and REVISION. These relationships ensure that all contents are associated with valid, defined entities within the system.