fm.menu_name,
fr.responsibility_key
from fnd_form_functions_vl fffv,
fnd_menu_entries_vl fmev,
fnd_menus fm,
fnd_responsibility fr
where fffv.function_id = fmev.function_id
and fmev.menu_id = fm.menu_id
and fmev.menu_id = fr.menu_id(+)
and fffv.function_name LIKE '&function_name'
2.---------------------------查询报表所属的职责
select fcpt.user_concurrent_program_name,
frg.request_group_name,
fr.responsibility_key
from fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_request_groups frg,
fnd_responsibility fr
where fcpt.concurrent_program_id = frgu.request_unit_id
and frgu.request_group_id = frg.request_group_id
and frg.request_group_id = fr.request_group_id
and lower(fcpt.user_concurrent_program_name) like lower('&program_name')
转载：http://www.cnblogs.com/benio/archive/2010/12/31/1923185.html