Find the responsibility name [message #148554] |
Thu, 24 November 2005 23:16 |
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 |
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
|
|
|