HI Folks,
To check
user profile value's through query.
SELECT
p.user_profile_option_name, '3 - User', u.user_name, v.level_value,
v.profile_option_value
FROM fnd_profile_option_values v, fnd_profile_options_vl p, fnd_user u
WHERE v.profile_option_id = p.profile_option_id
AND (v.level_id = 10004 AND u.user_id = v.level_value)
AND u.user_name = :'User_ Name'
--AND
P.USER_PROFILE_OPTION_NAME LIKE '%FND: View Object Max Fetch Size%'
ORDER BY
1, 2, 3
No comments:
Post a Comment