2423: SELECT subinventory_code,
2424: locator_id
2425: INTO x_cascaded_table(n).subinventory,
2426: x_cascaded_table(n).locator_id
2427: FROM wms_license_plate_numbers
2428: WHERE lpn_id = x_cascaded_table(n).transfer_lpn_id;
2429:
2430: IF (g_asn_debug = 'Y') THEN
2431: asn_debug.put_line('Sub is ' || x_cascaded_table(n).subinventory);
2446: SELECT subinventory_code,
2447: locator_id
2448: INTO x_cascaded_table(n).subinventory,
2449: x_cascaded_table(n).locator_id
2450: FROM wms_license_plate_numbers
2451: WHERE lpn_id = x_cascaded_table(n).lpn_id;
2452:
2453: IF (g_asn_debug = 'Y') THEN
2454: asn_debug.put_line('Sub is ' || x_cascaded_table(n).subinventory);