Advertisement
psi_mmobile

Untitled

Oct 30th, 2019
276
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.25 KB | None | 0 0
  1. SELECT v.* FROM V_EXPORT_GROUPS_VALENS v,GU_PERSON GP WHERE v.PERSON_ID=GP.PERSON_ID AND GP.GUI_USER_ID=104444 AND v.DATE_DAY BETWEEN SYSDATE - 30 AND SYSDATE AND (-1=-1 OR v.VO_PERSON_CATEGORY_ID=-1) AND ('false'='false' OR NVL(v.IS_LOCKED,'N')='Y')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement