1 16:02:53 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where pyrq00='20180921' and ybh000='BD0001' and rownum=1 2 16:02:53 SQL Execute: ORACLE - select JYRXM0 from vw_JY_YW0000 where YBH000='BD0001' and pyrq00='20180921' and rownum=1 3 16:02:57 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 4 16:02:59 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 5 16:03:02 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='3309' and CZBZ00<>'2' and BMBH00='52' 6 16:03:02 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 7 16:03:02 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='3309' and CZBZ00 in ('1') 8 16:03:02 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 340 9 16:03:02 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 10 16:03:02 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 11 16:03:02 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGSH 12 16:03:02 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 13 16:03:02 SQL Execute: ORACLE - select count(1) from vw_jy_jyjg00_temp a where a.PYRQ00='20180921' and a.YBH000='BD0001' and jyjg00 is not null and nvl(a.jyywid,0)<>0 14 16:03:02 SQL Execute: ORACLE - select a.bgxmid,a.bgxmmc,a.jyjg00,b.ECTSBZ,b.ECSHNR from vw_jy_jyjg00_temp a,JY_BGXMZD b where a.bgxmid=b.bgxmid and a.PYRQ00='20180921' and a.YBH000='BD0001' and nvl(a.jyywid,0)<>0 15 16:03:02 SQL Execute: ORACLE - delete JY_JYJG00_temp where YBH000='BD0001' and yqdh00 in (select yqdh00 from jy_jyyqzd where SCKJL0='1') and PYRQ00='20180921' and BGXMID in (0) 16 16:03:02 SQL Data In: ORACLE - Rows affected = 0 17 16:03:02 SQL Execute: ORACLE - update JY_YW0000 set bbid00='7' where YBH000='BD0001' and PYRQ00='20180921' 18 16:03:02 SQL Data In: ORACLE - Rows affected = 1 19 16:03:02 SQL Execute: ORACLE - update JY_YW0000 set JGZT00='6',BGJYR0='340',CBGRQ0=TO_CHAR(SYSDATE,'YYYYMMDD'),CBGSJ0=TO_CHAR(SYSDATE,'HH24:MI:SS'),YXBZ00='N',BBSM00='', BBBZ00='', SFKY00='N' where YBH000='BD0001' and PYRQ00='20180921' 20 16:03:03 SQL Data In: ORACLE - Rows affected = 1 21 16:03:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 22 16:03:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 23 16:03:03 SQL Execute: ORACLE - select JGZCBZ,JYJG00,DECODE((SELECT JGXSFS FROM JY_JYYQZD WHERE YQDH00=A.YQDH00),'0',NVL(BZBM00,ZWMC00),NVL(ZWMC00,BZBM00)) BGXMMC ,JJZSX0,JJZXX0,YBH000,PYRQ00 from jy_jyjg00 a, jy_bgxmzd b where a.bgxmid=b.bgxmid and a.YBH000=? and a.PYRQ00=? and a.SFCJJZ='Y' 24 16:03:03 SQL Execute: ORACLE - update JY_YW0000 set YXBZ00='Y' where YBH000='BD0001' and PYRQ00='20180921' 25 16:03:03 SQL Data In: ORACLE - Rows affected = 1 26 16:03:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 27 16:03:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 28 16:03:03 SQL Execute: ORACLE - select BRXM00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 29 16:03:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 30 16:03:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 31 16:03:03 SQL Execute: ORACLE - select BRDH00 from BM_BRXXB0 where BRID00 in (select BRID00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 ) 32 16:03:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 33 16:03:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 34 16:03:03 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 35 16:03:07 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 36 16:03:09 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 37 16:03:09 SQL Execute: ORACLE - Commit 38 16:03:09 SQL Data In: ORACLE - Rows affected = 0 39 16:03:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 40 16:03:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 41 16:03:09 SQL Execute: ORACLE - select JGZCBZ,JYJG00,DECODE((SELECT JGXSFS FROM JY_JYYQZD WHERE YQDH00=A.YQDH00),'0',NVL(BZBM00,ZWMC00),NVL(ZWMC00,BZBM00)) BGXMMC ,JJZSX0,JJZXX0,YBH000,PYRQ00 from jy_jyjg00 a, jy_bgxmzd b where a.bgxmid=b.bgxmid and a.YBH000=? and a.PYRQ00=? and a.SFCJJZ='Y' 42 16:03:09 SQL Execute: ORACLE - update JY_YW0000 set YXBZ00='Y' where YBH000='BD0001' and PYRQ00='20180921' 43 16:03:09 SQL Data In: ORACLE - Rows affected = 1 44 16:03:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 45 16:03:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 46 16:03:09 SQL Execute: ORACLE - select BRXM00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 47 16:03:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 48 16:03:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 49 16:03:09 SQL Execute: ORACLE - select BRDH00 from BM_BRXXB0 where BRID00 in (select BRID00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 ) 50 16:03:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 51 16:03:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 52 16:03:09 SQL Execute: ORACLE - select SQYSXM from vw_jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 53 16:03:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 54 16:03:09 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 55 16:03:09 SQL Execute: ORACLE - select SQYS00 from vw_jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 56 16:03:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 57 16:03:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 58 16:03:10 SQL Execute: ORACLE - select BRID00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 59 16:03:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 60 16:03:10 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 61 16:03:10 SQL Execute: ORACLE - select DH0000 from BM_YGBM00 where YGBH00 in (select sqys00 from jy_yw0000 where pyrq00=? and YBH000=? and rownum=1 ) 62 16:03:16 SQL Execute: ORACLE - insert into YJ_DXTZ00(DXID00,DXNRFL,DXNR00,YWRQ00,BRID00,CZRQ00,CZSJ00,DH0000,JSR000) values(SQ_YJ_DXTZ00_DXID00.nextval,'检验危急值提醒','曾恩俤有超警戒值项目，请注意观察','20180921',5993240,to_char(sysdate,'yyyyMMdd'),to_char(sysdate,'hh24:mi:ss'),'11212','李红艳') 63 16:03:16 SQL Data In: ORACLE - Rows affected = 1 64 16:03:16 SQL Execute: ORACLE - commit 65 16:03:16 SQL Data In: ORACLE - Rows affected = 0 66 16:03:16 SQL Execute: ORACLE - select count(*) from JY_YW0000 where pyrq00='20180921' and YBH000='BD0001' and CBGRQ0||CBGSJ0>=to_char(to_date('2018092116:03:10', 'yyyy-mm-dd hh24:mi:ss')-10/1440,'yyyymmddhh24:mi:ss') 67 16:03:16 SQL Execute: ORACLE - select to_char(CEIL((TO_DATE(('2018092116:03:10') , 'YYYY-MM-DD HH24-MI-SS')-TO_DATE(CBGRQ0||CBGSJ0,'YYYY-MM-DD HH24-MI-SS')) * 24*60*60 )) from JY_YW0000 where pyrq00='20180921' and YBH000='BD0001' 68 16:03:17 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 69 16:03:19 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 70 16:03:27 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 71 16:03:29 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null) 72 16:03:30 SQL Execute: ORACLE - Rollback 73 16:03:30 SQL Data In: ORACLE - Rows affected = 0 74 16:03:30 SQL Execute: ORACLE - SELECT MAX(FCXH00) FROM JY_FCJL00 WHERE YBH000='BD0001' and PYRQ00='20180921' 75 16:03:30 SQL Execute: ORACLE - INSERT INTO JY_FCJL00(JYYWID,YBH000,TXM000,PYRQ00,ZLXMID,BGXMID,YSJYJG,JYJG00,OD0000,JGDW00,CKXX00,CKSX00,CKFW00,JGZCBZ,YQDH00,FSBZ00,SECTOR,CUPNUM,PHOTO1,PHOTO2,PHOTO3,SFDY00,BGRQ00,YQJCRQ,BGSJ00,JJZSX0,JJZXX0,SFCJJZ,SFCYQZ,CZR000,FCXH00) SELECT JYYWID,YBH000,TXM000,PYRQ00,ZLXMID,BGXMID,YSJYJG,JYJG00,OD0000,JGDW00,CKXX00,CKSX00,CKFW00,JGZCBZ,YQDH00,FSBZ00,SECTOR,CUPNUM,PHOTO1,PHOTO2,PHOTO3,SFDY00,BGRQ00,YQJCRQ,BGSJ00,JJZSX0,JJZXX0,SFCJJZ,SFCYQZ,CZR000,'1' FCXH00 FROM JY_JYJG00_TEMP WHERE YBH000='BD0001' and PYRQ00='20180921' AND SFCJJZ = 'Y' 76 16:03:30 SQL Data In: ORACLE - Rows affected = 0 77 16:03:30 SQL Execute: ORACLE - COMMIT 78 16:03:30 SQL Data In: ORACLE - Rows affected = 0 79 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 340 80 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 81 16:03:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 82 16:03:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 83 16:03:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 84 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 340 85 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 86 16:03:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 87 16:03:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JMXZ 88 16:03:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 89 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 90 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 91 16:03:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 92 16:03:30 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,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, (select decode(count(1),0,'0','1') from jy_jyjg00_temp where jyjg00 is not null and ybh000=a.ybh000 and pyrq00=a.pyrq00) sfcjg0 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) 93 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 94 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 95 16:03:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 96 16:03:30 SQL Execute: ORACLE - select count(*) from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,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, (select decode(count(1),0,'0','1') from jy_jyjg00_temp where jyjg00 is not null and ybh000=a.ybh000 and pyrq00=a.pyrq00) sfcjg0 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') ) 97 16:03:30 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 16:03:30 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 99 16:03:30 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 100 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 101 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 102 16:03:30 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? order by jyywid desc 103 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 104 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 105 16:03:30 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 106 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 107 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 108 16:03:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 109 16:03:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 110 16:03:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 111 16:03:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 112 16:03:30 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 113 16:03:30 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 114 16:03:30 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 115 16:03:30 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 116 16:03:30 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 117 16:03:30 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 118 16:03:30 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.CUTOFF 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.CUTOFF from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 119 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 120 16:03:30 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00=? 121 16:03:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 340 122 16:03:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 123 16:03:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 124 16:03:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 125 16:03:30 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 126 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 127 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 128 16:03:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 129 16:03:32 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,BRXM00,YEXM00,ZYHGHH,MZZYBZ,SF_JY_GETYBHJZBZ(A.YBH000,A.PYRQ00) yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00,SFCJJZ from VW_JYYW_JYJG00 A where PYRQ00 between ? and ? and YBH000 like ( ? ||'%' ) and JGZT00||'A' in ('6A') order by YBH000) 130 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 131 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 132 16:03:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 133 16:03:32 SQL Execute: ORACLE - select count(*) from (select distinct YBH000,PYRQ00,to_char(to_date(a.PYRQ00,'YYYYMMDD'),'YYYY-MM-DD') PYRQ01,BRXM00,YEXM00,ZYHGHH,MZZYBZ,SF_JY_GETYBHJZBZ(A.YBH000,A.PYRQ00) yxbz00,SECTOR,CUPNUM,JYKDY0,JGZT00,SFTJ00,SFCJJZ from VW_JYYW_JYJG00 A where PYRQ00 between ? and ? and YBH000 like ( ? ||'%' ) and JGZT00||'A' in ('6A') ) 134 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 135 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 136 16:03:32 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 137 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 138 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 139 16:03:32 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? order by jyywid desc 140 16:03:32 SQL Execute: ORACLE - update JY_YW0000 set YXBZ00='Y' where YBH000='BD0001' and PYRQ00='20180921' 141 16:03:32 SQL Data In: ORACLE - Rows affected = 1 142 16:03:32 SQL Execute: ORACLE - Commit 143 16:03:32 SQL Data In: ORACLE - Rows affected = 0 144 16:03:32 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='7' 145 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 146 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 147 16:03:32 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 148 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 340 149 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = BD 150 16:03:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 151 16:03:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = CKJM 152 16:03:32 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 153 16:03:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 154 16:03:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 155 16:03:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 156 16:03:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 157 16:03:32 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 158 16:03:32 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 159 16:03:32 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 160 16:03:32 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 161 16:03:32 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 162 16:03:32 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 163 16:03:32 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20180921 164 16:03:32 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = BD0001 165 16:03:32 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.CUTOFF 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.CUTOFF from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) where DECODE(NVL(jyywid,0),0,0,1)||SFJM00 = '1N' order by DYSX00 166 16:03:37 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'J') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',52,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',340,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =340 AND b.JSKSBH = '52') AND (INSTR (',' || a.jsksbh || ',',',52,') > 0 or a.jsksbh is null)