Thursday, March 6, 2014

Get Form and Its Assigned responsibility in Oracle Apps R12

SELECT ffv.TYPE, ff.form_name, ffv.function_name, ffv.user_function_name,
       ffv.description, fm.menu_name, frl.responsibility_name,
       fme.entry_sequence, fme.prompt
  FROM fnd_form_functions_vl ffv,
       fnd_form ff,
       fnd_menu_entries_vl fme,
       fnd_menus fm,
       fnd_responsibility fr,
       fnd_responsibility_tl frl
 WHERE ff.form_id = ffv.form_id
   AND fme.function_id = ffv.function_id
   AND fm.menu_id = fme.menu_id
   AND fr.menu_id = fme.menu_id
   AND frl.responsibility_id = fr.responsibility_id
   AND ff.form_name = :form_name;

No comments:

Post a Comment