SELECT t.profile_option_name,v.profile_option_value
FROM FND_PROFILE_OPTION_VALUES v, fnd_profile_options t,
fnd_profile_options_tl tl
where
v.profile_option_id = t.profile_option_id
and tl.profile_option_name =t.profile_option_name
and tl.user_profile_option_name like ‘&Profile_option_name’
FROM FND_PROFILE_OPTION_VALUES v, fnd_profile_options t,
fnd_profile_options_tl tl
where
v.profile_option_id = t.profile_option_id
and tl.profile_option_name =t.profile_option_name
and tl.user_profile_option_name like ‘&Profile_option_name’
Recent Posts