DBA Data[Home] [Help]

APPS.INV_RCV_STD_INSPECT_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 3516: FROM wms_license_plate_numbers

3512: , locator_id
3513: INTO l_xfer_lpn_ctxt
3514: , l_xfer_lpn_sub
3515: , l_xfer_lpn_loc_id
3516: FROM wms_license_plate_numbers
3517: WHERE lpn_id = p_transfer_lpn_id;
3518:
3519: IF (NVL(l_xfer_lpn_ctxt, 5) = 3) THEN
3520: l_rti_sub_code := l_xfer_lpn_sub;

Line 3530: FROM wms_license_plate_numbers

3526: SELECT subinventory_code
3527: , locator_id
3528: INTO l_lpn_sub
3529: , l_lpn_loc_id
3530: FROM wms_license_plate_numbers
3531: WHERE lpn_id = p_lpn_id;
3532:
3533: l_rti_sub_code := l_lpn_sub;
3534: l_rti_loc_id := l_lpn_loc_id;