Query to check the responsibilities to a user
select fusr.user_name,
fr.responsibility_name,
fu.DESCRIPTION,
fu.START_DATE,
fu.END_DATE,
fu.RESPONSIBILITY_APPLICATION_ID,
fu.RESPONSIBILITY_ID,
fu.SECURITY_GROUP_ID,
fu.LAST_UPDATE_DATE,
fu.LAST_UPDATED_BY,
fu.CREATED_BY,
fu.CREATION_DATE,
fu.LAST_UPDATE_LOGIN,
fu.USER_ID
from FND_USER_RESP_GROUPS_DIRECT fu,
fnd_responsibility_tl fr,
fnd_user fusr
where fu.RESPONSIBILITY_ID = fr.Responsibility_Id
and fu.user_id = fusr.user_id
and fusr.user_name = &usrname
and nvl(fu.end_date,'31-Dec-4712') > sysdate
order by fu.user_Id,fu.end_date
Labels: Oracle applications, responsibilities
