Oracle 使用Exists 遇到的问题

系统订单查询功能 一段权限管控代码

 

 

大致代码为:

 

 select *
 from custorder_header a
 inner join custorder_detail b
 on a.order_no = b.order_no
 where 1 = 1 

 and a.order_no = 'A123456'
 and (exists (select 1 from view_statue where a.sendstation = name and typecode &