-- Change SYSADMIN to whatever you need
select distinct u.user_name, r.responsibility_name, g.start_date, g.end_date
from fnd_responsibility_tl r,
fnd_user_resp_groups g,
fnd_user u
where u.user_id = g.user_id
and r.application_id = g.responsibility_application_id
and r.responsibility_id = g.responsibility_id
and r.language = 'US'
and (sysdate between g.start_date and g.end_date or g.end_date is null)
and u.user_name = 'SYSADMIN'
order by r.responsibility_name;
Comments