asokolovski

Untitled

Dec 18th, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. select taskId as id
  2. , forEmptyClient
  3. , forBank
  4. , forLegalPerson
  5. , forNaturalPerson
  6. , forSPDFL
  7. , enableQBE
  8. , angularRoute as route
  9. , rights.hasRight
  10. from JetB2Task
  11. , (select decode(count(0), 0, 0, 1) as hasRight
  12. from userTask ut
  13. where ut.taskId = :vTaskId
  14. and ut.userGroupId in (select ugl.userGroupId
  15. from userGroupLink ugl
  16. where ugl.userId in (select id
  17. from users
  18. where upper(userName) = sys_context('CX_B2_USER', 'USERNAME')))) rights
  19. where taskId = :vTaskId
Advertisement
Add Comment
Please, Sign In to add comment