查詢使用者客戶化的檔案配置

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,