--2
--fromDate -> Sun Jun 25 00:00:00 CEST 2017
--toDate -> Sun Jun 25 23:59:00 CEST 2017
--ImagePath -> 0
--vehicleCategory -> -1
--vehicleName -> -1
--voGroup : [-1]
--gu_user_id -> 101048

SELECT  DISTINCT  vd.vehicle_id, v.company_nr,v.numberplate, p.company_nr, p.last_name || ' ' ||  p.first_name person_name,
  to_char ( vd.date_day, 'dd/MM/yyyy' ) AS date_day,
vd.driver_id, v.vo_vehicle_category_id,  (vd.day_last_stop_km-vd.day_first_start_km) day_km, round(vd.day_last_stop_km , 0) km_counter
FROM vd_poi_day vd, vehicle v, person p, gu_vehicle gv, vo_group_vehicle vv, operation_center oc
WHERE vd.driver_id=p.person_id(+)
AND vd.vehicle_id=v.vehicle_id
AND v.vehicle_id=gv.vehicle_id
AND gv.gui_user_id=101048
AND v.vehicle_id = decode (-1, -1, v.vehicle_id, -1)
AND vd.date_day >= toutcdate( to_date ('25/06/2017 00:00','dd/MM/yyyy HH24:mi') , oc.timezone )
AND vd.date_day <toutcdate( to_date ('25/06/2017 23:59','dd/MM/yyyy HH24:mi') , oc.timezone ) + 1
AND v.vo_vehicle_category_id = decode(-1,-1, v.vo_vehicle_category_id,-1)
 AND ((-1 IN  -1)   OR (v.vehicle_id IN ( SELECT vehicle_id FROM vo_group_vehicle WHERE vo_group_id IN -1)));