Advanced Search

Search Function-Responsibility relation

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

Expand | Embed | Plain Text

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.