--4
--fromDate -> Mon Jun 26 00:00:00 CEST 2017
--toDate -> Mon Jun 26 23:59:00 CEST 2017
--langue -> du
--poiName -> -1
--personCategory -> -1
--personName -> -1
--status -> -1
--voGroup : [-1]
--gu_user_id -> 101712

SELECT
      p.company_nr,
       P.last_name  || ' ' ||   p.first_name AS person,
       vf.company_nr_i,
       vf.numberplate_i,
       vf.DATE_DAY,
       wc.short_code AS work_short_code,
       vf.WORK_CODE_ID AS work_code_for_debug,
       vf.start_time,
       vf.stop_time,
       vf.TRF_IHR,
       vf.TRF_PHR,
       vf.TRF_KM_ROUTE,
       vf.REF_NUMBER,
       vf.WBS_NAME AS POI,
       os.name AS status_name,
       vf.FLAG_COLOUR,
       vf.PD_TRF_USER_COMMENT ||  ' '  || p_aggreg_rules.getExceptionStr(vf.person_id, vf.date_day, vf.journey, gu.LANGUAGE) AS comment_error
  FROM V_RPT_PD_TRF_DAY vf, WORK_CODE wc,  gu_person gp,  OC_AGGREG_ADMIN_STATUS os, person p, gui_users gu, operation_center oc
 WHERE vf.WORK_CODE_ID = wc.WORK_CODE_ID(+)
   AND vf.DATE_DAY  >= toutcdate( to_date ('26/06/2017 00:00','dd/MM/yyyy HH24:mi') , oc.timezone )
   AND vf.DATE_DAY  < toutcdate( to_date ('26/06/2017 23:59','dd/MM/yyyy HH24:mi') , oc.timezone )+1
   AND vf.pd_trf_type_id = 1
   AND vf.person_id = gp.person_id
   AND gp.gui_user_id = 101712
   AND vf.oc_aggreg_admin_status_id = os.oc_aggreg_admin_status_id
   AND (( -1 IN -1) OR (vf.oc_aggreg_admin_status_id IN  -1 ))
   AND nvl (vf.start_poi_id, -2) = nvl ( decode (-1, -1,  vf.start_poi_id, -1) , -2)
   AND  vf.person_id = decode(-1,-1, vf.person_id,-1)
   AND vf.person_id = p.person_id
   AND gu.gui_user_id = gp.gui_user_id
   AND p.vo_person_category_id= decode(-1,-1, p.vo_person_category_id,-1)
   AND ((-1 IN -1) OR  (P.PERSON_ID IN (SELECT person_id FROM vo_group_person WHERE vo_group_id IN -1)))
   AND vf.WORK_CODE_STD_ID > 100
   AND UPPER(gu.LANGUAGE) LIKE 'DU'

AND EXISTS ( SELECT * FROM  pd_day p WHERE  p.DATE_DAY =  vf.DATE_DAY  AND p.PERSON_ID = vf.person_id )
   ORDER BY P.last_name  || ' ' ||   p.first_name, vf.DATE_DAY, vf.order_num;