APPS.WMS_PACKING_WORKBENCH_PVT dependencies on HZ_LOCATIONS

Line 2449: FROM hz_locations

2445:
2446: BEGIN
2447: SELECT nvl(city, address1)||':'||to_char(location_id)
2448: INTO l_material_rec.ship_to_location
2449: FROM hz_locations
2450: WHERE location_id = l_material_rec.ship_to_location_id;
2451: EXCEPTION
2452: WHEN NO_DATA_FOUND THEN
2453: IF l_debug = 1 THEN