首页 > 数据库技术 > 详细

Oracle EBS-SQL (SYS-12):查询各Profile的设置情况.sql

时间:2014-06-09 17:30:37      阅读:358      评论:0      收藏:0      [点我收藏+]

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(+)    --参数Profile,下面连个条件用一个即可   

        AND pro.user_profile_option_name LIKE ‘%‘ --Profile名称  

ORDER BY pro.profile_option_name,

                lev.level_type, lev.level_name;

Oracle EBS-SQL (SYS-12):查询各Profile的设置情况.sql,布布扣,bubuko.com

Oracle EBS-SQL (SYS-12):查询各Profile的设置情况.sql

原文:http://www.cnblogs.com/st-sun/p/3777616.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!