Hi,

Is there something wrong with this SQL, I get message 'Keyword not
found'

select z.USER_PROFILE_OPTION_NAME Profile,
nvl(v.PROFILE_OPTION_VALUE,'Replace with non-virtual URL') Value,
v.last_update_d
ate Updated
from fnd_profile_options t, fnd_profile_option_values v,
fnd_profile_options_tl z
where (v.PROFILE_OPTION_ID (+) = t.PROFILE_OPTION_ID)
and (z.PROFILE_OPTION_NAME = t.PROFILE_OPTION_NAME)
and (t.PROFILE_OPTION_NAME in
('APPS_FRAMEWORK_AGENT','WF_MAIL_WEB_AGENT'));

Thanks
Sunitha


***
This electronic mail message, including attachments, is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any unauthorized use, review, disclosure, distribution, or actions taken in reliance on the contents of this information, is prohibited. If you received this e-mail in error and are not the intended recipient, please notify me immediately by telephone or reply e-mail and destroy all copies of the original message.
***


Oracle LazyDBA home page