Could it be the space in v.last_update_d ate, or is that just the way your
code's copied in?

Michael Peel


-----Original Message-----
From: Nellakanti Sunitha
[mailto:oracledba-ezmlmshield-x19441856.[Email address protected]
Sent: 29 May 2008 15:18
To: LazyDBA Discussion
Subject: SQL Help

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.
***



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page