Thursday, July 21, 2016

Query to Compare Responsibility between users

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 ='xxxx'
and furg.responsibility_id = fr.responsibility_id
and fr.responsibility_id = frt.responsibility_id
minus
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 ='yyyy'
and furg.responsibility_id = fr.responsibility_id
and fr.responsibility_id = frt.responsibility_id
;

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...