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

Oracle Advance Pricing Queries-2

--for each context and code combinations there are attributes and mapped to derive functionality
select *
  from qp_segments_b b,
       qp_segments_tl t
 where b.prc_context_id=100008
   and b.segment_mapping_column in ('QUALIFIER_ATTRIBUTE35','QUALIFIER_ATTRIBUTE32')
   and b.segment_id=t.segment_id
   and t.language = USERENV ('LANG');

Oracle Advance Pricing Queries-1

--There are three contexts types -Pricing,Product and Qualifier
--for each there are context codes

select *
  from qp_prc_contexts_b b,
       qp_prc_contexts_tl t
 where b.prc_context_type='QUALIFIER'
   and b.prc_context_code='ORDER'
   and b.prc_context_id = t.prc_context_id
   and t.language = USERENV ('LANG');