EBS queries what the user-customized file configuration looks like

This article will explain in detail how the file configuration of EBS query user customization is. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Select pro.profile_option_name,pro.user_profile_option_name,lev.level_type type,--lev.level_code,lev.level_name,prv.profile_option_valuefrom 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_namefrom dualunion allselect 10002 level_id,'App' level_type,app.application_id level_value App.application_short_name level_code,app.application_name level_namefrom apps.fnd_application_vl appunion allselect 10003 level_id,'Resp' level_type,resp.responsibility_id level_value,resp.responsibility_key level_code,resp.responsibility_name level_namefrom apps.fnd_responsibility_vl respunion allselect 10004 level_id,'User' level_type,usr.user_id level_value,usr.user_name level_code Usr.user_name level_namefrom applsys.fnd_user usr) levwhere 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 name order by pro.profile_option_name, lev.level_type, lev.level_name This is the end of this article on "EBS query user customized file configuration". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.