1 18:58:23 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 2 18:58:23 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 3 18:58:29 SQL Execute: ORACLE - select * from VW_JY_YW0000 where TXM000='0100436660' 4 18:58:30 SQL Execute: ORACLE - select count(1) from JY_HGSJJL where txm000='0100436660' 5 18:58:30 SQL Execute: ORACLE - select * from VW_JY_BBCJXX where TXM000='0100436660' 6 18:58:32 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 7 18:58:33 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 8 18:58:36 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 9 18:58:36 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 10 18:58:43 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 11 18:58:44 SQL Execute: ORACLE - SELECT YGBH00 FROM BM_YGBM00 WHERE UPPER(XKH000)='HIS' 12 18:58:44 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 13 18:58:44 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='HIS' and CZBZ00 in ('1') 14 18:58:44 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 15 18:58:44 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 16 18:58:44 SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_HGSJJL WHERE JJLB00 in ('1','2') AND TXM000 = '0100436660' 17 18:58:44 SQL Execute: ORACLE - insert into JY_HGSJJL(TXM000,SCR000,SDR000,SDRQ00,SDSJ00,JJLB00) values ('0100436660','284','284','20181120','18:58:44','1') 18 18:58:44 SQL Data In: ORACLE - Rows affected = 1 19 18:58:44 SQL Execute: ORACLE - Commit 20 18:58:44 SQL Data In: ORACLE - Rows affected = 0 21 18:58:53 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 22 18:59:02 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 23 18:59:03 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 24 18:59:13 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 25 18:59:23 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 26 18:59:23 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 27 18:59:32 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 28 18:59:33 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 29 18:59:43 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 30 18:59:53 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 31 19:00:02 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 32 19:00:03 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 33 19:00:09 SQL Execute: ORACLE - select * from (select * from VW_JY_YW0000 where TXM000='0100436660' order by jgzt00) where rownum=1 34 19:00:09 SQL Execute: ORACLE - select TO_CHAR(SYSDATE,'YYYYMMDD HH24:MI:SS') from dual 35 19:00:09 SQL Execute: ORACLE - select * from VW_JY_BBCJXX where TXM000='0100436660' 36 19:00:13 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 37 19:00:13 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDDHH24:MI:SS') OraSysDate FROM DUAL 38 19:00:13 SQL Execute: ORACLE - SELECT COUNT(*) FROM JY_YW0000 WHERE JGZT00 IN (0,1) AND YJDJH0 = '24225735' 39 19:00:13 SQL Execute: ORACLE - select yjdjh0 from jy_yw0000 A where A.TXM000='0100436660' and A.sgcjqz='01' 40 19:00:13 SQL Execute: ORACLE - select a.yjdjh0,a.zyhghh,xmzt00,a.mzzybz,b.yjksbh,a.sftj00 from jy_yw0000 a,yj_yw0000 b where a.yjdjh0=b.yjdjh0 and A.TXM000='0100436660' and A.sgcjqz='01' 41 19:00:13 SQL Execute: ORACLE - select KDKSBH from YJ_YW0000 where yjdjh0=24225735 42 19:00:13 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 0100436660 43 19:00:13 SQL Data In: ORACLE - Param = 2, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24225735 44 19:00:13 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 284 45 19:00:13 SQL Data In: ORACLE - Param = 4, Name = PCZYKS0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 40 46 19:00:13 SQL Data In: ORACLE - Param = 5, Name = PCZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 47 19:00:13 SQL Data In: ORACLE - Param = 6, Name = PTMSFSF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 19:00:13 SQL Execute: ORACLE - BEGIN "SP_JY_TXM000_CHARGE" (PTXM000 => :PTXM000,PYJDJH0 => :PYJDJH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCZBZ00 => :PCZBZ00,PTMSFSF => :PTMSFSF); END; 49 19:00:13 SQL Execute: ORACLE - select XMZT00 from YJ_YW0000 where yjdjh0=24225735 50 19:00:13 SQL Execute: ORACLE - select SL0000-ZXSL00-CXSL00 ZXSL00 from vw_yj_yw0000 where yjdjh0=24225735 and rownum=1 51 19:00:13 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 24225735 52 19:00:13 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 19:00:13 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 54 19:00:13 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 55 19:00:13 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = HIS 56 19:00:13 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 40.000000 57 19:00:13 SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 58 19:00:13 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00,PCOMMIT => :PCOMMIT); END; 59 19:00:14 SQL Execute: ORACLE - select SFTJ00 from JY_YW0000 where yjdjh0=24225735 60 19:00:14 SQL Execute: ORACLE - Update JY_YW0000 A set JGZT00 = '2',BBSDRQ = '20181120',BBSDSJ = '19:00:10',BBSDR0 = '284' where jgzt00 in ('1','0') and A.TXM000='0100436660' and A.sgcjqz='01' 61 19:00:14 SQL Data In: ORACLE - Rows affected = 1 62 19:00:14 SQL Execute: ORACLE - Commit 63 19:00:14 SQL Data In: ORACLE - Rows affected = 0 64 19:00:14 SQL Execute: ORACLE - Update JY_YW0000 A set JGZT00 = '2',BBSDRQ = '20181120',BBSDSJ = '19:00:10',BBSDR0 = '284' where jgzt00 in ('1','0') and sfbz00 in ('3') and A.TXM000='0100436660' and A.sgcjqz='01' 65 19:00:14 SQL Data In: ORACLE - Rows affected = 0 66 19:00:14 SQL Execute: ORACLE - Commit 67 19:00:14 SQL Data In: ORACLE - Rows affected = 0 68 19:00:23 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null) 69 19:00:23 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 70 19:00:32 SQL Execute: ORACLE - SELECT QZMC00 FROM JY_QDXHQZ WHERE CJXQ00 = (SELECT to_char(sysdate,'day') FROM DUAL) 71 19:00:33 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and XXXZ00='0' and (xtdm00 = '-1' OR xtdm00 = 'J') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',40,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',284,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =284 AND b.JSKSBH = '40') AND (INSTR (',' || a.jsksbh || ',',',40,') > 0 or a.jsksbh is null)