Thursday, December 6, 2012

Oracle Apps: Query to fetch Responsibility associated with Function

SELECT fr.RESPONSIBILITY_NAME
  FROM fnd_responsibility_vl fr,
       fnd_menus fm,
       fnd_compiled_menu_functions fmf,
       fnd_form_functions_vl ff
 WHERE fr.menu_id = fm.menu_id
   AND ff.function_id = fmf.function_id
   AND fmf.menu_id = fm.menu_id
   AND ff.user_function_name = :function_name
   AND nvl(fr.end_date,trunc(sysdate)) >= trunc(sysdate)
   order by responsibility_name



oracleapps

No comments: