SELECT DISTINCT v.VEHICLE_ID, v.NUMBERPLATE, v.COMPANY_NR, vc.name, ru.is_container, TRIM( BOTH ' ' FROM vd.RG_POST_CODE||' '||vd.RG_STREET||' '||vd.RG_STREET_NR||' '||vd.RG_COUNTRY),
str.str_value, oat.oc_alarm_type_id, oac.name, ac.name||' '||vo.company_name||' '||vo.vehicle_owner_id
FROM vehicle v, vo_vehicle_category vc, remote_unit ru, vehicle_data vd, alarm aa, oc_alarm_type oat, oc_alarm_category oac, vehicle_owner vo, admin_center ac, admin_center aca, operation_center oc, str
WHERE vd.vehicle_id=v.vehicle_id
AND v.vo_vehicle_category_id=vc.vo_vehicle_category_id
AND vc.vehicle_owner_id=vo.vehicle_owner_id
AND vo.admin_center_id=ac.admin_center_id
AND v.remote_unit_id=ru.remote_unit_id(+)
AND aa.vehicle_data_id=vd.VEHICLE_data_ID(+)
AND aa.oc_alarm_type_id=oat.oc_ALARM_TYPE_ID
AND oat.oc_alarm_category_id=oac.oc_alarm_category_id
AND oac.operation_center_id=oc.operation_center_id
AND oc.admin_center_id=aca.admin_center_id
AND v.last_vehicle_data_id=vd.vehicle_data_id
AND oat.alarm_str_id=str.str_id
AND trunc(aa.creation_date)= to_date('31-05-2014', 'dd-mm-yyyy')
AND str.LANGUAGE LIKE 'EN'
ORDER BY v.VEHICLE_ID;