Friday, 12 June 2015

Users who have Access to a Particular Form


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

No comments:

Post a Comment