APPS.INV_LABEL dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 3789: wms_license_plate_numbers wlpn,

3785: mfglkup2.meaning label_type,
3786: wlrh.label_request_id label_request_id
3787: from wms_label_requests_hist wlrh,
3788: wms_label_formats wlf,
3789: wms_license_plate_numbers wlpn,
3790: mtl_system_items_kfv msik,
3791: mfg_lookups mfglkup1,
3792: mfg_lookups mfglkup2
3793: where wlrh.label_format_id = wlf.label_format_id (+)

Line 3938: FROM wms_license_plate_numbers plpn

3934: SELECT wlc.parent_lpn_id ,wlc.inventory_item_id , wlc.lot_number
3935: FROM wms_lpn_contents wlc
3936: WHERE wlc.parent_lpn_id IN
3937: (SELECT lpn_id
3938: FROM wms_license_plate_numbers plpn
3939: start with lpn_id = p_lpn_id
3940: connect by parent_lpn_id = prior lpn_id
3941: )
3942: ORDER BY wlc.serial_summary_entry DESC ;

Line 4013: FROM wms_license_plate_numbers wlpn

4009: END IF;
4010:
4011: SELECT wlpn.lpn_context , wlpn.subinventory_code , wlpn.locator_id
4012: INTO l_lpn_context , l_subinventory_code , l_locator_id
4013: FROM wms_license_plate_numbers wlpn
4014: WHERE wlpn.lpn_id = p_lpn_id;
4015: IF l_lpn_context IN (WMS_Container_PUB.LPN_CONTEXT_PREGENERATED,
4016: WMS_Container_PUB.LPN_CONTEXT_VENDOR,
4017: WMS_Container_PUB.LPN_CONTEXT_STORES,