Query to find 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 '%XXXXXX%'
ORDER BY flex_value_rule_name;