1 11:06:09 SQL Execute: ORACLE - SELECT * FROM VW_JY_YWBG00 WHERE JYYWID = '245344' and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN')) 2 11:06:09 SQL Execute: ORACLE - commit 3 11:06:09 SQL Data In: ORACLE - Rows affected = 0 4 11:06:15 SQL Execute: ORACLE - select SFLSTD from JY_YW0000 where JYYWID='245344' 5 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 418 6 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 7 11:06:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 8 11:06:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = BBPY 9 11:06:15 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 10 11:06:15 SQL Execute: ORACLE - update JY_YW0000 set YBH000='XN0011',YQDH00='XN',BGR000='418',CZY000='418',PYRQ00='20171218',PYSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS'),JGZT00='5' where JYYWID in (245344) 11 11:06:15 SQL Data In: ORACLE - Rows affected = 1 12 11:06:15 SQL Execute: ORACLE - SELECT * FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN')) 13 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2218','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2218') 14 11:06:15 SQL Data In: ORACLE - Rows affected = 0 15 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2218' 16 11:06:15 SQL Data In: ORACLE - Rows affected = 1 17 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 18 11:06:15 SQL Data In: ORACLE - Rows affected = 0 19 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 20 11:06:15 SQL Data In: ORACLE - Rows affected = 4 21 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2217','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2217') 22 11:06:15 SQL Data In: ORACLE - Rows affected = 0 23 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2217' 24 11:06:15 SQL Data In: ORACLE - Rows affected = 1 25 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 26 11:06:15 SQL Data In: ORACLE - Rows affected = 0 27 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 28 11:06:15 SQL Data In: ORACLE - Rows affected = 0 29 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2216','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2216') 30 11:06:15 SQL Data In: ORACLE - Rows affected = 0 31 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2216' 32 11:06:15 SQL Data In: ORACLE - Rows affected = 1 33 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 34 11:06:15 SQL Data In: ORACLE - Rows affected = 0 35 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 36 11:06:15 SQL Data In: ORACLE - Rows affected = 0 37 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2215','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2215') 38 11:06:15 SQL Data In: ORACLE - Rows affected = 0 39 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2215' 40 11:06:15 SQL Data In: ORACLE - Rows affected = 1 41 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 42 11:06:15 SQL Data In: ORACLE - Rows affected = 0 43 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 44 11:06:15 SQL Data In: ORACLE - Rows affected = 0 45 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2214','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2214') 46 11:06:15 SQL Data In: ORACLE - Rows affected = 0 47 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2214' 48 11:06:15 SQL Data In: ORACLE - Rows affected = 1 49 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 50 11:06:15 SQL Data In: ORACLE - Rows affected = 0 51 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 52 11:06:15 SQL Data In: ORACLE - Rows affected = 0 53 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2213','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2213') 54 11:06:15 SQL Data In: ORACLE - Rows affected = 0 55 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2213' 56 11:06:15 SQL Data In: ORACLE - Rows affected = 1 57 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 58 11:06:15 SQL Data In: ORACLE - Rows affected = 0 59 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 60 11:06:15 SQL Data In: ORACLE - Rows affected = 0 61 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2212','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2212') 62 11:06:15 SQL Data In: ORACLE - Rows affected = 0 63 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2212' 64 11:06:15 SQL Data In: ORACLE - Rows affected = 1 65 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 66 11:06:15 SQL Data In: ORACLE - Rows affected = 0 67 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 68 11:06:15 SQL Data In: ORACLE - Rows affected = 0 69 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2211','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2211') 70 11:06:15 SQL Data In: ORACLE - Rows affected = 0 71 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2211' 72 11:06:15 SQL Data In: ORACLE - Rows affected = 1 73 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 74 11:06:15 SQL Data In: ORACLE - Rows affected = 0 75 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 76 11:06:15 SQL Data In: ORACLE - Rows affected = 0 77 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2210','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2210') 78 11:06:15 SQL Data In: ORACLE - Rows affected = 0 79 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2210' 80 11:06:15 SQL Data In: ORACLE - Rows affected = 1 81 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 82 11:06:15 SQL Data In: ORACLE - Rows affected = 0 83 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 84 11:06:15 SQL Data In: ORACLE - Rows affected = 0 85 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2209','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2209') 86 11:06:15 SQL Data In: ORACLE - Rows affected = 0 87 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2209' 88 11:06:15 SQL Data In: ORACLE - Rows affected = 1 89 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 90 11:06:15 SQL Data In: ORACLE - Rows affected = 0 91 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 92 11:06:15 SQL Data In: ORACLE - Rows affected = 0 93 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2230','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2230') 94 11:06:15 SQL Data In: ORACLE - Rows affected = 0 95 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2230' 96 11:06:15 SQL Data In: ORACLE - Rows affected = 1 97 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 98 11:06:15 SQL Data In: ORACLE - Rows affected = 0 99 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 100 11:06:15 SQL Data In: ORACLE - Rows affected = 0 101 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2232','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2232') 102 11:06:15 SQL Data In: ORACLE - Rows affected = 0 103 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2232' 104 11:06:15 SQL Data In: ORACLE - Rows affected = 1 105 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 106 11:06:15 SQL Data In: ORACLE - Rows affected = 0 107 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 108 11:06:15 SQL Data In: ORACLE - Rows affected = 0 109 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2228','',null,'fL','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2228') 110 11:06:15 SQL Data In: ORACLE - Rows affected = 0 111 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='fL',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2228' 112 11:06:15 SQL Data In: ORACLE - Rows affected = 1 113 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 114 11:06:15 SQL Data In: ORACLE - Rows affected = 0 115 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 116 11:06:15 SQL Data In: ORACLE - Rows affected = 0 117 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2229','',null,'fL','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2229') 118 11:06:15 SQL Data In: ORACLE - Rows affected = 0 119 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='fL',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2229' 120 11:06:15 SQL Data In: ORACLE - Rows affected = 1 121 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 122 11:06:15 SQL Data In: ORACLE - Rows affected = 0 123 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 124 11:06:15 SQL Data In: ORACLE - Rows affected = 0 125 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2225','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2225') 126 11:06:15 SQL Data In: ORACLE - Rows affected = 0 127 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2225' 128 11:06:15 SQL Data In: ORACLE - Rows affected = 1 129 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 130 11:06:15 SQL Data In: ORACLE - Rows affected = 0 131 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 132 11:06:15 SQL Data In: ORACLE - Rows affected = 0 133 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2226','',null,'fL','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2226') 134 11:06:15 SQL Data In: ORACLE - Rows affected = 0 135 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='fL',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2226' 136 11:06:15 SQL Data In: ORACLE - Rows affected = 1 137 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 138 11:06:15 SQL Data In: ORACLE - Rows affected = 0 139 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 140 11:06:15 SQL Data In: ORACLE - Rows affected = 0 141 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2227','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2227') 142 11:06:15 SQL Data In: ORACLE - Rows affected = 0 143 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2227' 144 11:06:15 SQL Data In: ORACLE - Rows affected = 1 145 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 146 11:06:15 SQL Data In: ORACLE - Rows affected = 0 147 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 148 11:06:15 SQL Data In: ORACLE - Rows affected = 0 149 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2224','',null,'g/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2224') 150 11:06:15 SQL Data In: ORACLE - Rows affected = 0 151 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='g/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2224' 152 11:06:15 SQL Data In: ORACLE - Rows affected = 1 153 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 154 11:06:15 SQL Data In: ORACLE - Rows affected = 0 155 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 156 11:06:15 SQL Data In: ORACLE - Rows affected = 0 157 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2222','',null,'fL','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2222') 158 11:06:15 SQL Data In: ORACLE - Rows affected = 0 159 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='fL',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2222' 160 11:06:15 SQL Data In: ORACLE - Rows affected = 1 161 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 162 11:06:15 SQL Data In: ORACLE - Rows affected = 0 163 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 164 11:06:15 SQL Data In: ORACLE - Rows affected = 0 165 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2223','',null,'pg','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2223') 166 11:06:15 SQL Data In: ORACLE - Rows affected = 0 167 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='pg',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2223' 168 11:06:15 SQL Data In: ORACLE - Rows affected = 1 169 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 170 11:06:15 SQL Data In: ORACLE - Rows affected = 0 171 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 172 11:06:15 SQL Data In: ORACLE - Rows affected = 0 173 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2221','',null,'%','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2221') 174 11:06:15 SQL Data In: ORACLE - Rows affected = 0 175 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='%',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2221' 176 11:06:15 SQL Data In: ORACLE - Rows affected = 1 177 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 178 11:06:15 SQL Data In: ORACLE - Rows affected = 0 179 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 180 11:06:15 SQL Data In: ORACLE - Rows affected = 0 181 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2220','',null,'g/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2220') 182 11:06:15 SQL Data In: ORACLE - Rows affected = 0 183 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='g/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2220' 184 11:06:15 SQL Data In: ORACLE - Rows affected = 1 185 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 186 11:06:15 SQL Data In: ORACLE - Rows affected = 0 187 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 188 11:06:15 SQL Data In: ORACLE - Rows affected = 0 189 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2219','',null,'10^12/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2219') 190 11:06:15 SQL Data In: ORACLE - Rows affected = 0 191 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^12/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2219' 192 11:06:15 SQL Data In: ORACLE - Rows affected = 1 193 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 194 11:06:15 SQL Data In: ORACLE - Rows affected = 0 195 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 196 11:06:15 SQL Data In: ORACLE - Rows affected = 0 197 11:06:15 SQL Execute: ORACLE - INSERT INTO JY_JYJG00_TEMP(JYYWID,YBH000,PYRQ00,TXM000,FSBZ00,ZLXMID,BGXMID,JYJG00,YSJYJG,JGDW00,YQDH00) select '245344','XN0011','20171218', '','Y','70347','2231','',null,'10^9/L','XN' from dual where not exists (select 1 from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2231') 198 11:06:15 SQL Data In: ORACLE - Rows affected = 0 199 11:06:15 SQL Execute: ORACLE - UPDATE JY_JYJG00_TEMP SET JYYWID='245344',TXM000='',SFDY00='Y',ZLXMID='70347',JYJG00=NVL(JYJG00,''),JGDW00='10^9/L',YQDH00='XN' WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID='2231' 200 11:06:15 SQL Data In: ORACLE - Rows affected = 1 201 11:06:15 SQL Execute: ORACLE - UPDATE JY_XJBGJG SET JYYWID='245344',ZLXMID='70347'WHERE YBH000='XN0011' and PYRQ00='20171218' 202 11:06:15 SQL Data In: ORACLE - Rows affected = 0 203 11:06:15 SQL Execute: ORACLE - delete from JY_JYJG00_TEMP WHERE YBH000='XN0011' and PYRQ00='20171218' and BGXMID not in (SELECT BGXMID FROM VW_JY_YWBG00 WHERE JYYWID in (245344) and (YQDH00='XN' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='XN'))) 204 11:06:15 SQL Data In: ORACLE - Rows affected = 0 205 11:06:15 SQL Execute: ORACLE - Commit 206 11:06:15 SQL Data In: ORACLE - Rows affected = 0 207 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 208 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 209 11:06:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 210 11:06:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 211 11:06:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 212 11:06:15 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,YEXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ||SFTJ00,'0Y','体','0N','门','住') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00,JGZT00,SFCJJZ from (SELECT DISTINCT a.YBH000,a.PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,' ' BRXM00,' ' YEXM00,' ' ZYHGHH,'0' MZZYBZ,' ' YXBZ00,(SELECT SUM(Distinct(SECTOR)) from JY_JYJG00_TEMP where PYRQ00=a.PYRQ00 and YBH000=a.YBH000) SECTOR,(SELECT SUM(Distinct(CUPNUM)) from JY_JYJG00_TEMP where PYRQ00=a.PYRQ00 and YBH000=a.YBH000) CUPNUM,'N' JYKDY0,'2' JGZT00,'N' SFTJ00,SFCJJZ FROM JY_JYJG00_TEMP a where SFDY00='N' and BGXMID < 999989 AND not exists (select FCYBH0,FCRQ00 from jy_yw0000 where pyrq00 BETWEEN ? AND ? and a.ybh000=FCYBH0 and a.pyrq00=FCRQ00) and YBH000 like ( ? ||'%' ) and pyrq00 between ? and ? order by YBH000) 213 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 214 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 215 11:06:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 216 11:06:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 217 11:06:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 218 11:06:15 SQL Execute: ORACLE - select count(*) from (SELECT DISTINCT a.YBH000,a.PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,' ' BRXM00,' ' YEXM00,' ' ZYHGHH,'0' MZZYBZ,' ' YXBZ00,(SELECT SUM(Distinct(SECTOR)) from JY_JYJG00_TEMP where PYRQ00=a.PYRQ00 and YBH000=a.YBH000) SECTOR,(SELECT SUM(Distinct(CUPNUM)) from JY_JYJG00_TEMP where PYRQ00=a.PYRQ00 and YBH000=a.YBH000) CUPNUM,'N' JYKDY0,'2' JGZT00,'N' SFTJ00,SFCJJZ FROM JY_JYJG00_TEMP a where SFDY00='N' and BGXMID < 999989 AND not exists (select FCYBH0,FCRQ00 from jy_yw0000 where pyrq00 BETWEEN ? AND ? and a.ybh000=FCYBH0 and a.pyrq00=FCRQ00) and YBH000 like ( ? ||'%' ) and pyrq00 between ? and ? ) 219 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 220 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 221 11:06:15 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00=? and YQDH00||YBH000= ? AND SFZY00 = 'Y' 222 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 223 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 224 11:06:15 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 225 11:06:15 SQL Execute: ORACLE - select * from vw_JY_YW0000 where ZYHGHH='' and MZZYBZ='0' and ((SFTJ00 = '0') or ('0'='0')) order by jyywid desc 226 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 227 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 228 11:06:15 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 229 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 230 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 231 11:06:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 232 11:06:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 233 11:06:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 234 11:06:15 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 235 11:06:15 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 236 11:06:15 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 237 11:06:15 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 238 11:06:15 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 239 11:06:15 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 240 11:06:15 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 241 11:06:15 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) order by DYSX00 242 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 243 11:06:15 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00=? 244 11:06:15 SQL Execute: ORACLE - select * from vw_JY_YW0000 where ZYHGHH='' and MZZYBZ='0' and ((SFTJ00 = '0') or ('0'='0')) order by jyywid desc 245 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 246 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 247 11:06:15 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 248 11:06:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 249 11:06:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 250 11:06:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 251 11:06:15 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 252 11:06:15 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 253 11:06:15 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 254 11:06:15 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 255 11:06:15 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 256 11:06:15 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 257 11:06:15 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 258 11:06:15 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 259 11:06:15 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0012 260 11:06:15 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) order by DYSX00 261 11:06:16 SQL Execute: ORACLE - select distinct BRXM00,MZZYBZ,XBMC00 BRXB00,CSRQ00 BRCSRQ,BRID00,ZYHGHH GHH000,ZYGHID GHID00,'N' SFXZ00,NL0000||NLDWMC BRNL00,(SELECT SFYX00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) SFYX00,(SELECT TYDWMC FROM BM_BRXXB0 WHERE BRID00=B.BRID00) TYDWMC,(SELECT BRDH00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) BRDH00, LRY000 from VW_JY_YW0000 B where B.ZYHGHH||'A' like 'T%A' AND MZZYBZ||'A'='0A' AND JYDLY0='2' AND B.SQRQ00 >= '20171219' and B.SQRQ00 <= '20171219' AND LRY000=418 and exists(select 1 from JY_YW0000 where ZYGHID=B.ZYGHID and SQKS00+0 not in (select BMBH00 from vw_jy_tjks00) and JGZT00 in ('0','1')) order by b.BRID00 desc 262 11:06:16 SQL Execute: ORACLE - select distinct BRXM00,MZZYBZ,XBMC00 BRXB00,CSRQ00 BRCSRQ,BRID00,ZYHGHH GHH000,ZYGHID GHID00,'N' SFXZ00,NL0000||NLDWMC BRNL00,(SELECT SFYX00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) SFYX00,(SELECT TYDWMC FROM BM_BRXXB0 WHERE BRID00=B.BRID00) TYDWMC,(SELECT BRDH00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) BRDH00, LRY000 from VW_JY_YW0000 B where B.ZYHGHH||'A' like 'T%A' AND MZZYBZ||'A'='0A' AND JYDLY0='2' AND B.SQRQ00 >= '20171219' and B.SQRQ00 <= '20171219' AND LRY000=418 and exists(select 1 from JY_YW0000 where ZYGHID=B.ZYGHID and SQKS00+0 not in (select BMBH00 from vw_jy_tjks00) and JGZT00 in ('0','1')) order by b.BRID00 asc 263 11:06:16 SQL Execute: ORACLE - select BMMC00 from bm_bmbm00 where bmmc00 like '%体检中心%' and FLAG00='0' 264 11:06:16 SQL Execute: ORACLE - select BMBH00 from bm_bmbm00 where bmmc00 like '%体检中心%' and FLAG00='0' 265 11:06:16 SQL Execute: ORACLE - select BMMC00 from bm_bmbm00 where bmmc00 like '%体检中心%' and FLAG00='0' 266 11:06:16 SQL Execute: ORACLE - select distinct BRXM00,MZZYBZ,XBMC00 BRXB00,CSRQ00 BRCSRQ,BRID00,ZYHGHH GHH000,ZYGHID GHID00,'N' SFXZ00,NL0000||NLDWMC BRNL00,(SELECT SFYX00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) SFYX00,(SELECT TYDWMC FROM BM_BRXXB0 WHERE BRID00=B.BRID00) TYDWMC,(SELECT BRDH00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) BRDH00, LRY000 from VW_JY_YW0000 B where B.ZYHGHH||'A' like 'T%A' AND MZZYBZ||'A'='0A' AND JYDLY0='2' AND B.SQRQ00 >= '20171219' and B.SQRQ00 <= '20171219' AND LRY000=418 and exists(select 1 from JY_YW0000 where ZYGHID=B.ZYGHID and SQKS00+0 in (select BMBH00 from vw_jy_tjks00) and JGZT00 in ('0','1')) order by b.BRID00 asc 267 11:06:16 SQL Execute: ORACLE - select nvl(FLOOR(substr(brnl00,1,length(brnl00)-1)),0) brnlsl,trim(substr(brnl00,length(brnl00),1)) brnldw from (select substr(sf_JY_csrqtonl('19831219'),1,6) BRNL00 from dual) 268 11:06:16 SQL Execute: ORACLE - Select yjdjh0,a.zlxmid,zlxmjc,a.bbid00,bbmc00,sqrq00 kdrq00,jgzt00,sqys00,sqks00,zwxm00 sqysxm,bmmc00 sqksmc,SFKY00,a.LRY000 from jy_yw0000 a,bm_zlzd00 b,bm_bmbm00 c,bm_ygbm00 d,bm_bbzd00 e where a.zlxmid=b.zlxmid and a.sqks00=c.bmbh00 and a.sqys00=d.ygbh00 and a.bbid00=e.bbid00(+) and a.zyhghh = 'T33166' and a.zyghid = '9467282' and a.mzzybz='0' and a.zlxmid<>99999999 269 11:06:16 SQL Execute: ORACLE - select BMMC00 from bm_bmbm00 where bmmc00 like '%体检中心%' and FLAG00='0' 270 11:06:16 SQL Execute: ORACLE - select BMBH00 from bm_bmbm00 where bmmc00 like '%体检中心%' and FLAG00='0' 271 11:06:16 SQL Execute: ORACLE - select BMMC00 from bm_bmbm00 where bmmc00 like '%体检中心%' and FLAG00='0' 272 11:06:16 SQL Execute: ORACLE - select distinct BRXM00,MZZYBZ,XBMC00 BRXB00,CSRQ00 BRCSRQ,BRID00,ZYHGHH GHH000,ZYGHID GHID00,'N' SFXZ00,NL0000||NLDWMC BRNL00,(SELECT SFYX00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) SFYX00,(SELECT TYDWMC FROM BM_BRXXB0 WHERE BRID00=B.BRID00) TYDWMC,(SELECT BRDH00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) BRDH00, LRY000 from VW_JY_YW0000 B where B.ZYHGHH||'A' like 'T%A' AND MZZYBZ||'A'='0A' AND JYDLY0='2' AND B.SQRQ00 >= '20171219' and B.SQRQ00 <= '20171219' AND LRY000=418 and exists(select 1 from JY_YW0000 where ZYGHID=B.ZYGHID and SQKS00+0 in (select BMBH00 from vw_jy_tjks00) and JGZT00 in ('0','1')) order by b.BRID00 asc 273 11:06:16 SQL Execute: ORACLE - select nvl(FLOOR(substr(brnl00,1,length(brnl00)-1)),0) brnlsl,trim(substr(brnl00,length(brnl00),1)) brnldw from (select substr(sf_JY_csrqtonl('19831219'),1,6) BRNL00 from dual) 274 11:06:16 SQL Execute: ORACLE - Select yjdjh0,a.zlxmid,zlxmjc,a.bbid00,bbmc00,sqrq00 kdrq00,jgzt00,sqys00,sqks00,zwxm00 sqysxm,bmmc00 sqksmc,SFKY00,a.LRY000 from jy_yw0000 a,bm_zlzd00 b,bm_bmbm00 c,bm_ygbm00 d,bm_bbzd00 e where a.zlxmid=b.zlxmid and a.sqks00=c.bmbh00 and a.sqys00=d.ygbh00 and a.bbid00=e.bbid00(+) and a.zyhghh = 'T33166' and a.zyghid = '9467282' and a.mzzybz='0' and a.zlxmid<>99999999 275 11:06:16 SQL Execute: ORACLE - select distinct BRXM00,MZZYBZ,XBMC00 BRXB00,CSRQ00 BRCSRQ,BRID00,ZYHGHH GHH000,ZYGHID GHID00,'N' SFXZ00,NL0000||NLDWMC BRNL00,(SELECT SFYX00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) SFYX00,(SELECT TYDWMC FROM BM_BRXXB0 WHERE BRID00=B.BRID00) TYDWMC,(SELECT BRDH00 FROM BM_BRXXB0 WHERE BRID00=B.BRID00) BRDH00, LRY000 from VW_JY_YW0000 B where B.ZYHGHH||'A' like 'T%A' AND MZZYBZ||'A'='0A' AND JYDLY0='2' AND B.SQRQ00 >= '20171219' and B.SQRQ00 <= '20171219' AND LRY000=418 and exists(select 1 from JY_YW0000 where ZYGHID=B.ZYGHID and SQKS00+0 in (select BMBH00 from vw_jy_tjks00) and JGZT00 in ('0','1')) order by b.BRID00 asc 276 11:06:16 SQL Execute: ORACLE - select nvl(FLOOR(substr(brnl00,1,length(brnl00)-1)),0) brnlsl,trim(substr(brnl00,length(brnl00),1)) brnldw from (select substr(sf_JY_csrqtonl('19831219'),1,6) BRNL00 from dual) 277 11:06:16 SQL Execute: ORACLE - Select yjdjh0,a.zlxmid,zlxmjc,a.bbid00,bbmc00,sqrq00 kdrq00,jgzt00,sqys00,sqks00,zwxm00 sqysxm,bmmc00 sqksmc,SFKY00,a.LRY000 from jy_yw0000 a,bm_zlzd00 b,bm_bmbm00 c,bm_ygbm00 d,bm_bbzd00 e where a.zlxmid=b.zlxmid and a.sqks00=c.bmbh00 and a.sqys00=d.ygbh00 and a.bbid00=e.bbid00(+) and a.zyhghh = 'T33166' and a.zyghid = '9467282' and a.mzzybz='0' and a.zlxmid<>99999999 278 11:06:16 SQL Execute: ORACLE - select nvl(FLOOR(substr(brnl00,1,length(brnl00)-1)),0) brnlsl,trim(substr(brnl00,length(brnl00),1)) brnldw from (select substr(sf_JY_csrqtonl('19831219'),1,6) BRNL00 from dual) 279 11:06:16 SQL Execute: ORACLE - Select yjdjh0,a.zlxmid,zlxmjc,a.bbid00,bbmc00,sqrq00 kdrq00,jgzt00,sqys00,sqks00,zwxm00 sqysxm,bmmc00 sqksmc,SFKY00,a.LRY000 from jy_yw0000 a,bm_zlzd00 b,bm_bmbm00 c,bm_ygbm00 d,bm_bbzd00 e where a.zlxmid=b.zlxmid and a.sqks00=c.bmbh00 and a.sqys00=d.ygbh00 and a.bbid00=e.bbid00(+) and a.zyhghh = 'T33166' and a.zyghid = '9467282' and a.mzzybz='0' and a.zlxmid<>99999999 280 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 418 281 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 282 11:06:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 283 11:06:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 284 11:06:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 285 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 418 286 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 287 11:06:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 288 11:06:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JMXZ 289 11:06:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 290 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 291 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 292 11:06:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 293 11:06:19 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,PYRQ01,BRXM00,YEXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM,JYKDY0,decode(MZZYBZ||SFTJ00,'0Y','体','0N','门','住') MZZY00 , decode(JGZT00,'2','未处理','4','待审核','5','已处理','6','已审核','8','已打印','9','已打印') JGZTMC,SFTJ00,JGZT00,SFCJJZ from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,decode(nvl(FCYBH0,'0'),'0','','复*')||BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,YEXM00,ZYHGHH,MZZYBZ,SF_JY_GETYBHJZBZ(A.YBH000,A.PYRQ00) yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00,SFCJJZ from VW_JYYW_JYJG00_TEMP A where YBH000 like ( ? ||'%' ) and (PYRQ00 between decode('N','Y',to_char(sysdate-180,'YYYYMMDDD'),?) and decode('N','Y',to_char(sysdate,'YYYYMMDDD'),?)) and JGZT00||'A' in ('4A','5A') order by YBH000) 294 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 295 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 296 11:06:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 297 11:06:19 SQL Execute: ORACLE - select count(*) from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,decode(nvl(FCYBH0,'0'),'0','','复*')||BRXM00||decode(nvl(instr(CXSHYY,'已审核时撤销'),0),0,'','*撤') BRXM00,YEXM00,ZYHGHH,MZZYBZ,SF_JY_GETYBHJZBZ(A.YBH000,A.PYRQ00) yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00,SFCJJZ from VW_JYYW_JYJG00_TEMP A where YBH000 like ( ? ||'%' ) and (PYRQ00 between decode('N','Y',to_char(sysdate-180,'YYYYMMDDD'),?) and decode('N','Y',to_char(sysdate,'YYYYMMDDD'),?)) and JGZT00||'A' in ('4A','5A') ) 298 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 299 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 300 11:06:19 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00=? and YQDH00||YBH000= ? AND SFZY00 = 'Y' 301 11:06:19 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 302 11:06:19 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 303 11:06:19 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 304 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 305 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 306 11:06:19 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 307 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 308 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 309 11:06:19 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? order by jyywid desc 310 11:06:19 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='A2' 311 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 312 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 313 11:06:19 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 314 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 315 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 316 11:06:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 317 11:06:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 318 11:06:19 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 319 11:06:19 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 320 11:06:19 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 321 11:06:19 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 322 11:06:19 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 323 11:06:19 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 324 11:06:19 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 325 11:06:19 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0002 326 11:06:19 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 327 11:06:19 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 418 328 11:06:19 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 329 11:06:19 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 330 11:06:19 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 331 11:06:19 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 332 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 333 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 334 11:06:21 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00=? and YQDH00||YBH000= ? AND SFZY00 = 'Y' 335 11:06:21 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 336 11:06:21 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 337 11:06:21 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 338 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 339 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 340 11:06:21 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 341 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 342 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 343 11:06:21 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? order by jyywid desc 344 11:06:21 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='A2' 345 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 346 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 347 11:06:21 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 348 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 349 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 350 11:06:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 351 11:06:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 352 11:06:21 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 353 11:06:21 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 354 11:06:21 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 355 11:06:21 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 356 11:06:21 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 357 11:06:21 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 358 11:06:21 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171218 359 11:06:21 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = XN0011 360 11:06:21 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, (select fcjg00 from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fcjg00, (select fczcbz from vw_jy_fcjg00 where pyrq00 = ? AND ybh000 = ? and bgxmid=a.bgxmid) fczcbz, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00,a.SFXSHQ,a.SJLY00,a.FCXX00,a.FCSX00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 361 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 418 362 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 363 11:06:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 364 11:06:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 365 11:06:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 366 11:06:21 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 418 367 11:06:21 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = XN 368 11:06:21 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 369 11:06:21 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = CKJM 370 11:06:21 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 371 11:06:22 SQL Execute: ORACLE - select decode(bgxmid,'999999','1','999998','2','999997','3','999996','4','999995','5','999994','6','999993','7','999992','8','999991','9','999990','10','RBCPLT') txmc00,bgxmid,photo1 from jy_jyjg00 where ybh000='XN0011' and pyrq00='20171218' and bgxmid in (999999,999998,999997,999996,999995,999994,999993,999992,999991,999990,999989,999988) order by bgxmid desc 372 11:06:22 SQL Execute: ORACLE - select decode(bgxmid,'999999','1','999998','2','999997','3','999996','4','999995','5','999994','6','999993','7','999992','8','999991','9','999990','10','RBCPLT') txmc00,bgxmid,photo1 from jy_jyjg00_temp where ybh000='XN0011' and pyrq00='20171218' and bgxmid in (999999,999998,999997,999996,999995,999994,999993,999992,999991,999990,999989,999988) order by bgxmid desc