Home » Applications » Oracle Fusion Apps & E-Business Suite » Find the responsibility name
Find the responsibility name [message #148554] Thu, 24 November 2005 23:16 Go to next message
yram
Messages: 75
Registered: February 2001
Member
Hi

I have a form name example (ASXDSVOS), i want to find in which menu, responsibility it been associated with...

i want the navigation in 11.5.9 version... if possiable pls give me the query also...

Regards
Yram
Re: Find the responsibility name [message #148586 is a reply to message #148554] Fri, 25 November 2005 03:49 Go to previous message
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
Senior Member
The following query should give you the name of the responsibilities with a specified form together with the name of the top menu for that responsibility:

SELECT fr.responsibility_key
     , frt.responsibility_name
     , fm.menu_name
     , fmt.user_menu_name
  FROM fnd_responsibility fr
  JOIN fnd_responsibility_tl frt
    ON frt.responsibility_id = fr.responsibility_id
  JOIN fnd_menus fm
    ON fm.menu_id = fr.menu_id
  JOIN fnd_menus_tl fmt
    ON fmt.menu_id = fr.menu_id
 WHERE frt.language = 'US'
   AND fmt.language = 'US'
   AND fr.menu_id IN (  
            SELECT fme.menu_id
              FROM fnd_menu_entries fme
           CONNECT BY PRIOR fme.menu_id = fme.sub_menu_id
              START WITH function_id IN (               
                            SELECT fff.function_id
                              FROM fnd_form ff
                              JOIN fnd_form_functions fff
                                ON fff.form_id = ff.form_id
                             WHERE ff.form_name = '<form name>' ));


You can also use the nested subquery to find all the menus with the form or with a submenu with the form.

--
Aleksander Dragnes
Previous Topic: Message when standard form is opened in AR.
Next Topic: 11.5.10.2 issue
Goto Forum:
  


Current Time: Mon Dec 23 07:01:00 CST 2024