License Plate Numbers (LPNs)-Warehouse Management

In Oracle Warehouse Management, a license plate number (LPN) is any object that holds items. Although LPNs are associated with containers, they do not need to represent a physical entity, such as a box. Thus, you can define an LPN as a collection of items. Oracle Warehouse Management enables you to track, transact, and nest LPNs.

Lpn contexts

    '1', 'Resides in Inventory',
    '2', 'Resides in WIP',
    '3', 'Resides in Receiving',
    '4', 'Issued out of Stores',
    '5', 'Defined but not used',
    '6', 'Resides in Intransit',
    '7', 'Resides in Vendor',
    '8', 'Packing Context',
    '9', 'Loaded to Dock',
    '10', 'Prepack for WIP',
    '11', 'Picked'

 Main tables

select * from wms_license_plate_numbers;
select * from wms_lpn_contents;
select * from wms_shipping_transaction_temp;

Generating License Plate Numbers:

You can generate LPNs using one of the following methods:

• Submitting a concurrent request
• Generate LPNs using a mobile device

Explaining Multi-level Nesting Support:

Oracle Warehouse Management enables you to nest LPNs. For example, pallet LPN P5555 contains three nested LPNs: LPN P5552, LPN P5553, and LPN P5554. In the system, you would see LPN P5555 as the top-level LPN, and each of the of the three box LPNs would fall under LPN P5555.

A single LPN contain many quantities of the same item and or/ different item