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/