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

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...