Saturday, December 18, 2021

Query to get the Menu Name in Oracle APPS

SELECT frt.responsibility_name
      ,fm.menu_id
      ,fm.menu_name
  FROM fnd_menus fm
      ,fnd_responsibility fr
  ,fnd_responsibility_tl frt
 WHERE fm.menu_id = fr.menu_id
   AND fr.responsibility_id = frt.responsibility_id
   AND fr.responsibility_id = frt.responsibility_id
   AND frt.responsibility_name = 'Receivables Manager'

4 comments:

Query to get the Concurrent Program along with Value Set details

SELECT fcpl1.user_concurrent_program_name       ,fdfcuv.end_user_column_name       ,ffvs.flex_value_set_name value_set_name       ,ffvt.appl...