List of Form Functions attached to Responsibility

List of Form Functions attached to Responsibility

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 UPPER (rtl.responsibility_name) LIKE '%TEST%'
           AND r.end_date IS NULL
           AND rtl.end_date IS NULL
ORDER BY   rtl.responsibility_name;