OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Query to display menus, submenus & functions attached to responsibilities

Home » Applications » Oracle Fusion Apps & E-Business Suite » Query to display menus, submenus & functions attached to responsibilities (11.5.10.2) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query to display menus, submenus & functions attached to responsibilities [message #305748]

Tue, 11 March 2008 18:48

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

Report message to a moderator

Re: Query to display menus, submenus & functions attached to responsibilities [message #305953 is a reply to message #305748]

Wed, 12 March 2008 07:12

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Check this.

By
Vamsi

Report message to a moderator

Re: Query to display menus, submenus & functions attached to responsibilities [message #306069 is a reply to message #305953]

Wed, 12 March 2008 13:37

discodisco
Messages: 2
Registered: March 2008

Junior Member

Thanks Vamsi. the link you sent doesn't address my requirement directly.

Report message to a moderator

Re: Query to display menus, submenus & functions attached to responsibilities [message #306471 is a reply to message #306069]

Fri, 14 March 2008 07:35

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Of course! It does.

Quote:

fnd_responsibility_vl
fnd_compiled_menu_functions
fnd_form_functions_vl
fnd_form_vl

By
Vamsi

Report message to a moderator

Re: Query to display menus, submenus & functions attached to responsibilities [message #307930 is a reply to message #305748]

Thu, 20 March 2008 07:15

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.

Report message to a moderator

Previous Topic:	SQL Script to get see the dates of a scheduled concurrent request
Next Topic:	Concurrent Program - Oracle Apps

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 17:58:15 CDT 2024