Search Function-Responsibility relation


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.