Saturday, June 21, 2014

Get all the Responsibilities for Specific User

select frv.responsibility_name, fu.user_name
from
apps.fnd_user_resp_groups_direct furgd
,apps.fnd_user fu
,apps.fnd_responsibility_vl frv
where
user_name = 'OPERATIONS'--NUMBER
and fu.user_id = furgd.user_id
and frv.responsibility_id = furgd.responsibility_id

No comments:

Post a Comment