Basic view of GL Security Rules assigned to a Responsibility

SELECT DISTINCT fatl.application_name "Module"

              , rtl.responsibility_name "Active Responsibility"

              , fvrtl.description "RULE"

           FROM applsys.fnd_flex_value_rules_tl fvrtl

              , applsys.fnd_flex_value_rule_usages fvru

              , applsys.fnd_responsibility_tl rtl

              , applsys.fnd_application_tl fatl

          WHERE fvrtl.flex_value_rule_id = fvru.flex_value_rule_id

            AND fvru.responsibility_id = rtl.responsibility_id

            AND fatl.application_id = rtl.application_id

            AND rtl.responsibility_name = :resp

       ORDER BY rtl.responsibility_name;