SELECT (Select BRZJBH from BM_BRXXB0 WHERE brid00=c.brid00) BRZJBH,
 (Select BRLXXM from BM_BRXXB0 WHERE brid00=c.brid00) BRLXXM, 
 (Select LXRSFZ from BM_BRXXB0 WHERE brid00=c.brid00) LXRSFZ, 
C.CFLSH0,C.ZYH000,C.BRXM00,C.CH0000,C.XB0000,C.DQKS00,C.BRID00,
C.CSRQ00,C.YSXM00,C.ZYTS00,C.BZMC00,C.BRDZ00,C.SFKSLY,C.DQBQ00,substr(SF_YF_GETALLZYZD(C.ZYID00,c.CFLSH0),1,127) RYZD00,
C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.CFSRBZ,G.ZWXM00 AS LRY000,C.ZYID00,C.DMCFBH,
(select substrb(SF_BQ_CSRQTONL(C.CSRQ00,a.SJRYRQ),1,30) from ZY_BRXXB0 a where a.BRID00=c.BRID00 and a.ZYID00=C.ZYID00 and rownum=1)  BRNL00,
C.YEXM00 
 FROM YF_ZYCF00 C,BM_YGBM00 G
 WHERE C.ZYH000='45404101'
 and ((C.SFKSLY='-1') or ('-1'='-1')) 
 AND C.SRRQ00>='20211102' AND C.SRRQ00<='20211102'
 AND C.YFBMBH=45
 AND ((C.CFZT00 in ('0')
 AND C.BCCFH0 IS NULL)
 OR (C.CFZT00 in ('1') AND C.BCCFH0 IS NULL 
 AND NOT EXISTS (SELECT 1 FROM YF_ZYCF00 D WHERE  C.CFLSH0=D.BCCFH0 AND C.ZYID00=D.ZYID00 AND CFZT00 in ('0','1') )))
 AND C.CFXZ00<>'0'
 AND C.CZY000=G.YGBH00