4423: UPDATE inl_ship_headers_int sh
4424: SET sh.location_id = (
4425: SELECT hou.location_id
4426: FROM hr_organization_units hou,
4427: hr_locations hl
4428: WHERE hl.location_id = hou.location_id
4429: AND hl.receiving_site_flag = 'Y'
4430: AND hou.organization_id = sh.organization_id
4431: )