Hi Folks,
Below
is the query to know the responsibility of user
SELECT fu.user_name, fu.start_date user_startdate, fu.end_date
user_enddate,
fr.responsibility_name, furgd.start_date, furgd.end_date,
fu.email_address,trunc(sysdate)
FROM fnd_user fu,
fnd_user_resp_groups_direct furgd,
fnd_responsibility_tl fr
WHERE
fr.responsibility_id = furgd.responsibility_id
AND fu.user_id = furgd.user_id
and
fu.user_name = :User_name
AND fr.LANGUAGE = 'US'
No comments:
Post a Comment