Post date: Aug 06, 2013 8:10:37 AM
SELECT
e.entry_sequence,
e.function_id ,
f.function_name ,
e.prompt ,
e.description ,
e.creation_date
FROM fnd_menus_vl m ,
fnd_menu_entries_vl e ,
fnd_form_functions_vl f,
fnd_responsibility_vl r
WHERE r.responsibility_name = '&responsibility_name'
AND r.menu_id = m.menu_id
AND m.menu_id = e.menu_id
AND e.function_id = f.function_id
ORDER BY e.entry_sequence;