1       15:33:25  SQL Prepare: ORACLE - select distinct x.* from (SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_ZYCF00 C,YF_ZYJYXX G,BM_BMBM00 B
 ,YF_JYBQMX Q
  WHERE C.YPDLBH='2' AND C.ZYDJS0>0  AND C.CFZT00='2' AND G.JLLX00='0'
 AND C.YFBMBH=57
 AND Q.JYDH00=G.JYDH00  AND Q.FYRQ00 >='20220823' AND Q.FYRQ00 <='20220823'
 and G.SHRQ00 <'20991231'
 AND Q.SYDYCS<=0 
  AND C.CFLSH0=G.CFLSH0 AND C.DQBQ00=B.BMBH00  and G.QXDJRQ='20991231' and G.SHJG00=1
  AND G.ZYDJS0-(select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00)>0
 union all 
 SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_yzypsq C,YF_ZYJYXX G,BM_BMBM00 B
 ,YF_JYBQMX Q
 WHERE C.YPDLBH='2' AND C.ZYDJS0>0    AND G.JLLX00='1' AND C.qlzt00 in('2','4') 
 AND C.YFBMBH=57
 AND Q.JYDH00=G.JYDH00  AND Q.FYRQ00 >='20220823' AND Q.FYRQ00 <='20220823'
 and G.SHRQ00 <'20991231'
 AND Q.SYDYCS<=0 
 AND C.tqdjh0=G.tqdjh0 and c.yzid00=g.yzid00 AND C.BQBMBH=B.BMBH00 
 and G.QXDJRQ='20991231'  and G.SHJG00=1 
 AND G.ZYDJS0-(select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00)>0
 ) x

2       15:33:25  SQL Execute: ORACLE - select distinct x.* from (SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_ZYCF00 C,YF_ZYJYXX G,BM_BMBM00 B
 ,YF_JYBQMX Q
  WHERE C.YPDLBH='2' AND C.ZYDJS0>0  AND C.CFZT00='2' AND G.JLLX00='0'
 AND C.YFBMBH=57
 AND Q.JYDH00=G.JYDH00  AND Q.FYRQ00 >='20220823' AND Q.FYRQ00 <='20220823'
 and G.SHRQ00 <'20991231'
 AND Q.SYDYCS<=0 
  AND C.CFLSH0=G.CFLSH0 AND C.DQBQ00=B.BMBH00  and G.QXDJRQ='20991231' and G.SHJG00=1
  AND G.ZYDJS0-(select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00)>0
 union all 
 SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_yzypsq C,YF_ZYJYXX G,BM_BMBM00 B
 ,YF_JYBQMX Q
 WHERE C.YPDLBH='2' AND C.ZYDJS0>0    AND G.JLLX00='1' AND C.qlzt00 in('2','4') 
 AND C.YFBMBH=57
 AND Q.JYDH00=G.JYDH00  AND Q.FYRQ00 >='20220823' AND Q.FYRQ00 <='20220823'
 and G.SHRQ00 <'20991231'
 AND Q.SYDYCS<=0 
 AND C.tqdjh0=G.tqdjh0 and c.yzid00=g.yzid00 AND C.BQBMBH=B.BMBH00 
 and G.QXDJRQ='20991231'  and G.SHJG00=1 
 AND G.ZYDJS0-(select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00)>0
 ) x