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
;
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