Oracle Database Discussions

select
distinct A.order_seq 
from v_order_line_item A, sales_hist_raw C
where a.order_seq = ( select B.order_seq from v_order B
                        where a.order_seq = B.order_seq
                     and C.cust_ref(+) = B.customer_number   )
               ;

ORA-01705: an outer join cannot be specified on a correlation column