Useful SQL Queries in Siebel – Views and Responsibility.

(1 votes, average: 4.00 out of 5)

 Loading ...

Below mentioned SQL Query will give you the list of users (First Name and Last Name) who have particular view added to their responsibility in Siebel.



SELECT DISTINCT
usid.per_fst_name || ' ' || usid.per_last_name "Users"
FROM siebel.s_resp resp,
siebel.s_app_view vi,
siebel.s_app_view_resp inter,
siebel.s_per_resp usid
WHERE vi.row_id = inter.view_id
AND resp.row_id = inter.resp_id
 -- Change the view name to what you want to give
AND vi.name = 'Your View Name'
AND usid.resp_id = resp.row_id


You can change the view name to the view that you want or you can give name of multiple views like this

AND vi.name in ('Your View Name' ,'2nd View Name')

Hope this helps and your invaluable comments are always welcome !!!