Saturday, January 29, 2022

Query to get all menu names 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'

No comments:

Post a Comment