psi_mmobile

Untitled

Sep 24th, 2021
773
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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.\
  2.    "Datum\" BETWEEN ? AND ?
  3. AND ( - 1 = ?
  4.      OR v.vo_person_category_id = ? )
  5.    AND ( 'Y' = 'false'
  6.          OR nvl(v.is_locked, 'N') = 'Y' ) ORDER BY 1,2;
RAW Paste Data