Crystal Reports oracle sqlplus

Message


     I am new to crystal reports and I have created a query in oracle sqlplus that works great but when I plug it into the command option in Crystal XI, it doesn't work - no matter how I tweak it.  Any help would be welcomed.

This is from sqlplusw, the portion in red is where I am having trouble:
SELECT
    PERSON.SEARCHNAME,
    PERSON.DATEOFBIRTH,
    PERSON.EXTERNALID,
    RPTOBS.HDID,
    RPTOBS.OBSDATE,
    RPTOBS.OBSVALUE,
    PROBLEM.PID,
    PROBLEM.CODE,
    LOCREG.ABBREVNAME
FROM
    PERSON,
    PROBLEM,
    RPTOBS,
    LOCREG
WHERE
    PERSON.HOMELOCATION = LOCREG.LOCID
AND LOCREG.ABBREVNAME in ('APNCAS2', 'APNCCL')
AND PERSON.PID = PROBLEM.PID
AND PROBLEM.PID NOT IN (SELECT DISTINCT PID
                          FROM PROBLEM
                         WHERE CODE IN ('ICD-V17.5',
                                            'ICD-493.92',
                                            'ICD-493.91',
                                            'ICD-493.90',
                                            'ICD-493.82',
                                            'ICD-493.81',
                                            'ICD-493.22',
                                            'ICD-493.21',
                                            'ICD-493.20',
                                            'ICD-493.12',
                                            'ICD-493.10',
                                            'ICD-493.02',
                                            'ICD-493.01',
                                            'ICD-493.00'))
AND PERSON.PID = RPTOBS.PID
AND RPTOBS.HDID = 105310 
AND RPTOBS.OBSVALUE >'2' 
AND TO_CHAR(PERSON.DATEOFBIRTH, 'YYYY') >= TO_CHAR(SYSDATE - NUMTOYMINTERVAL(50, 'YEAR'), 'YYYY')
       AND TO_CHAR(PERSON.DATEOFBIRTH, 'YYYY') <= TO_CHAR(SYSDATE - NUMTOYMINTERVAL(12, 'YEAR'), 'YYYY')