APPS.RCV_TRANSACTION_SV dependencies on HZ_LOCATIONS

Line 184: FROM hz_locations

180:
181: IF (x_oe_line_id IS NOT NULL) THEN /* drop ship */
182: SELECT substr(rtrim(address1) || '-' || rtrim(city),1,20)
183: INTO x_location_code
184: FROM hz_locations
185: WHERE location_id = x_location_id;
186: ELSE /* not a drop ship */
187: SELECT location_code
188: INTO x_location_code

Line 361: from hz_locations

357: exception
358: when NO_DATA_FOUND then
359: select 'Check to see if deliver_to_location_id is valid'
360: INTO x_del_loc_val
361: from hz_locations
362: WHERE (address_expiration_date IS NULL
363: OR
364: address_expiration_date > x_date)
365: AND location_id = x_deliver_to_location_id;

Line 397: from hz_locations

393: exception
394: when NO_DATA_FOUND then
395: select 'Check to see if location_id is valid'
396: into x_loc_val
397: from hz_locations
398: WHERE (address_expiration_date IS NULL
399: OR
400: address_expiration_date > x_date)
401: AND location_id = x_location_id;