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博客 ” ，链接：https://blog.itpub.net/10359218/viewspace-751809/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
取供应商银行
下一篇：
UTL_DBWS包的安装步骤
请登录后发表评论
登录
全部评论
