Thursday, December 6, 2012

Oracle Apps: Query to Fetch Users using Responsibilities having a specific function

  select distinct fus.user_name, fr.responsibility_name
         FND_user fus,
         fnd_responsibility_vl fr
                                      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



rajeev said...

Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check

Smith said...

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 for Never Before Offers and Discount Coupon Codes.

Susan said...

Gramho is an Instagram account analyzer and viewer. Our algorithm gives you the possibility of analyzing your or other person's Instagram account statistics.

g898n033v4 said...

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.