Tuesday 9 September 2014

From and Function with Responcibility attached the form Query

/* 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

No comments:

Post a Comment