首页 > 代码库 > 查找配置文件设的值

查找配置文件设的值

SELECT t.user_profile_option_name us_name,
       l.user_profile_option_name zhs_name,
       decode(v.level_id,
              10001,
              ‘地点层‘,
              10002,
              ‘应用层‘,
              10003,
              ‘职责层‘,
              10004,
              ‘用户层‘,
              10005,
              ‘服务器层‘,
              10006,
              ‘组织层‘,
              ‘其它‘) level_name,
       decode(v.level_id,
              10002,
              (SELECT application_name
                 FROM apps.fnd_application_vl
                WHERE application_id = v.level_value),
              10003,
              (SELECT responsibility_name
                 FROM apps.fnd_responsibility_vl
                WHERE responsibility_id = v.level_value
                  AND application_id = v.level_value_application_id),
              10004,
              (SELECT user_name FROM apps.fnd_user WHERE user_id = v.level_value),
              10005,
              (SELECT node_name FROM apps.fnd_nodes WHERE node_id = v.level_value),
              10006,
              (SELECT NAME FROM apps.hr_operating_units WHERE organization_id = v.level_value),
              v.level_value) level_value,
       v.profile_option_value,
       u.user_name,
       v.last_update_date
  FROM apps.fnd_profile_options_vl    t,
       apps.fnd_profile_options_tl    l,
       apps.fnd_profile_option_values v,
       apps.fnd_user                  u
 WHERE t.application_id = v.application_id
   AND t.profile_option_id = v.profile_option_id
   AND t.profile_option_name = l.profile_option_name
   AND l.LANGUAGE = ‘ZHS‘
   AND u.user_id = v.last_updated_by
   AND t.start_date_active <= SYSDATE
   AND nvl(t.end_date_active, SYSDATE) >= SYSDATE
   AND user_id NOT IN (-1, 0, 1, 2, 3, 4, 5, 6, 7)
   and t.USER_PROFILE_OPTION_NAME = ‘CUX:特批权限控制‘
 ORDER BY t.user_profile_option_name;

查找配置文件设的值