EBS 查看配置文件的值

select distinct t.user_profile_option_name "Profile Option Name",
                decode(v.level_id,
                       10001,
                       'Site Level',
                       10002,
                       'Application Level --> ' || application_name,
                       10003,
                       'Responsibility level-->' || responsibility_name,
                       10004,
                       'User Level-->' || u.user_name,
                       'XXX') "Profile Option Level",
                profile_option_value "Value"
  from fnd_profile_options       o,
       fnd_profile_option_values v,
       fnd_profile_options_tl    t,
       fnd_responsibility_tl     r,
       fnd_application_tl        a,
       fnd_user                  u
 where o.profile_option_id = v.profile_option_id
   and o.application_id = v.application_id
   and start_date_active <= SYSDATE
   and nvl(end_date_active, SYSDATE) >= SYSDATE
   and o.profile_option_name = t.profile_option_name
   and a.application_id(+) = decode(level_id, 10002, level_value, null)
   and r.responsibility_id(+) = decode(level_id, 10003, level_value, null)
   and u.user_id(+) = decode(level_id, 10004, level_value, null)
      --and nvl(u.end_date, sysdate) >= sysdate
   and t.user_profile_option_name = 'Printer'
 order by 2, --v.level_id,
          t.user_profile_option_name,
          decode(v.level_id,
                 10001,
                 'Site Level',
                 10002,
                 'Application Level --> ' || application_name,
                 10003,
                 'Responsibility level-->' || responsibility_name,
                 10004,
                 'User Level-->' || u.user_name,
                 'XXX');