Thursday, September 4, 2008

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: