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, vehicle_owner voz
WHERE v.last_vehicle_data_id=vd.vehicle_data_id
AND v.vehicle_id=vd.vehicle_id
AND vd.remote_unit_id=ru.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 voz.vehicle_owner_id=pc.vehicle_owner_id;