Query to check assigned responsibility of FND User.

Query to check assigned responsibility of FND User.
—————————————————————-

select usr.user_id, usr.user_name, res.RESPONSIBILITY_ID, res.RESPONSIBILITY_NAME
from apps.FND_USER usr, apps.FND_RESPONSIBILITY_TL res, apps.FND_USER_RESP_GROUPS grp
where upper(res.RESPONSIBILITY_NAME) like upper(‘%’ || NVL(‘&EnterResponsibilityName’, ‘INV’)|| ‘%’)
and grp.responsibility_id = res.responsibility_id
and grp.user_id = usr.user_id;

  • January 23, 2019 | 13 views
  • Comments