/* Formatted on 9/9/2014 4:20:21 PM (QP5 v5.115.810.9015) */
SELECT DISTINCT
rtl.responsibility_name,
ff.function_name,
ffl.user_function_name,
form_name,
user_form_name
FROM fnd_compiled_menu_functions fcmf,
fnd_form_functions ff,
fnd_form_functions_tl ffl,
fnd_responsibility fr,
fnd_responsibility_tl rtl,
fnd_user_resp_groups urg,
fnd_user u,
fnd_form_vl form1
WHERE fcmf.function_id = ff.function_id
AND fr.menu_id = fcmf.menu_id
AND urg.responsibility_id = fr.responsibility_id
AND rtl.responsibility_id = fr.responsibility_id
AND fcmf.grant_flag = 'Y'
AND fr.application_id = urg.responsibility_application_id
AND u.user_id = urg.user_id
AND form1.form_id = ff.form_id
-- AND UPPER (ffl.user_function_name) = UPPER ('suppliers')
-- AND upper(ff.function_name) = upper('AP_APXVDMVD')
AND form_name = 'ARXCUDCI'
AND ff.function_id = ffl.function_id
SELECT DISTINCT
rtl.responsibility_name,
ff.function_name,
ffl.user_function_name,
form_name,
user_form_name
FROM fnd_compiled_menu_functions fcmf,
fnd_form_functions ff,
fnd_form_functions_tl ffl,
fnd_responsibility fr,
fnd_responsibility_tl rtl,
fnd_user_resp_groups urg,
fnd_user u,
fnd_form_vl form1
WHERE fcmf.function_id = ff.function_id
AND fr.menu_id = fcmf.menu_id
AND urg.responsibility_id = fr.responsibility_id
AND rtl.responsibility_id = fr.responsibility_id
AND fcmf.grant_flag = 'Y'
AND fr.application_id = urg.responsibility_application_id
AND u.user_id = urg.user_id
AND form1.form_id = ff.form_id
-- AND UPPER (ffl.user_function_name) = UPPER ('suppliers')
-- AND upper(ff.function_name) = upper('AP_APXVDMVD')
AND form_name = 'ARXCUDCI'
AND ff.function_id = ffl.function_id
No comments:
Post a Comment