select fu.user_name "User Name",
frt.responsibility_name "Responsibility Name"
from fnd_user fu,
fnd_user_resp_groups furg,
fnd_responsibility_tl frt,
fnd_application_tl fat
where fu.user_id = furg.user_id
and frt.application_id = fat.application_id
and furg.responsibility_application_id = frt.application_id
and furg.responsibility_id = frt.responsibility_id
and ltrim(rtrim(fu.user_name)) is not null
order by 1 asc nulls last;
frt.responsibility_name "Responsibility Name"
from fnd_user fu,
fnd_user_resp_groups furg,
fnd_responsibility_tl frt,
fnd_application_tl fat
where fu.user_id = furg.user_id
and frt.application_id = fat.application_id
and furg.responsibility_application_id = frt.application_id
and furg.responsibility_id = frt.responsibility_id
and ltrim(rtrim(fu.user_name)) is not null
order by 1 asc nulls last;
No comments:
Post a Comment