Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, June 20, 2011

Pass The obtained Function id or function name to following query

SELECT
frv.responsibility_name,
frv.description
FROM
fnd_responsibility_vl frv,
fnd_form_functions fff
WHERE
fff.function_name = 'FND_FNDATDAG' ------Pass Function name Here
--f.form_id =p_form_id
AND frv.menu_id NOT IN
(
SELECT frf.action_id
FROM fnd_resp_functions frf
WHERE frf.action_id = frv.menu_id
AND frf.rule_type = 'M')
AND frv.menu_id IN (SELECT me.menu_id
FROM fnd_menu_entries me
START WITH me.function_id = fff.function_id
CONNECT BY PRIOR me.menu_id = me.sub_menu_id)
AND fff.function_id NOT IN (
SELECT frf.action_id
FROM fnd_resp_functions frf
WHERE frf.action_id = fff.function_id AND frf.rule_type = 'F'
)

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect