Query to find GL Flexfield security rule assignments

The following query will list all GL Flexfield Security Rule Assignments to Responsibilities.

-------------------------------------------------------------------------------

-- Query to find GL Flexfield security rule assignments to responsibilities

-------------------------------------------------------------------------------

SELECT a.application_name          "Application Name",

       fvr.flex_value_rule_name    "Flex Value Rule",

       r.responsibility_key        "Responsibility"

  FROM fnd_flex_value_rules        fvr,

       fnd_flex_value_rule_usages  ru,

       fnd_responsibility          r,

       fnd_application_tl          a

 WHERE fvr.flex_value_rule_id = ru.flex_value_rule_id

   AND ru.responsibility_id   = r.responsibility_id

   AND ru.application_id      = a.application_id

   AND fvr.flex_value_rule_name LIKE '%'   -- <change it>

 ORDER BY flex_value_rule_name;