Siebel Unleashed

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 !!!

(No Ratings Yet)

 Loading ...

• Table Scan Index Scan and Index Seek
• SQL – extracting the workflow queue.
• Identifying Positions based on divisions - SQL.
• Useful SQL Queries – Workflow Processes exposed.
• Useful SQL Queries - Workflow Process and Workflow Policies
• Useful SQL Queries - Customization exposed