users have a particular responsibility Scripts

 

Query to find what all users have a particular responsibility

In Oracle Apps 11i, if we want to find which all users have a particular responsibility or which all responsibility does a user have,responsibility is end dated for the user or not,user is end dates or not then we can use the following query->
select fu.user_name,fu.description,fu.user_id,frtl.responsibility_name,furgd.start_date user_resp_start_date,furgd.end_date user_resp_end_date,fu.start_date USER_start_date,fu.end_date USER_end_date
from
fnd_user fu,
fnd_responsibility_tl frtl,
fnd_user_resp_groups_direct furgd
where
fu.user_id=furgd.user_id and
frtl.responsibility_id=furgd.responsibility_id and
(fu.user_name=:user_name or frtl.responsibility_name=:responsibility_name)

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...