Thursday 17 July 2014

Users who have Access to a Particular Form Query

/* Formatted on 7/17/2014 5:37:50 PM (QP5 v5.115.810.9015) */
SELECT a.menu_id,
       menu_name,
       c.responsibility_name,
       g.user_name,
       g.description
FROM fnd_menu_entries a,
     fnd_menus b,
     fnd_responsibility_vl c,
     fnd_form_functions d,
     fnd_form_vl e,
     fnd_user_resp_groups f,
     fnd_user g
WHERE     e.form_name LIKE '%'
      AND e.form_id = d.form_id
      AND d.function_id = a.function_id
      AND a.menu_id = b.menu_id
      AND a.menu_id = c.menu_id
      AND c.responsibility_id = f.responsibility_id
      AND f.user_id = g.user_id
ORDER BY 1, 2, 3, 4

1 comment:

  1. Thanks For sharing this Superb article.I use this Article to show my assignment in college.it is useful For me Great Work. buy biometric access control

    ReplyDelete