select distinct fus.user_name, fr.responsibility_name
from FND_USER_RESP_GROUPS_DIRECT fur,
FND_user fus,
fnd_responsibility_vl fr
where fur.RESPONSIBILITY_ID in (SELECT fr.RESPONSIBILITY_ID
FROM fnd_responsibility_vl fr,
fnd_menus fm,
fnd_compiled_menu_functions fmf,
fnd_form_functions_vl ff
WHERE fr.menu_id = fm.menu_id
AND ff.function_id = fmf.function_id
AND fmf.menu_id = fm.menu_id
AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
AND ff.user_function_name = :function_name)
AND nvl(fur.end_date,trunc(sysdate)) >= trunc(sysdate)
AND fus.USER_ID = fur.USER_ID
AND fr.responsibility_id = fur.responsibility_id
order by fus.user_name, fr.responsibility_name
Tags:
oracleapps
from FND_USER_RESP_GROUPS_DIRECT fur,
FND_user fus,
fnd_responsibility_vl fr
where fur.RESPONSIBILITY_ID in (SELECT fr.RESPONSIBILITY_ID
FROM fnd_responsibility_vl fr,
fnd_menus fm,
fnd_compiled_menu_functions fmf,
fnd_form_functions_vl ff
WHERE fr.menu_id = fm.menu_id
AND ff.function_id = fmf.function_id
AND fmf.menu_id = fm.menu_id
AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
AND ff.user_function_name = :function_name)
AND nvl(fur.end_date,trunc(sysdate)) >= trunc(sysdate)
AND fus.USER_ID = fur.USER_ID
AND fr.responsibility_id = fur.responsibility_id
order by fus.user_name, fr.responsibility_name
Tags:
4 comments:
Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com
Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.
Gramho is an Instagram account analyzer and viewer. Our algorithm gives you the possibility of analyzing your or other person's Instagram account statistics.
It is believed that the Italian recreation of baccara was based on the old Etruscan legend of a virgin who had to throw a nine-sided die. If she threw an 8 or a 9, then she was elevated to the glory 온라인카지노 of being a priestess. If she threw a 6 or 7, she was allowed to stay but could not participate in any future religious or neighborhood events.
Post a Comment