某个系统配置文件 用户层的SQL

 SELECT fpo.user_profile_option_name,
        fpv.level_id,
        fpv.level_value,
        fpv.profile_option_value,
        fu.user_name,
        flvv.MEANING
   FROM apps.fnd_profile_option_values fpv,
        apps.fnd_profile_options_vl    fpo,
        fnd_lookup_values_vl           flvv,
        fnd_user                       fu
  WHERE fpv.application_id = fpo.application_id
    AND fpv.profile_option_id = fpo.profile_option_id
    AND fpo.user_profile_option_naME = 'CUX:收款通知单(角色分配)'
    and fpv.profile_option_value = flvv.LOOKUP_CODE
    and fpv.level_value = fu.user_id
    and fpv.level_id = 10004

相关内容参照http://hgdzhuanyong.blog.163.com/blog/static/117191383201222252538819/