List Reponsibilities for an user

Wednesday, March 12th, 2008 at 10:01 pm by Jiltin
Filed under: 11i Scripts 

————————————————————————-
—     Author : Jayasankar Gopalakrishnan
————————————————————————-
select frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id, furg.*
from
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
where fu.user_name =upper( ‘&username’)
and   fu.user_id = furg.user_id
and   furg.responsibility_id = fr.RESPONSIBILITY_ID
and   frt.responsibility_id = fr.RESPONSIBILITY_ID
order by 1

Comments