查看各个层级的配置文件

SELECTfr.responsibility_name,

       fp.USER_PROFILE_OPTION_NAME,

       t.profile_option_value

  FROM fnd_profile_option_values t,

       fnd_profile_options_vl    fp,

       fnd_responsibility_vl     fr

  WHERE t.profile_option_id = fp.profile_option_id

   AND fr.responsibility_id = t.level_value

   AND t.level_id = 10003 ; --责任层

LEVEL_ID = 10001 地点层,level_value 全部为0，不使用；
LEVEL_ID = 10002 应用层,level_value = application_id 应用id
LEVEL_ID = 10003 责任层,level_value = responsibility_id 责任id
LEVEL_ID = 10004 用户层,level_value = user_id 用户id