R12_Responsibility_With_Funtion

/* Formatted on 17-08-2011 16:01:37 (QP5 v5.115.810.9015) */
  SELECT   DISTINCT u.user_name,
                    rtl.RESPONSIBILITY_NAME,
                    ff.function_name,
                    ffl.user_function_name
    FROM   fnd_compiled_menu_functions cmf,
           fnd_form_functions ff,
           fnd_form_functions_tl ffl,
           fnd_responsibility r,
           fnd_responsibility_TL rtl,
           fnd_user_resp_groups urg,
           fnd_user u,
           hr_employees emp
   WHERE       cmf.function_id = ff.function_id
           AND r.menu_id = cmf.menu_id
           AND urg.responsibility_id = r.responsibility_id
           AND rtl.responsibility_id = r.responsibility_id
           AND cmf.GRANT_FLAG = 'Y'
           AND r.APPLICATION_ID = urg.RESPONSIBILITY_APPLICATION_ID
           AND u.user_id = urg.user_id
           --and ff.function_id=19438
           --AND UPPER (ffl.user_function_name) LIKE UPPER ('Agent%Dashboard')
           AND emp.EMPLOYEE_ID = u.EMPLOYEE_ID
           AND ff.function_id = ffl.function_id
ORDER BY   u.user_name