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 Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...