1       13:31:28  SQL Execute: ORACLE - select YQJC00,ZKBBPH,bgxmid,ZWMC00, DBJZ01,DBBZ01,DBBZC1, 
 substr(to_char(nvl((DBBZC1/DBBZ01*100),'0'),'99990.00')||'%',1,100) DBCV01, 
 DBJZ02, DBBZ02, DBBZC2,
 substr(to_char(nvl((DBBZC2/DBBZ02*100),'0'),'99990.00')||'%',1,100) DBCV02 
from ( select YQJC00,ZKBBPH,B.bgxmid,ZWMC00, 
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210201' and '20210201' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ01,
to_char(substr(SF_JY_GETZKDBDYBZ('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ01,
to_char(substr(SF_JY_GETZKDBDYBZC('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC1,
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210131' and '20210131' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ02,
to_char(substr(SF_JY_GETZKDBDYBZ('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ02,
to_char(substr(SF_JY_GETZKDBDYBZC('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC2 
 from JY_JYYQZD A,JY_zkbbcs B,JY_BGXMZD C 
 where A.YQDH00=B.YQDH00 and B.BGXMID=C.BGXMID 
and b.YQDH00='AC' and b.ZKBBPH='21451702')

2       13:31:29  SQL Execute: ORACLE - select YQJC00,ZKBBPH,bgxmid,ZWMC00, DBJZ01,DBBZ01,DBBZC1, 
 substr(to_char(nvl((DBBZC1/DBBZ01*100),'0'),'99990.00')||'%',1,100) DBCV01, 
 DBJZ02, DBBZ02, DBBZC2,
 substr(to_char(nvl((DBBZC2/DBBZ02*100),'0'),'99990.00')||'%',1,100) DBCV02 
from ( select YQJC00,ZKBBPH,B.bgxmid,ZWMC00, 
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210201' and '20210201' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ01,
to_char(substr(SF_JY_GETZKDBDYBZ('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ01,
to_char(substr(SF_JY_GETZKDBDYBZC('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC1,
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210131' and '20210131' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ02,
to_char(substr(SF_JY_GETZKDBDYBZ('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ02,
to_char(substr(SF_JY_GETZKDBDYBZC('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC2 
 from JY_JYYQZD A,JY_zkbbcs B,JY_BGXMZD C 
 where A.YQDH00=B.YQDH00 and B.BGXMID=C.BGXMID 
and b.YQDH00='AC' and b.ZKBBPH='21451702')

3       13:31:29  SQL Execute: ORACLE - select YQJC00,ZKBBPH,bgxmid,ZWMC00, DBJZ01,DBBZ01,DBBZC1, 
 substr(to_char(nvl((DBBZC1/DBBZ01*100),'0'),'99990.00')||'%',1,100) DBCV01, 
 DBJZ02, DBBZ02, DBBZC2,
 substr(to_char(nvl((DBBZC2/DBBZ02*100),'0'),'99990.00')||'%',1,100) DBCV02 
from ( select YQJC00,ZKBBPH,B.bgxmid,ZWMC00, 
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210201' and '20210201' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ01,
to_char(substr(SF_JY_GETZKDBDYBZ('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ01,
to_char(substr(SF_JY_GETZKDBDYBZC('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC1,
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210131' and '20210131' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ02,
to_char(substr(SF_JY_GETZKDBDYBZ('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ02,
to_char(substr(SF_JY_GETZKDBDYBZC('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC2 
 from JY_JYYQZD A,JY_zkbbcs B,JY_BGXMZD C 
 where A.YQDH00=B.YQDH00 and B.BGXMID=C.BGXMID 
and b.YQDH00='AC' and b.ZKBBPH='21451702')

4       13:31:31  SQL Execute: ORACLE - select YQJC00,ZKBBPH,bgxmid,ZWMC00, DBJZ01,DBBZ01,DBBZC1, 
 substr(to_char(nvl((DBBZC1/DBBZ01*100),'0'),'99990.00')||'%',1,100) DBCV01, 
 DBJZ02, DBBZ02, DBBZC2,
 substr(to_char(nvl((DBBZC2/DBBZ02*100),'0'),'99990.00')||'%',1,100) DBCV02 
from ( select YQJC00,ZKBBPH,B.bgxmid,ZWMC00, 
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210201' and '20210201' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ01,
to_char(substr(SF_JY_GETZKDBDYBZ('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ01,
to_char(substr(SF_JY_GETZKDBDYBZC('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC1,
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210131' and '20210131' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ02,
to_char(substr(SF_JY_GETZKDBDYBZ('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ02,
to_char(substr(SF_JY_GETZKDBDYBZC('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC2 
 from JY_JYYQZD A,JY_zkbbcs B,JY_BGXMZD C 
 where A.YQDH00=B.YQDH00 and B.BGXMID=C.BGXMID 
and b.YQDH00='AC' and b.ZKBBPH='20100406')

5       13:31:35  SQL Execute: ORACLE - select JYYWID,BRXM00,SQKSMC,YBH000,PYRQ00 from VW_JY_YW0000 where JGZT00 in ('6','8')  and YXBZ00='Y'   and BGCKR0 is null AND cbgrq0  >= TO_CHAR (SYSDATE - 15, 'yyyymmddhh') and CBGRQ0||CBGSJ0<=to_char(sysdate-10/1440,'yyyymmddhh24:mi:ss') and WJZWCK is null 

6       13:33:01  SQL Execute: ORACLE - select YQJC00,ZKBBPH,bgxmid,ZWMC00, DBJZ01,DBBZ01,DBBZC1, 
 substr(to_char(nvl((DBBZC1/DBBZ01*100),'0'),'99990.00')||'%',1,100) DBCV01, 
 DBJZ02, DBBZ02, DBBZC2,
 substr(to_char(nvl((DBBZC2/DBBZ02*100),'0'),'99990.00')||'%',1,100) DBCV02 
from ( select YQJC00,ZKBBPH,B.bgxmid,ZWMC00, 
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210201' and '20210201' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ01,
to_char(substr(SF_JY_GETZKDBDYBZ('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ01,
to_char(substr(SF_JY_GETZKDBDYBZC('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC1,
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210131' and '20210131' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ02,
to_char(substr(SF_JY_GETZKDBDYBZ('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ02,
to_char(substr(SF_JY_GETZKDBDYBZC('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC2 
 from JY_JYYQZD A,JY_zkbbcs B,JY_BGXMZD C 
 where A.YQDH00=B.YQDH00 and B.BGXMID=C.BGXMID 
and b.YQDH00='RO' and b.ZKBBPH='20100406')

7       13:33:02  SQL Execute: ORACLE - select YQJC00,ZKBBPH,bgxmid,ZWMC00, DBJZ01,DBBZ01,DBBZC1, 
 substr(to_char(nvl((DBBZC1/DBBZ01*100),'0'),'99990.00')||'%',1,100) DBCV01, 
 DBJZ02, DBBZ02, DBBZC2,
 substr(to_char(nvl((DBBZC2/DBBZ02*100),'0'),'99990.00')||'%',1,100) DBCV02 
from ( select YQJC00,ZKBBPH,B.bgxmid,ZWMC00, 
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210201' and '20210201' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ01,
to_char(substr(SF_JY_GETZKDBDYBZ('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ01,
to_char(substr(SF_JY_GETZKDBDYBZC('20210201','20210201',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC1,
to_char((select avg(zkjg00) from JY_ZKJG00 where zxrq00 between '20210131' and '20210131' and YQDH00=B.YQDH00 and ZKBBPH=B.ZKBBPH and bgxmid=b.bgxmid),'99990.000') DBJZ02,
to_char(substr(SF_JY_GETZKDBDYBZ('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZ02,
to_char(substr(SF_JY_GETZKDBDYBZC('20210131','20210131',B.YQDH00,B.ZKBBPH ,B.BGXMID),1,100),'99990.00') DBBZC2 
 from JY_JYYQZD A,JY_zkbbcs B,JY_BGXMZD C 
 where A.YQDH00=B.YQDH00 and B.BGXMID=C.BGXMID 
and b.YQDH00='RO' and b.ZKBBPH='20100406')

8       13:33:35  SQL Execute: ORACLE - select JYYWID,BRXM00,SQKSMC,YBH000,PYRQ00 from VW_JY_YW0000 where JGZT00 in ('6','8')  and YXBZ00='Y'   and BGCKR0 is null AND cbgrq0  >= TO_CHAR (SYSDATE - 15, 'yyyymmddhh') and CBGRQ0||CBGSJ0<=to_char(sysdate-10/1440,'yyyymmddhh24:mi:ss') and WJZWCK is null