select Q.YPQLDH,B.ZWXM00,to_date(Q.QLRQ00||Q.QLSJ00,'YYYYMMDDHH24:MI:SS')as QLRQ00,to_date(Q.QRRQ00||Q.QRSJ00,'YYYYMMDDHH24:MI:SS') as QRRQ00,Q.BZ0000,'0' FLAG00, 
(select ZWXM00||'/'||XKH000 from BM_YGBM00 where YGBH00=Q.CZYBH0 and rownum=1) as CZYXM0,
(select ZWXM00||'/'||XKH000 from BM_YGBM00 where YGBH00=Q.QRRBH0 and rownum=1) as QRYXM0,
A.BMMC00 CKQXMC,C.CKLXMC,Q.DYCS00,Q.CKLXBH,Q.WZQTSX from YK_YPQLD0 Q,BM_YGBM00 B,VW_YK_YPCKQX A,BM_YKCKLX C  where Q.QLZT00 in ('1','2')
 and ( Q.CXBZ00 not in ('+','-')) 
 and Q.YKBMBH=2279
 and (Q.CKQXBH=-1 or -1=-1)
 and Q.LYRBH0=B.YGBH00(+)
 and Q.CKLXBH=C.CKLXBH 
 and C.CKDLX0='Y' 
 and Q.SFSH00='N'
 and Q.CKQXBH=A.BMBH00
 and Q.QRRQ00>='20201009' and  Q.QRRQ00<='20201015'
 order by Q.YPQLDH