The only thing I can see is that there's a space between the d and ate in v.last_update_d ate Updated.

Lawrence Traub, DBA
877-325-7243 ext. 3798
972-820-3798
972-820-4003 (FAX)
4120 International Parkway
Carrollton, TX. 75007

-----Original Message-----
From: Nellakanti Sunitha [mailto:oracledba-ezmlmshield-x19441856.[Email address protected]
Sent: Thursday, May 29, 2008 9:18 AM
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 message is intended only for the use of the individual(s) or entity to which it is addressed and may contain information that is privileged, confidential, and/or proprietary to RealPage and its affiliated companies. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, forwarding or copying of this communication is prohibited without the express permission of the sender. If you have received this communication in error, please notify the sender immediately and delete the original message.

Oracle LazyDBA home page