Wednesday, May 6, 2015

Query to get User name and related assigned responsibilities

select fu.user_name "User Name",
         frt.responsibility_name  "Responsibility Name"
 from fnd_user fu,
         fnd_user_resp_groups furg,
         fnd_responsibility_tl frt,
         fnd_application_tl fat
where fu.user_id = furg.user_id
   and frt.application_id = fat.application_id
   and furg.responsibility_application_id = frt.application_id
   and furg.responsibility_id = frt.responsibility_id
   and ltrim(rtrim(fu.user_name)) is not null
order by 1 asc nulls last;