How to find list of Users assigned to a responsibility
select
u.description name,u.user_name logon,
t.description,
t.responsibility_name,
d.start_date resp_start_date,
last_logon_date,
u.creation_date,
email_address
from apps.fnd_user u,
apps.fnd_responsibility r,
apps.fnd_user_resp_groups_direct d,
apps.fnd_responsibility_vl t
where t.responsibility_id=d.responsibility_id
and u.user_id=d.user_id
and d.responsibility_id=r.responsibility_id
and (t.end_date is null or t.end_date > sysdate)
and (u.end_date is null or u.end_date > sysdate)
and u.description <> '1'
and (d.end_date is null or d.end_date > sysdate)
and upper(t.responsibility_name) like '%PAYABLES%'
order by 1,3;
u.description name,u.user_name logon,
t.description,
t.responsibility_name,
d.start_date resp_start_date,
last_logon_date,
u.creation_date,
email_address
from apps.fnd_user u,
apps.fnd_responsibility r,
apps.fnd_user_resp_groups_direct d,
apps.fnd_responsibility_vl t
where t.responsibility_id=d.responsibility_id
and u.user_id=d.user_id
and d.responsibility_id=r.responsibility_id
and (t.end_date is null or t.end_date > sysdate)
and (u.end_date is null or u.end_date > sysdate)
and u.description <> '1'
and (d.end_date is null or d.end_date > sysdate)
and upper(t.responsibility_name) like '%PAYABLES%'
order by 1,3;
Comments
Post a Comment