License Plate Number (LPN) in Oracle Warehouse Management (WMS)

 License Plate Number (LPN)

LPN is the backbone of Oracle WMS. Most of the entries in the HHT device are based on LPN scanning. You can define Sub-inventory also LPN controlled or non-LPN control after implementing Oracle WMS. You can find Item in material workbench packed in LPN or Loose Material(not packed in LPN).

Below are the some sql query which helps you debug the LPN related issues:

-- Lookup related to LPN

select * from apps.fnd_lookup_types_VL Where lookup_type = 'WMS_LPN_CONTEXT';

select * from apps.fnd_lookup_values  Where lookup_type = 'WMS_LPN_CONTEXT' and LANGUAGE = 'US';

LOOKUP_CODE     MEANING

7                   At Vendor

5                   Defined but not used

1                   In Inventory

3                   In Receiving

2                   In WIP

6                   Intransit

4                   Issued out of Stores

12                   Loaded in Staging

9                   Loaded to Dock

8                   Packing context

11                   Picked

10                   Prepack for WIP

-- To find current LPN details

 select a.LPN_ID, a.LICENSE_PLATE_NUMBER,a.LPN_CONTEXT, b.MEANING

from apps.wms_license_plate_numbers a, apps.fnd_lookup_values b

where LICENSE_PLATE_NUMBER = '&LPN_NUMBER'

and b.lookup_type = 'WMS_LPN_CONTEXT'

and a.LPN_CONTEXT = b.LOOKUP_CODE

and b.LANGUAGE = 'US';

-- LPN related main table

select * from apps.wms_license_plate_numbers where LICENSE_PLATE_NUMBER = '&LPN_NUMBER';

select * from apps.wms_lpn_contents where PARENT_LPN_ID = &LPN_ID;

select * from apps.wms_lpn_histories where PARENT_LPN_ID = LPN_ID;