Dec 10, 2012

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;



No comments: