Friday, August 5, 2011

Query that shows all the repsonsibilities and what functions are attached to these responsibilities.

SELECT DISTINCT
faa.application_name application,

rtl.responsibility_name,
ffl.user_function_name,
ff.function_name,
ffl.description,
ff.TYPE
FROM fnd_compiled_menu_functions cmf,
fnd_form_functions ff,
fnd_form_functions_tl ffl,
fnd_responsibility r,
fnd_responsibility_vl rtl,
apps.fnd_application_all_view faa
WHERE cmf.function_id = ff.function_id
AND r.menu_id = cmf.menu_id
AND rtl.responsibility_id = r.responsibility_id
AND cmf.grant_flag = 'Y'
AND ff.function_id = ffl.function_id
AND faa.application_id(+) = r.application_id
AND r.end_date IS NULL
AND rtl.end_date IS NULL
ORDER BY rtl.responsibility_name;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect