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= ? AND v.\
    "Datum\" BETWEEN ? AND ?
AND ( - 1 = ?
      OR v.vo_person_category_id = ? )
    AND ( 'Y' = 'false'
          OR nvl(v.is_locked, 'N') = 'Y' ) ORDER BY 1,2;