select pro.profile_option_name, pro.user_profile_option_name, lev.level_type type, --lev.level_code, lev.level_name, prv.profile_option_value from apps.fnd_profile_options_vl pro, applsys.fnd_profile_option_values prv, (select 10001 level_id, 'Site' level_type, 0 level_value, 'Site' level_code, 'Site' level_name from dual union all select 10002 level_id, 'App' level_type, app.application_id level_value, app.application_short_name level_code, app.application_name level_name from apps.fnd_application_vl app union all select 10003 level_id, 'Resp' level_type, resp.responsibility_id level_value, resp.responsibility_key level_code, resp.responsibility_name level_name from apps.fnd_responsibility_vl resp union all select 10004 level_id, 'User' level_type, usr.user_id level_value, usr.user_name level_code, usr.user_name level_name from applsys.fnd_user usr) lev where pro.profile_option_id = prv.profile_option_id(+) and prv.level_id = lev.level_id(+) and prv.level_value = lev.level_value(+) and pro.user_profile_option_name like 'KW%' --Profile名称 order by pro.profile_option_name, lev.level_type, lev.level_name;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31558081/viewspace-2216397/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
EBS R12 查询EBS用户相关SQL
下一篇：
EBS查找运行请求时间，参数等
请登录后发表评论
登录
全部评论
