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'
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down

Drilldown from GL to Inventory Transactions, Inv to gl Link Query R12,Inventory to General ledger links, r12 ,Inv to gl drill down Link bet...

  • How to improve blog performance
    Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...
  • Query to Get Profile value at any level
    Query to Get Profile value at any level   SELECT    distinct pot.user_profile_option_name Profile,    DECODE (     a.profile_option_value, ...
  • Types of animations
    Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...