这篇文章将为大家详细讲解有关EBS查询用户客户化的文件配置是怎么样的,小编觉得挺实用的,因此分享给大家做个参考,希望大家阅读完这篇文章后可以有所收获。

selectpro.profile_option_name,pro.user_profile_option_name,lev.level_typetype,--lev.level_code,lev.level_name,prv.profile_option_valuefromapps.fnd_profile_options_vlpro,applsys.fnd_profile_option_valuesprv,(select10001level_id,'Site'level_type,0level_value,'Site'level_code,'Site'level_namefromdualunionallselect10002level_id,'App'level_type,app.application_idlevel_value,app.application_short_namelevel_code,app.application_namelevel_namefromapps.fnd_application_vlappunionallselect10003level_id,'Resp'level_type,resp.responsibility_idlevel_value,resp.responsibility_keylevel_code,resp.responsibility_namelevel_namefromapps.fnd_responsibility_vlrespunionallselect10004level_id,'User'level_type,usr.user_idlevel_value,usr.user_namelevel_code,usr.user_namelevel_namefromapplsys.fnd_userusr)levwherepro.profile_option_id=prv.profile_option_id(+)andprv.level_id=lev.level_id(+)andprv.level_value=lev.level_value(+)andpro.user_profile_option_namelike'KW%'--Profile名称orderbypro.profile_option_name,lev.level_type,lev.level_name;

关于“EBS查询用户客户化的文件配置是怎么样的”这篇文章就分享到这里了,希望以上内容可以对大家有一定的帮助,使各位可以学到更多知识,如果觉得文章不错,请把它分享出去让更多的人看到。