Find Functions & Forms(Responsibility Wise)

SELECT fu.user_name,

         fu.description,

         furg.start_date,

         frvl.responsibility_name,

         fff.function_name,

         fff.user_function_name,

         ff.form_name,

         ff.user_form_name

    FROM fnd_user fu,

         fnd_user_resp_groups furg,

         fnd_responsibility_vl frvl,

         fnd_compiled_menu_functions fcmf,

         fnd_form_functions_vl fff,

         fnd_form_vl ff

   WHERE     fu.user_id = furg.user_id

         AND furg.responsibility_id = frvl.responsibility_id

         AND frvl.menu_id = fcmf.menu_id

         AND fff.function_id = fcmf.function_id

         AND fff.form_id = ff.form_id(+)

         AND fcmf.grant_flag = 'Y'

         AND fu.user_name = NVL (UPPER (:v_user_name), fu.user_name)

         AND frvl.responsibility_name = NVL (:v_resp_name, frvl.responsibility_name)

         AND (fu.end_date IS NULL OR fu.end_date >= SYSDATE)

         AND (furg.end_date IS NULL OR furg.end_date >= SYSDATE)

         AND (frvl.end_date IS NULL OR frvl.end_date >= SYSDATE)

ORDER BY frvl.responsibility_name, fff.user_function_name