Home » Applications » Oracle Fusion Apps & E-Business Suite » How to Find function/form for given responsibility
How to Find function/form for given responsibility [message #270549] Thu, 27 September 2007 08:25 Go to next message
mujjbur
Messages: 13
Registered: August 2007
Junior Member
Hi Members/Experts,

This is muzibur rahman. I am a new member of OraFAQ Forum.I need a request from you all.

I have list of Responsibility Names.

I want to find the Functions and Form Names in which those responsibilities are attached to.

Please help me in this regard. Please provide me the Script if possible.

Regards,

Muzibur Rahman
Re: How to Find function/form for given responsibility [message #270579 is a reply to message #270549] Thu, 27 September 2007 10:55 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
You should search the forum first.

By
Vamsi
Re: How to Find function/form for given responsibility [message #271846 is a reply to message #270579] Wed, 03 October 2007 02:50 Go to previous messageGo to next message
mujjbur
Messages: 13
Registered: August 2007
Junior Member
Vamsi,

I have searched the forum, i didnt get any such solutions for this. Kindly help me in this regard.

By
Muzibur
Re: How to Find function/form for given responsibility [message #272015 is a reply to message #271846] Wed, 03 October 2007 11:46 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Did you check my link, which I have posted above?

By
Vamsi
Re: How to Find function/form for given responsibility [message #273977 is a reply to message #272015] Fri, 12 October 2007 08:57 Go to previous messageGo to next message
mujjbur
Messages: 13
Registered: August 2007
Junior Member
Vamsi,

I have checked your link. I am getting so many other necessary information. But i am not getting the exact thing what i want. Please post the query. My work is about to escalate now. Please help me.

Regards,

Muzibur.
Re: How to Find function/form for given responsibility [message #273979 is a reply to message #273977] Fri, 12 October 2007 09:16 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:

I am getting so many other necessary information
necessary or unnecessary? If it is necessary, what is your problem?
Quote:

But i am not getting the exact thing what i want.
What do you want exactly?
Quote:

My work is about to escalate now.
What did you do till now? Post your query.

By
Vamsi
Re: How to Find function/form for given responsibility [message #274340 is a reply to message #273979] Mon, 15 October 2007 11:56 Go to previous messageGo to next message
altasen.com
Messages: 38
Registered: November 2005
Member
Hi,

indeed in the link the second post does give a nice query. Unfortunately Oracle does not give a standard Report for this. Just run the query and give it a try.

Roel
http://www.altasen.com Oracle Application Books
Re: How to Find function/form for given responsibility [message #274591 is a reply to message #273979] Tue, 16 October 2007 09:07 Go to previous messageGo to next message
mujjbur
Messages: 13
Registered: August 2007
Junior Member
Hi Vamsi,

I am herewith posting the query

SELECT FFF.FUNCTION_NAME, FF.FORM_NAME, FR.RESPONSIBILITY_NAME
FROM FND_RESPONSIBILITY_VL FR, FND_MENU_ENTRIES_VL FME,
FND_FORM_FUNCTIONS_VL FFF, FND_FORM_VL FF
WHERE FR.MENU_ID = FME.MENU_ID
AND FME.MENU_ID = FME.SUB_MENU_ID
AND FME.FUNCTION_ID = FFF.FUNCTION_ID
AND FFF.FORM_ID = FF.FORM_ID
AND FR.RESPONSIBILITY_NAME = '&RESP_NAME'

Please help me in this query.

Please modify the query if required and post your query.

Thanks & Regards,

Muzibur

Re: How to Find function/form for given responsibility [message #274929 is a reply to message #274591] Wed, 17 October 2007 14:04 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Can't you change your code, which is in your other post, to get the desired?
Removing the tables fnd_user and fnd_user_resp_groups and the condition on form_name and putting on responsibility_name will work for you.

By
Vamsi
Previous Topic: invoices onhold report
Next Topic: any additional interfaces
Goto Forum:
  


Current Time: Sat Dec 10 18:27:35 CST 2016

Total time taken to generate the page: 0.09850 seconds