Posted By

datelt on 04/22/09


Tagged

function R12


Versions (?)

Search Function-Responsibility relation


 / Published in: SQL
 

  1. SELECT fr.responsibility_name,
  2. fm.user_menu_name,
  3. fme.entry_sequence,
  4. fme.prompt,
  5. fme.description,
  6. fff.function_name,
  7. fff.user_function_name,
  8. fff.description
  9. FROM fnd_responsibility_vl fr,
  10. fnd_menus_vl fm,
  11. fnd_menu_entries_vl fme,
  12. fnd_form_functions_vl fff
  13. WHERE fm.menu_id = fr.menu_id
  14. AND fme.menu_id = fm.menu_id
  15. AND fff.function_id = fme.function_id
  16. AND fff.function_name = :function_name;

Report this snippet  

You need to login to post a comment.