Hi Folks,
Below is the query to get User Profile Option.
/* How do get user level Profile option */
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_ID
