— This is to list the  Apps
User who are assigned a particular responsibility

select a.user_name,b.responsibility_name 
from
fnd_user a,fnd_responsibility_vl b ,FND_USER_RESP_GROUPS c
where
a.user_id = c.user_id
and
c.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
and lower(b.responsibility_name) like lower(‘&Responsibility_name%’)
and a.END_DATE is null
and
(c.END_DATE is null
or
c.end_date > sysdate)
group by a.USER_NAME,b.RESPONSIBILITY_NAME
Recommended Posts

Start typing and press Enter to search