User & Responsibility PLSQL Query - Oracle EBS R12

http://systemadministratorsys.blogspot.com/2016/06/user-responsibility-menu-request-group.html

User & Responsibility PLSQL Query

select jj.user_id, tt.USER_NAME, kk.RESPONSIBILITY_NAME, hh.MENU_NAME , ll.REQUEST_GROUP_NAME
from  FND_USER_RESP_GROUPS_DIRECT jj,
FND_USER tt, fnd_responsibility_vl kk, fnd_menus_vl hh, fnd_request_groups ll
where 1=1
and tt.USER_ID=jj.user_id
and jj.RESPONSIBILITY_ID=kk.RESPONSIBILITY_ID
and kk.MENU_ID=hh.MENU_ID
and ll.REQUEST_GROUP_ID(+)=kk.REQUEST_GROUP_ID
and tt.USER_NAME in ('Virat')
and jj.END_DATE is null
order by tt.USER_NAME

--------------------------------------------------------------------------------------------------------

select tt.USER_NAME,
       tt.DESCRIPTION,
       hh.APPLICATION_NAME,
       kk.RESPONSIBILITY_NAME,
       jj.START_DATE,
       jj.END_DATE
     
  from FND_USER                    tt,
       FND_USER_RESP_GROUPS_DIRECT jj,
       fnd_responsibility_vl       kk,
       fnd_application_vl          hh
 where 1 = 1
   and kk.APPLICATION_ID = hh.APPLICATION_ID
   and tt.USER_ID = jj.user_id
   and jj.RESPONSIBILITY_ID = kk.RESPONSIBILITY_ID
   and tt.END_DATE <= '30-JUN-2016'
  --- and tt.USER_NAME like 'Vir%'
   order by tt.USER_name, hh.APPLICATION_NAME, kk.RESPONSIBILITY_NAME