Return to Snippet

Revision: 13386
at April 22, 2009 05:23 by datelt


Updated Code
SELECT fr.responsibility_name,
       fm.user_menu_name,
       fme.entry_sequence,
       fme.prompt,
       fme.description,
       fff.function_name,
       fff.user_function_name,
       fff.description
  FROM fnd_responsibility_vl fr,
       fnd_menus_vl fm,
       fnd_menu_entries_vl fme,
       fnd_form_functions_vl fff
 WHERE fm.menu_id = fr.menu_id
   AND fme.menu_id = fm.menu_id
   AND fff.function_id = fme.function_id
   AND fff.function_name = :function_name;

Revision: 13385
at April 22, 2009 05:18 by datelt


Initial Code
fme.ENTRY_SEQUENCE,

Initial URL


Initial Description


Initial Title
Search Function-Responsibility relation

Initial Tags
function

Initial Language
SQL