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;
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博客 ” ，链接：https://blog.itpub.net/22816976/viewspace-2084749/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- How to enable the MOAC parameter “Operating Unit” for a Concurrent Program
- EBS Signon Password Policies
- Password Policies in Oracle E-Business Suite
- R12 Mapping Between Subledger Tables, SLA and GL Tables
- General Ledger to Fixed Assests Drilldown
- Drilldown from GL to Receiving Transactions Query
- EBS R12.2.4 忘记weblogic密码问题 - 1
- EBS R12.2.4 忘记weblogic密码问题 - 2
- Change Weblogic admin password in Oracle EBS R12.2
- 如何永久关闭选项"Close Other Forms"
