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