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

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...