职责的安全性配置文件设置检查

SELECT to_number(pov.profile_option_value)

      ,sec.security_profile_name

      ,re.responsibility_id

      ,re.description

  FROM fnd_profile_options       po

      ,fnd_profile_option_values pov

      ,fnd_responsibility_tl     re

      ,per_security_profiles_v   sec

 WHERE po.profile_option_name = 'XLA_MO_SECURITY_PROFILE_LEVEL'

   AND po.profile_option_id = pov.profile_option_id

   AND pov.level_id = 10003 --职责层

      -- AND pov.level_value = pi_resp_id;

   AND pov.level_value = re.responsibility_id

   AND re.language = 'ZHS'

   AND to_number(pov.profile_option_value) = sec.security_profile_id

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-751809/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10359218/viewspace-751809/