Flexfield security rule assignments to responsibility Query

转载于 2016-04-20 15:14:16 发布 · 168 阅读

本文将展示如何通过SQL查询来列出指定责任下所分配的所有安全规则，包括责任ID、名称、规则名称、规则参数等详细信息。

--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/