select fr.responsibility_id,
fr.responsibility_name,
fu.user_name,
furgd. start_date,
furgd. end_date
from fnd_responsibility_tl fr,
fnd_user fu,
fnd_user_resp_groups_direct furgd
where fr.responsibility_id=furgd.responsibility_id
and fu. user_id = furgd. user_id
and fu. user_name= 'xxxxx';
or
select fr.responsibility_id,
fr.responsibility_name,
fu.user_name,
furgd. start_date,
furgd. end_date
from fnd_responsibility_tl fr,
fnd_user fu,
fnd_user_resp_groups_direct furgd
where fr.responsibility_id=furgd.responsibility_id
and fu. user_id = furgd. user_id
and fu. user_id=1032;
fr.responsibility_name,
fu.user_name,
furgd. start_date,
furgd. end_date
from fnd_responsibility_tl fr,
fnd_user fu,
fnd_user_resp_groups_direct furgd
where fr.responsibility_id=furgd.responsibility_id
and fu. user_id = furgd. user_id
and fu. user_name= 'xxxxx';
or
select fr.responsibility_id,
fr.responsibility_name,
fu.user_name,
furgd. start_date,
furgd. end_date
from fnd_responsibility_tl fr,
fnd_user fu,
fnd_user_resp_groups_direct furgd
where fr.responsibility_id=furgd.responsibility_id
and fu. user_id = furgd. user_id
and fu. user_id=1032;
No comments:
Post a Comment