Thursday, April 10, 2008

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