Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to display menus, submenus & functions attached to responsibilities (11.5.10.2)  () 1 Vote
Query to display menus, submenus & functions attached to responsibilities [message #305748] Tue, 11 March 2008 18:48 Go to next message
discodisco
Messages: 2
Registered: March 2008
Junior Member
I am very new to this forum and to oracle applications.

I have a need to pull a list of all or specified responsibilities and all the menus, sub-menus and functions attached to that responsibility (as display while logging in using that responsibility).

Does any one have such a query already written ?

Thanks
Re: Query to display menus, submenus & functions attached to responsibilities [message #305953 is a reply to message #305748] Wed, 12 March 2008 07:12 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check this.

By
Vamsi
Re: Query to display menus, submenus & functions attached to responsibilities [message #306069 is a reply to message #305953] Wed, 12 March 2008 13:37 Go to previous messageGo to next message
discodisco
Messages: 2
Registered: March 2008
Junior Member
Thanks Vamsi. the link you sent doesn't address my requirement directly.

Re: Query to display menus, submenus & functions attached to responsibilities [message #306471 is a reply to message #306069] Fri, 14 March 2008 07:35 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Of course! It does.
Quote:
fnd_responsibility_vl
fnd_compiled_menu_functions
fnd_form_functions_vl
fnd_form_vl
By
Vamsi
Re: Query to display menus, submenus & functions attached to responsibilities [message #307930 is a reply to message #305748] Thu, 20 March 2008 07:15 Go to previous message
Dhruva
Messages: 9
Registered: August 2007
Junior Member
Vamsi has given right solution for this information and if you are new to Oracle apps, you can surely work around with SQL statements on views/table provided in previous post.
Previous Topic: SQL Script to get see the dates of a scheduled concurrent request
Next Topic: Concurrent Program - Oracle Apps
Goto Forum:
  


Current Time: Sun Dec 11 02:02:45 CST 2016

Total time taken to generate the page: 0.11676 seconds