SELECT GuVehicle.GUI_USER_ID,
       GuVehicle.VEHICLE_ID,
       VehicleOwner.COMPANY_NAME,
       VehicleOwner.VEHICLE_OWNER_ID,
       Vehicle.COMPANY_NR,
       Vehicle.VEHICLE_ID AS VEHICLE_ID1,
       Vehicle.NUMBERPLATE,
       VoVehicleCategory.NAME,
       VoVehicleCategory.VO_VEHICLE_CATEGORY_ID,
       Vehicle.BRAND,
       Vehicle.MODEL
FROM GU_VEHICLE GuVehicle, VEHICLE Vehicle, VEHICLE_OWNER VehicleOwner, VO_VEHICLE_CATEGORY VoVehicleCategory
WHERE guvehicle.vehicle_id = vehicle.vehicle_id AND vehicle.vo_vehicle_category_id = vovehiclecategory.vo_vehicle_category_id
AND vovehiclecategory.is_object= 'Y' AND vovehiclecategory.vehicle_owner_id = vehicleowner.vehicle_owner_id
AND NVL(Vehicle.VEHICLE_STATUS_ID,0) = 0