--
select
fpob.ENTERPRISE_ID
, fpob.PROFILE_OPTION_NAME
, fpot.DESCRIPTION
, fpob.USER_ENABLED_FLAG
, fpob.USER_UPDATEABLE_FLAG
, fpob.SQL_VALIDATION
from
fnd_profile_options_B fpob
, fnd_profile_options_tl fpot
where
fpot.ENTERPRISE_ID = fpob.ENTERPRISE_ID
AND fpot.PROFILE_OPTION_NAME = fpob.PROFILE_OPTION_NAME
and fpot.LANGUAGE = 'US'
AND upper(fpob.PROFILE_OPTION_NAME) like ('%DOO%')
order by
2
, 1