1       15:02:16  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

2       15:02:16  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

3       15:02:17  SQL Prepare: ORACLE - select distinct x.* from (SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_ZYCF00 C,YF_ZYJYXX G,BM_BMBM00 B
  WHERE C.YPDLBH='2' AND C.ZYDJS0>0  AND C.CFZT00='2' AND G.JLLX00='0'
  AND C.YFBMBH=57 
 and G.SHRQ00>='20170908' and G.SHRQ00<='20170908' 
  AND C.CFLSH0=G.CFLSH0 AND C.DQBQ00=B.BMBH00  and G.QXDJRQ='20991231'
 union all 
 SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_yzypsq C,YF_ZYJYXX G,BM_BMBM00 B
 WHERE C.YPDLBH='2' AND C.ZYDJS0>0    AND G.JLLX00='1' AND C.qlzt00 in('2','4') 
 AND C.YFBMBH=57 
 and G.SHRQ00>='20170908' and G.SHRQ00<='20170908' 
 AND C.tqdjh0=G.tqdjh0 and c.yzid00=g.yzid00 AND C.BQBMBH=B.BMBH00
 and G.QXDJRQ='20991231'  ) x

4       15:02:17  SQL Execute: ORACLE - select distinct x.* from (SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_ZYCF00 C,YF_ZYJYXX G,BM_BMBM00 B
  WHERE C.YPDLBH='2' AND C.ZYDJS0>0  AND C.CFZT00='2' AND G.JLLX00='0'
  AND C.YFBMBH=57 
 and G.SHRQ00>='20170908' and G.SHRQ00<='20170908' 
  AND C.CFLSH0=G.CFLSH0 AND C.DQBQ00=B.BMBH00  and G.QXDJRQ='20991231'
 union all 
 SELECT DISTINCT B.BMBH00,B.BMMC00 FROM YF_yzypsq C,YF_ZYJYXX G,BM_BMBM00 B
 WHERE C.YPDLBH='2' AND C.ZYDJS0>0    AND G.JLLX00='1' AND C.qlzt00 in('2','4') 
 AND C.YFBMBH=57 
 and G.SHRQ00>='20170908' and G.SHRQ00<='20170908' 
 AND C.tqdjh0=G.tqdjh0 and c.yzid00=g.yzid00 AND C.BQBMBH=B.BMBH00
 and G.QXDJRQ='20991231'  ) x