检查我的帖子：http://blog.csdn.net/pan_tian/article/details/7652968

1.    List E-Business Suite Profile Option Values For All Levels
2.    How to Search all of the Profile Options for a Specific Value
3.    How To Find All Users With A Particular Profile Option Set 

您的意思是实际的 Oracle 产品本身的配置文件，还是您正在从您的实现的实际表中查询这些值？

请验证。

配置文件选项有几件事情要搜索：-级别（站点，责任，...）-他们的技术名称（ABCDEFGH）-他们的用户名（设置为...）

下面的 SQL for Blitz ReportFND Profile Option Values应该做的伎俩。你会发现额外的 where 子句为不同的查询场景，例如通过该报告的页面上的配置文件选项值。

SQL 还显示通过自定义函数xxen_util.display_profile_option_value()转换的可见配置文件选项值。

select
fav0.application_name,
fpo.user_profile_option_name,
decode(fpov.level_id,10001,'Site',10002,'Application', 10003,'Responsibility', 10004,'User', 10005,'Server',10006,'Operating Unit',
10007,decode(to_char(fpov.level_value2),'-1','Responsibility',decode(to_char(fpov.level_value),'-1','Server','Server+Resp'))
) level_,
decode(fpov.level_id,10001,null,10002,fav.application_name,10003,frv.responsibility_name,10004,fu.user_name||nvl2(nvl(fu.description,fu.email_address),': '||nvl(fu.description,fu.email_address),null),10005,fn.node_name,10006,haou.name,
10007,decode(to_char(fpov.level_value2),'-1',frv.responsibility_name,decode(to_char(fpov.level_value),'-1',fn.node_name,fn.node_name||' - '||frv.responsibility_name))
) level_name,
xxen_util.display_profile_option_value(fpo.application_id,fpo.profile_option_id,fpov.profile_option_value) profile_option_value,
fpov.last_update_date,
fu2.user_name||nvl2(nvl(fu2.description,fu2.email_address),': '||nvl(fu2.description,fu2.email_address),null) last_updated_by,
fpov.profile_option_value system_profile_option_value,
fpo.profile_option_name system_profile_option_name,
fpo.profile_option_id,
fpov.level_value,
fpov.level_value2
from
fnd_application_vl fav0,
fnd_profile_options_vl fpo,
fnd_profile_option_values fpov,
fnd_responsibility_vl frv,
fnd_user fu,
fnd_application_vl fav,
fnd_user fu2,
hr_all_organization_units haou,
fnd_nodes fn
where
fav0.application_name=:application_name and
1=1 and
fav0.application_id=fpo.application_id and
fpo.profile_option_id=fpov.profile_option_id and
fpo.application_id=fpov.application_id and
decode(fpov.level_id,10002,fpov.level_value)=fav.application_id(+) and
case when fpov.level_id in (10003,10007) then fpov.level_value end=frv.responsibility_id(+) and
case when fpov.level_id in (10003,10007) then fpov.level_value_application_id end=frv.application_id(+) and
decode(fpov.level_id,10004,fpov.level_value)=fu.user_id(+) and
decode(fpov.level_id,10005,fpov.level_value,10007,fpov.level_value2)=fn.node_id(+) and
decode(fpov.level_id,10006,fpov.level_value)=haou.organization_id(+) and
fpov.last_updated_by=fu2.user_id
order by
fpo.user_profile_option_name,
fpov.level_id,
decode(fpov.level_id,10001,null,10002,fav.application_name, 10003,frv.responsibility_name, 10004,fu.user_name||nvl2(nvl(fu.description,fu.email_address),': '||nvl(fu.description,fu.email_address),null), 10005,fn.node_name,10006,haou.name)