SELECT to_char(v."Datum",'dd/MM/yyyy') as "Datum",v."Persoon",v."Type",v."Looncode",v."Hoeveelheid",v."Werf",v."Activiteit",v."Type_cpa",v."Km aantal" FROM V_EXPORT_KPD_VERELST v,GU_PERSON GP WHERE v.PERSON_ID=GP.PERSON_ID AND GP.GUI_USER_ID= 101001 AND v."Datum" BETWEEN sysdate - 10 AND sysdate
AND ( - 1 = -1
      OR v.vo_person_category_id = -1 )
    AND ( 'Y' = 'false'
          OR nvl(v.is_locked, 'N') = 'Y' ) ORDER BY 1,2;