ITPub博客

首页 > Linux操作系统 > Linux操作系统 > System profile

System profile

原创 Linux操作系统 作者:jarli 时间:2019-01-18 21:48:05 0 删除 编辑

查检某些权责System profile是否设定正确


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 'MO: Operating Unit'
--AND lev.level_name LIKE 'MRP_MPS資料維護%'
ORDER BY pro.profile_option_name, lev.level_type, lev.level_name;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/41594/viewspace-50514/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2003-03-27

  • 博文量
    23
  • 访问量
    12920