1 15:14:38 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 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' 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 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' 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:14:38 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 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' 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 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' 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 3 15:14:38 SQL Prepare: ORACLE - select * from ( SELECT 0 FLAG00,' ' TQDJH0,' ' YZID00,C.CFLSH0,C.ZYH000,C.CH0000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00,C.ZYTS00,F.FBMC00, C.SRRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.DJH000,C.FYRQ00,C.FYSJ00,C.ZYDJS0, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.FYR000) FYR000, (SELECT Trim(ZDMC00) FROM BQ_BRZDXX WHERE ZYID00=C.ZYID00 and rownum=1) as ZZDMC0, (SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00=C.DQBQ00) BQMC00, NVL(C.CFDGS0,'5') CFDGS0,G.QYRQ00,G.QYSJ00,G.JYDH00,'-1' CLBZ00, G.JPSJ00,G.JSL000,G.ECJSL0,G.JZSJ00,G.ECJZSJ,G.JYJLB0,G.JYJHM0,G.ZCYL00,G.BZJLB0,G.BZJHM0,G.BZGG00, (select ZWXM00 from BM_YGBM00 L where L.YGBH00=G.LYCZY0 ) LYRXM0, (select nvl(ZWXM00,'') from BM_YGBM00 where YGBH00=G.PYCZY0) PYR000, (select ZWXM00 from BM_YGBM00 where YGBH00=G.JYCZY0) JYR000,G.BTGYY0,G.BZ0000, G.ZYDJS0- (select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00) SYTS00,1 SLTS00,G.JZLBBH,G.JZLBMC ,G.YYRQ00 ,Q.FYRQ00 FYRQ01,Q.SYDYCS DYCS00,Q.SYID00 FROM YF_ZYCF00 C,YF_ZYJYXX G ,VW_YF_ZYBRZH F ,YF_JYBQMX Q WHERE C.YFBMBH+0=57 AND C.YPDLBH='2' AND C.ZYDJS0>0 AND Q.JYDH00=G.JYDH00 AND Q.FYRQ00 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' AND C.CFZT00='2' AND C.BRID00=F.BRID00 AND C.ZYID00=F.ZYID00 AND C.CFLSH0=G.CFLSH0 AND G.JLLX00='0' AND ((-1=940 ) OR (C.DQBQ00=940)) and G.QXDJRQ='20991231' and G.SHJG00=1 ORDER BY C.CH0000,G.QYRQ00,G.QYSJ00 ) where SYTS00>0 union all select * from ( SELECT 0 FLAG00,to_char(C.TQDJH0) TQDJH0,to_char(C.YZID00) YZID00,' ' CFLSH0,C.ZYH000,C.CH0000,C.BRXM00,G.XB0000,G.CSRQ00, MAX((select zwxm00 from bm_ygbm00 where ygbh00=c.ysgzh0)) YSXM00,max(C.ZYTS00) ZYTS00,F.FBMC00, Max(C.SRRQ00) SRRQ00,ROUND(SUM(C.LSDJ00*C.YPZSL0),2) CFZJE0,C.QLZT00 CFZT00,C.YPDLBH, max(C.DJH000) DJH000,max(C.FYRQ00) FYRQ00,max(C.FYSJ00) FYSJ00,max(C.ZYDJS0) ZYDJS0,max((Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=G.PFCZY0)) PFR000, max((Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.FYR000)) FYR000, max((SELECT Trim(ZDMC00) FROM BQ_BRZDXX WHERE ZYID00=C.ZYID00 and rownum=1)) as ZZDMC0, max((SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00=C.BQBMBH)) BQMC00, ' ' CFDGS0,G.QYRQ00,G.QYSJ00,G.JYDH00,max(C.CLBZ00) CLBZ00, max(G.JPSJ00) JPSJ00,max(G.JSL000) JSL000,max(G.ECJSL0) ECJSL0,max(G.JZSJ00) JZSJ00,max(G.ECJZSJ) ECJZSJ,max(G.JYJLB0) JYJLB0, max(G.JYJHM0) JYJHM0,max(G.ZCYL00) ZCYL00,max(G.BZJLB0) BZJLB0,max(G.BZJHM0) BZJHM0,max(G.BZGG00) , max((select ZWXM00 from BM_YGBM00 L where L.YGBH00=G.LYCZY0 )) LYRXM0, max((select nvl(ZWXM00,'') from BM_YGBM00 where YGBH00=G.PYCZY0)) PYR000, max((select ZWXM00 from BM_YGBM00 where YGBH00=G.JYCZY0)) JYR000,max(G.BTGYY0) BTGYY0,max(G.BZ0000) BZ0000, max(G.ZYDJS0-(select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00)) SYTS00,1 SLTS00,G.JZLBBH,G.JZLBMC ,G.YYRQ00 ,Q.FYRQ00 FYRQ01,Q.SYDYCS DYCS00,Q.SYID00 FROM YF_YZYPSQ C,YF_ZYJYXX G ,VW_YF_ZYBRZH F ,YF_JYBQMX Q WHERE C.YFBMBH+0=57 AND C.YPDLBH='2' AND C.ZYDJS0>0 AND Q.JYDH00=G.JYDH00 AND Q.FYRQ00 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' AND C.QLZT00 in('2','4') AND G.BRID00=F.BRID00 AND C.ZYID00=F.ZYID00 AND C.TQDJH0=G.tqdjh0 AND C.YZID00=G.YZID00 AND G.JLLX00='1' AND ((-1=940 ) OR (C.BQBMBH=940)) and G.QXDJRQ='20991231' and G.SHJG00=1 GROUP BY C.TQDJH0,C.YZID00,C.ZYH000,C.CH0000,C.BRXM00,G.XB0000,G.CSRQ00,F.FBMC00,C.QLZT00,C.YPDLBH,G.QYRQ00,G.QYSJ00,G.JYDH00,G.JZLBBH,G.JZLBMC ,G.YYRQ00,Q.SYDYCS,Q.SYID00 , Q.FYRQ00 ORDER BY C.CH0000,G.QYRQ00,G.QYSJ00 ) where SYTS00>0 4 15:14:38 SQL Execute: ORACLE - select * from ( SELECT 0 FLAG00,' ' TQDJH0,' ' YZID00,C.CFLSH0,C.ZYH000,C.CH0000,C.BRXM00,C.XB0000,C.CSRQ00,C.YSXM00,C.ZYTS00,F.FBMC00, C.SRRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.DJH000,C.FYRQ00,C.FYSJ00,C.ZYDJS0, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.FYR000) FYR000, (SELECT Trim(ZDMC00) FROM BQ_BRZDXX WHERE ZYID00=C.ZYID00 and rownum=1) as ZZDMC0, (SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00=C.DQBQ00) BQMC00, NVL(C.CFDGS0,'5') CFDGS0,G.QYRQ00,G.QYSJ00,G.JYDH00,'-1' CLBZ00, G.JPSJ00,G.JSL000,G.ECJSL0,G.JZSJ00,G.ECJZSJ,G.JYJLB0,G.JYJHM0,G.ZCYL00,G.BZJLB0,G.BZJHM0,G.BZGG00, (select ZWXM00 from BM_YGBM00 L where L.YGBH00=G.LYCZY0 ) LYRXM0, (select nvl(ZWXM00,'') from BM_YGBM00 where YGBH00=G.PYCZY0) PYR000, (select ZWXM00 from BM_YGBM00 where YGBH00=G.JYCZY0) JYR000,G.BTGYY0,G.BZ0000, G.ZYDJS0- (select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00) SYTS00,1 SLTS00,G.JZLBBH,G.JZLBMC ,G.YYRQ00 ,Q.FYRQ00 FYRQ01,Q.SYDYCS DYCS00,Q.SYID00 FROM YF_ZYCF00 C,YF_ZYJYXX G ,VW_YF_ZYBRZH F ,YF_JYBQMX Q WHERE C.YFBMBH+0=57 AND C.YPDLBH='2' AND C.ZYDJS0>0 AND Q.JYDH00=G.JYDH00 AND Q.FYRQ00 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' AND C.CFZT00='2' AND C.BRID00=F.BRID00 AND C.ZYID00=F.ZYID00 AND C.CFLSH0=G.CFLSH0 AND G.JLLX00='0' AND ((-1=940 ) OR (C.DQBQ00=940)) and G.QXDJRQ='20991231' and G.SHJG00=1 ORDER BY C.CH0000,G.QYRQ00,G.QYSJ00 ) where SYTS00>0 union all select * from ( SELECT 0 FLAG00,to_char(C.TQDJH0) TQDJH0,to_char(C.YZID00) YZID00,' ' CFLSH0,C.ZYH000,C.CH0000,C.BRXM00,G.XB0000,G.CSRQ00, MAX((select zwxm00 from bm_ygbm00 where ygbh00=c.ysgzh0)) YSXM00,max(C.ZYTS00) ZYTS00,F.FBMC00, Max(C.SRRQ00) SRRQ00,ROUND(SUM(C.LSDJ00*C.YPZSL0),2) CFZJE0,C.QLZT00 CFZT00,C.YPDLBH, max(C.DJH000) DJH000,max(C.FYRQ00) FYRQ00,max(C.FYSJ00) FYSJ00,max(C.ZYDJS0) ZYDJS0,max((Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=G.PFCZY0)) PFR000, max((Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.FYR000)) FYR000, max((SELECT Trim(ZDMC00) FROM BQ_BRZDXX WHERE ZYID00=C.ZYID00 and rownum=1)) as ZZDMC0, max((SELECT BMMC00 FROM BM_BMBM00 WHERE BMBH00=C.BQBMBH)) BQMC00, ' ' CFDGS0,G.QYRQ00,G.QYSJ00,G.JYDH00,max(C.CLBZ00) CLBZ00, max(G.JPSJ00) JPSJ00,max(G.JSL000) JSL000,max(G.ECJSL0) ECJSL0,max(G.JZSJ00) JZSJ00,max(G.ECJZSJ) ECJZSJ,max(G.JYJLB0) JYJLB0, max(G.JYJHM0) JYJHM0,max(G.ZCYL00) ZCYL00,max(G.BZJLB0) BZJLB0,max(G.BZJHM0) BZJHM0,max(G.BZGG00) , max((select ZWXM00 from BM_YGBM00 L where L.YGBH00=G.LYCZY0 )) LYRXM0, max((select nvl(ZWXM00,'') from BM_YGBM00 where YGBH00=G.PYCZY0)) PYR000, max((select ZWXM00 from BM_YGBM00 where YGBH00=G.JYCZY0)) JYR000,max(G.BTGYY0) BTGYY0,max(G.BZ0000) BZ0000, max(G.ZYDJS0-(select nvl(sum(sysl00),0) from yf_zysyxx where jydh00=G.JYDH00)) SYTS00,1 SLTS00,G.JZLBBH,G.JZLBMC ,G.YYRQ00 ,Q.FYRQ00 FYRQ01,Q.SYDYCS DYCS00,Q.SYID00 FROM YF_YZYPSQ C,YF_ZYJYXX G ,VW_YF_ZYBRZH F ,YF_JYBQMX Q WHERE C.YFBMBH+0=57 AND C.YPDLBH='2' AND C.ZYDJS0>0 AND Q.JYDH00=G.JYDH00 AND Q.FYRQ00 >='20170421' AND Q.FYRQ00 <='20170421' and G.SHRQ00 <'20991231' AND C.QLZT00 in('2','4') AND G.BRID00=F.BRID00 AND C.ZYID00=F.ZYID00 AND C.TQDJH0=G.tqdjh0 AND C.YZID00=G.YZID00 AND G.JLLX00='1' AND ((-1=940 ) OR (C.BQBMBH=940)) and G.QXDJRQ='20991231' and G.SHJG00=1 GROUP BY C.TQDJH0,C.YZID00,C.ZYH000,C.CH0000,C.BRXM00,G.XB0000,G.CSRQ00,F.FBMC00,C.QLZT00,C.YPDLBH,G.QYRQ00,G.QYSJ00,G.JYDH00,G.JZLBBH,G.JZLBMC ,G.YYRQ00,Q.SYDYCS,Q.SYID00 , Q.FYRQ00 ORDER BY C.CH0000,G.QYRQ00,G.QYSJ00 ) where SYTS00>0 5 15:15:08 SQL Prepare: ORACLE - SELECT ' ' CFLSH0,C.YPMC00,C.YPGG00,C.LSDJ00,C.YPZSL0,C.QLDW00 CFDW00, DECODE(SUBSTR(C.CSL000,1,1),'.','0','')||C.CSL000||C.JLDW00 DJL000,C.PCMC00,C.ZCXSL0, C.YFSMMC||C.YPYFMC||C.XMYFMC YYFF00,' ' YYTS00,' ' ZB0000,C.CXBZ00 FROM YF_yzypsq C WHERE C.YPDLBH='2' AND C.ZYDJS0>0 AND C.qlzt00 in('2','4') and C.YFBMBH=57 and C.TQDJH0=7929193 AND C.YZID00=28087422 6 15:15:08 SQL Execute: ORACLE - SELECT ' ' CFLSH0,C.YPMC00,C.YPGG00,C.LSDJ00,C.YPZSL0,C.QLDW00 CFDW00, DECODE(SUBSTR(C.CSL000,1,1),'.','0','')||C.CSL000||C.JLDW00 DJL000,C.PCMC00,C.ZCXSL0, C.YFSMMC||C.YPYFMC||C.XMYFMC YYFF00,' ' YYTS00,' ' ZB0000,C.CXBZ00 FROM YF_yzypsq C WHERE C.YPDLBH='2' AND C.ZYDJS0>0 AND C.qlzt00 in('2','4') and C.YFBMBH=57 and C.TQDJH0=7929193 AND C.YZID00=28087422 7 15:15:08 SQL Prepare: ORACLE - SELECT ' ' CFLSH0,C.YPMC00,C.YPGG00,C.LSDJ00,C.YPZSL0,C.QLDW00 CFDW00, DECODE(SUBSTR(C.CSL000,1,1),'.','0','')||C.CSL000||C.JLDW00 DJL000,C.PCMC00,C.ZCXSL0, C.YFSMMC||C.YPYFMC||C.XMYFMC YYFF00,' ' YYTS00,' ' ZB0000,C.CXBZ00 FROM YF_yzypsq C WHERE C.YPDLBH='2' AND C.ZYDJS0>0 AND C.qlzt00 in('2','4') and C.YFBMBH=57 and C.TQDJH0=7929193 AND C.YZID00=28087422 8 15:15:08 SQL Execute: ORACLE - SELECT ' ' CFLSH0,C.YPMC00,C.YPGG00,C.LSDJ00,C.YPZSL0,C.QLDW00 CFDW00, DECODE(SUBSTR(C.CSL000,1,1),'.','0','')||C.CSL000||C.JLDW00 DJL000,C.PCMC00,C.ZCXSL0, C.YFSMMC||C.YPYFMC||C.XMYFMC YYFF00,' ' YYTS00,' ' ZB0000,C.CXBZ00 FROM YF_yzypsq C WHERE C.YPDLBH='2' AND C.ZYDJS0>0 AND C.qlzt00 in('2','4') and C.YFBMBH=57 and C.TQDJH0=7929193 AND C.YZID00=28087422 9 15:15:08 SQL Prepare: ORACLE - SELECT ' ' CFLSH0,C.YPMC00,C.YPGG00,C.LSDJ00,C.YPZSL0,C.QLDW00 CFDW00, DECODE(SUBSTR(C.CSL000,1,1),'.','0','')||C.CSL000||C.JLDW00 DJL000,C.PCMC00,C.ZCXSL0, C.YFSMMC||C.YPYFMC||C.XMYFMC YYFF00,' ' YYTS00,' ' ZB0000,C.CXBZ00 FROM YF_yzypsq C WHERE C.YPDLBH='2' AND C.ZYDJS0>0 AND C.qlzt00 in('2','4') and C.YFBMBH=57 and C.TQDJH0=7929193 AND C.YZID00=28087422 10 15:15:08 SQL Execute: ORACLE - SELECT ' ' CFLSH0,C.YPMC00,C.YPGG00,C.LSDJ00,C.YPZSL0,C.QLDW00 CFDW00, DECODE(SUBSTR(C.CSL000,1,1),'.','0','')||C.CSL000||C.JLDW00 DJL000,C.PCMC00,C.ZCXSL0, C.YFSMMC||C.YPYFMC||C.XMYFMC YYFF00,' ' YYTS00,' ' ZB0000,C.CXBZ00 FROM YF_yzypsq C WHERE C.YPDLBH='2' AND C.ZYDJS0>0 AND C.qlzt00 in('2','4') and C.YFBMBH=57 and C.TQDJH0=7929193 AND C.YZID00=28087422 11 15:15:08 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 12 15:15:08 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 13 15:15:08 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 14 15:15:08 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL