APPS.INV_LABEL dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 3716: wms_license_plate_numbers wlpn,

3712: mfglkup2.meaning label_type,
3713: wlrh.label_request_id label_request_id
3714: from wms_label_requests_hist wlrh,
3715: wms_label_formats wlf,
3716: wms_license_plate_numbers wlpn,
3717: mtl_system_items_kfv msik,
3718: mfg_lookups mfglkup1,
3719: mfg_lookups mfglkup2
3720: where wlrh.label_format_id = wlf.label_format_id (+)

Line 3839: FROM wms_license_plate_numbers plpn

3835: SELECT wlc.parent_lpn_id ,wlc.inventory_item_id , wlc.lot_number
3836: FROM wms_lpn_contents wlc
3837: WHERE wlc.parent_lpn_id IN
3838: (SELECT lpn_id
3839: FROM wms_license_plate_numbers plpn
3840: start with lpn_id = p_lpn_id
3841: connect by parent_lpn_id = prior lpn_id
3842: )
3843: ORDER BY wlc.serial_summary_entry DESC ;

Line 3914: FROM wms_license_plate_numbers wlpn

3910: END IF;
3911:
3912: SELECT wlpn.lpn_context , wlpn.subinventory_code , wlpn.locator_id
3913: INTO l_lpn_context , l_subinventory_code , l_locator_id
3914: FROM wms_license_plate_numbers wlpn
3915: WHERE wlpn.lpn_id = p_lpn_id;
3916: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
3917: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
3918: WMS_Container_PUB.LPN_CONTEXT_STORES,