select fu.user_name, frt.RESPONSIBILITY_NAME, furg.end_date
from
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
where fu.user_id = furg.user_id
and furg.responsibility_id = fr.RESPONSIBILITY_ID
and frt.responsibility_id = fr.RESPONSIBILITY_ID
order by 1;
Above query is to list the user with responsibility in Oracle Apps
No comments:
Post a Comment