Flexfield security rule assignments to responsibility Query

--the following query will list all the security rules assigned to a responsibility
SELECT fr.responsibility_id 
      ,fr.responsibility_key 
      ,fr.responsibility_name 
      ,ffvr.flex_value_rule_name 
      ,ffvrl.include_exclude_indicator 
      ,ffvrl.flex_value_low 
      ,ffvrl.flex_value_high 
FROM   fnd_responsibility_vl      fr 
      ,fnd_flex_value_rule_usages ffvru 
      ,fnd_flex_value_rules_vl    ffvr 
      ,fnd_flex_value_rule_lines  ffvrl 
WHERE  fr.responsibility_id = ffvru.responsibility_id 
AND    ffvru.flex_value_rule_id = ffvr.flex_value_rule_id 
AND    ffvr.flex_value_rule_id = ffvrl.flex_value_rule_id 
AND    fr.responsibility_name = '&resp_name’ 
ORDER  BY fr.responsibility_id 
         ,ffvr.flex_value_rule_name 
         ,ffvrl.include_exclude_indicator DESC 
         ,ffvrl.flex_value_low 
         ,ffvrl.flex_value_high;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22816976/viewspace-2084749/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22816976/viewspace-2084749/