APPS.WMS_PACKING_WORKBENCH_PVT dependencies on HZ_LOCATIONS

Line 2522: FROM hz_locations

2518:
2519: BEGIN
2520: SELECT nvl(city, address1)||':'||to_char(location_id)
2521: INTO l_material_rec.ship_to_location
2522: FROM hz_locations
2523: WHERE location_id = l_material_rec.ship_to_location_id;
2524: EXCEPTION
2525: WHEN NO_DATA_FOUND THEN
2526: IF l_debug = 1 THEN