SQL to see profile option value

elect lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'Site' lo

, 'SITE' lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.application_id = fpov.application_id

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and fpot.language = Userenv('Lang')

and fpov.level_id = 10001 /* Site Level */

union all

select lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'Apps' lo

, fa.application_name lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

, FND_APPLICATION_TL fa

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and fpot.language = Userenv('Lang')

and fpov.level_id = 10002 /* Application Level */

and fpov.level_value = fa.application_id

union all

select lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'Resp' lo

, frt.responsibility_name lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

, FND_RESPONSIBILITY_TL frt

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and frt.language = Userenv('Lang')

and fpot.language = Userenv('Lang')

and fpov.level_id = 10003 /* Responsibility Level */

and fpov.level_value = frt.responsibility_id

and fpov.level_value_application_id = frt.application_id

union all

select lpad(fpo.profile_option_name,55) pon

, lpad(fpot.user_profile_option_name,55) upon

, fpot.description d

, lpad(fpo.start_date_active,15) sda

, lpad(fpo.end_date_active,15) eda

, lpad(fpo.creation_date,15) cd

, lpad(fu.user_name,20) cb

, 'User' lo

, fu2.user_name lov

, fpov.profile_option_value pov

from FND_PROFILE_OPTIONS_TL fpot

, FND_PROFILE_OPTIONS fpo

, FND_PROFILE_OPTION_VALUES fpov

, FND_USER fu

, FND_USER fu2

where fpot.user_profile_option_name like '&&profile_like'

and fpot.profile_option_name = fpo.profile_option_name

and fpo.profile_option_id = fpov.profile_option_id

and fpo.created_by = fu.user_id

and fpov.level_id = 10004 /* User Level */

and fpov.level_value = fu2.user_id

and fpot.language = Userenv('Lang')

order by upon, lo, lov