QUERY TO FIND LIST OF RESPONSIBILITIES ASSIGNED TO A PARTICULAR USER

LIST OF RESPONSIBILITIES ASSIGNED TO A PARTICULAR USER
=======================================================

select Distinct frt.RESPONSIBILITY_NAME, furg.end_date
from
APPS.FND_USER_RESP_GROUPS FURG,
APPS.FND_RESPONSIBILITY FR,
APPS.FND_RESPONSIBILITY_TL FRT,
APPS.fnd_user fu
where fu.user_name = '&&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

========================================================================

select * from apps.fnd_responsibility_tl
where LANGUAGE='US' AND responsibility_name like '%%PRICING%';

===================================================================

select --fu.user_name,
frt.responsibility_name
from APPS.fnd_user fu,
APPS.fnd_user_resp_groups furg,
APPS.fnd_responsibility fr,
APPS.fnd_responsibility_tl frt
where fu.user_id = furg.user_id
and fu.user_name ='XXXXYBD'
and furg.responsibility_id = fr.responsibility_id
and fr.responsibility_id = frt.responsibility_id

Post a Comment