Query to List All User Role in EBS as it shows in Application

The following query list all the Role and responsibilities as they appears in the Application security screen, it remove all the duplicates


--select ur.*, wr.*  --from   APPLSYS.wf_user_role_assignments ur, apps.WF_ROLES wr
select distinct UR.USER_NAME, WR.DISPLAY_NAME, WR.description
--, WR.STATUS,ROLE_ORIG_SYSTEM
from   APPLSYS.wf_user_role_assignments ur, apps.WF_ROLES wr
where  1=1
--AND ROLE_NAME = ASSIGNING_ROLE
AND ROLE_ORIG_SYSTEM in ( 'FND_RESP', 'UMX')
AND wr.name=ur.role_name
--AND ur.user_name like 'USER%';