Hi Ahmed Bilal,
This is muzibur rahman. I am a new member of ERPSTUFF. I have been using your queries in my day-to-day work. the Queries are very much useful and i am really thanking to you for your posting. I need a request from you.
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
(Assalamu Alaikkum)
How to Find function/form for given responsibility
-
- Posts: 8
- Joined: Tue Dec 19, 2006 6:42 am
- Location: Bahrain
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Hi Ahmed Bilal,
This is muzibur rahman. I am a new member of ERPSTUFF. I have been using your queries in my day-to-day work. the Queries are very much useful and i am really thanking to you for your posting. I need a request from you.
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
(Assalamu Alaikkum)
<i><div align="right">Originally posted by armujib - Sep 27 2007 : 06:21:20 AM</div id="right"></i>
Dear Rehamn,
Function is not attached to Responsibility .Functions are attached to Menu and Menu Assigned to Responsibility.
Script to check functions attached with Menu is provided in queries sections please check
Try below query:
select fff.function_name,ff.form_name,fm.menu_name,frv.responsibility_name
FROM FND_FORM_FUNCTIONS fff,
fnd_form ff,
fnd_menus fm,
fnd_compiled_menu_functions fcmf,
fnd_responsibility_vl frv,
fnd_user fu,
fnd_user_resp_groups furg
WHERE
ff.form_id = fff.form_id
AND fff.function_id = fcmf.function_id
AND fm.menu_id = fcmf.menu_id
AND fm.menu_id = frv.menu_id
AND fu.user_id = furg.user_id
AND furg.responsibility_id = frv.responsibility_id
AND frv.responsibility_id = 61007 -- enter the responsibility id for which you want to know the forms,function names
select fff.function_name,ff.form_name,fm.menu_name,frv.responsibility_name
FROM FND_FORM_FUNCTIONS fff,
fnd_form ff,
fnd_menus fm,
fnd_compiled_menu_functions fcmf,
fnd_responsibility_vl frv,
fnd_user fu,
fnd_user_resp_groups furg
WHERE
ff.form_id = fff.form_id
AND fff.function_id = fcmf.function_id
AND fm.menu_id = fcmf.menu_id
AND fm.menu_id = frv.menu_id
AND fu.user_id = furg.user_id
AND furg.responsibility_id = frv.responsibility_id
AND frv.responsibility_id = 61007 -- enter the responsibility id for which you want to know the forms,function names
Hi,
First u can find the form name, fucntion name ,and menu name after that u can easily find that responbilities,
Application Developer->Form -- query the form name and u can find the user form name, then go the function
Application Developer->function--Query the user form name and u can find the user function name , then go the menu
Application developer->Menu--query the User Function name ,and u can find the user Menu name , then go the Responsibilities then easily find the Responsibilities name.
Thanks
Sankar reddy
First u can find the form name, fucntion name ,and menu name after that u can easily find that responbilities,
Application Developer->Form -- query the form name and u can find the user form name, then go the function
Application Developer->function--Query the user form name and u can find the user function name , then go the menu
Application developer->Menu--query the User Function name ,and u can find the user Menu name , then go the Responsibilities then easily find the Responsibilities name.
Thanks
Sankar reddy
Who is online
Users browsing this forum: No registered users and 0 guests