SELECT v.*, p.person_id, p.FIRST_NAME||' '||p.LAST_NAME, pc.name, vc.name, ru.remote_unit_id
FROM vehicle v, remote_unit ru, vehicle_data vd, person p, vo_person_category pc, vo_vehicle_category vc, vehicle_owner vo
WHERE v.last_vehicle_data_id=vd.vehicle_data_id
AND ru.remote_unit_id=vd.remote_unit_id
AND vd.person_id=p.person_id
AND p.vo_person_category_id=pc.vo_person_category_id
AND v.vehicle_category_id=vc.vo_vehicle_category_id
AND vo.vehicle_owner_id=vc.vehicle_owner_id
AND vo.vehicle_owner_id=pc.vehicle_owner_id;