report query error.

I have a procedure that creates an AND or an OR statement appended to the where clause in a report. Depending on what the user enters into a parameter screen. I use the IN and OR command often in my lexical parameter.
My problem is when I use the outer join in my select statement in the report query I get an error.
Following is my query and the last AND and OR lines are from my lexical parameter.

SELECT DISTINCT spon_order_primary.spon_ord_no,

   spon_order_primary.acrn
FROM fnd_doc_primary,

           spon_order_primary,
           cust_order_primary,
           job_order_primary
WHERE fnd_doc_primary.fdp_id = spon_order_primary.fdp_id
      AND spon_order_primary.sop_id = cust_order_primary.sop_id(+)
      AND cust_order_primary.conp_id = job_order_primary.conp_id(+)
      AND spon_order_primary.spon_ord_no IN
('N0001999WXA201A','N0001999WXA5UEA')
       OR spon_order_primary.acrn IN ('AA','AB')
ORDER BY spon_order_primary.spon_ord_no,
                    spon_order_primary.acrn

**************THis resulted in the error ORA-01719: outer join operator (+) not allowed in operand of OR or IN It suggested using the following:
 (Select where(A+ and Not B)) UNION ALL (Select where (B)); I have tried without success the get this to work with my query, any suggestion?
Thanks in Advance
Diane
perkinsdt_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 24 2000 - 19:00:09 CEST