Oracle EBS 数据访问权限集

SELECT frv.responsibility_name, 
       fpo.profile_option_name,
       fpo.user_profile_option_name,
       fpv.profile_option_value,
       CASE
         WHEN fpo.profile_option_name = 'GL_SET_OF_BKS_ID' THEN
          (SELECT t.name
             FROM gl_ledgers t
            WHERE t.ledger_id = fpv.profile_option_value
              AND rownum = 1)
         WHEN fpo.profile_option_name = 'GL_ACCESS_SET_ID' THEN
          (SELECT t.name
             FROM gl_access_sets t
            WHERE t.access_set_id = fpv.profile_option_value
              AND rownum = 1)
         WHEN fpo.profile_option_name IN ('XLA_MO_SECURITY_PROFILE_LEVEL',
                                          'FA_SECURITY_PROFILE_ID') THEN
          (SELECT tt.security_profile_name
             FROM per_security_profiles tt
            WHERE tt.security_profile_id = fpv.profile_option_value
              AND rownum = 1)
         ELSE
          fpv.profile_option_value
       END AS profile_option_value_desc

  FROM fnd_profile_option_values fpv,
       fnd_profile_options_vl    fpo,
       fnd_responsibility_vl     frv
 WHERE fpv.level_id = 10003
   AND fpv.profile_option_id = fpo.profile_option_id
   AND fpv.application_id = fpo.application_id
      --AND fpo.USER_PROFILE_OPTION_NAME = 'MO：安全性配置文件'
   AND fpv.level_value = frv.responsibility_id
   AND frv.responsibility_name LIKE '10%';

 

转载于:https://www.cnblogs.com/jenrry/p/10007148.html