Gary, take out all reference to LOVs, leaving just the comma place holders with no space between. Also your use of double-quotes is redundant.
Here is an example of one of my queries, it works well -
SELECT
EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.QUESTION,
CASE
WHEN EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.ANSWER IS NULL
THEN 'Not provided'
WHEN substr(EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.ANSWER ,1,1) = '0'
THEN EMA@prompt('1 Select Instance','n',,MONO,FREE).OPTIONLISTITEM.NAME
ELSE EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.ANSWER
END,
EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.SURVDATA_SUBMITID,
EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.DATATABLENAME,
EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.SURVDATA_SUBMISSIONDATE,
to_number(to_char(( EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.SURVDATA_SUBMISSIONDATE ),'YYYY')),
to_char(( EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.SURVDATA_SUBMISSIONDATE ),'Mon'),
to_number(to_char(( EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.SURVDATA_SUBMISSIONDATE ),'DD'))
FROM
EMA@prompt('1 Select Instance','n',,MONO,FREE).OPTIONLISTITEM,
EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES
WHERE
( TRIM(UPPER((EMA@prompt('1 Select Instance','n',,MONO,FREE).OPTIONLISTITEM.OPTIONLISTITEMID (+))))=TRIM(UPPER(EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.ANSWER)) )
AND (
( EMA@prompt('1 Select Instance','n',,MONO,FREE).EMA_STG_RESPONSES.SURVEYID=substr(@Prompt('Select Survey','a,'Surveybase\Survey Name and ID',mono,constrained),-24) )
)
ORDER BY
6 DESC,
7 DESC,
8 DESC
Hope this helps 
Paul Shovlar
(BOB member since 2002-09-05)