1 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = A5 2 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 3 10:00:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 4 10:00:16 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,YJTS00 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,' ' YJTS00, (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) 5 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = A5 6 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 7 10:00:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 8 10:00:16 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,' ' YJTS00, (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') ) 9 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = A5 10 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 11 10:00:16 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00=? and YQDH00||YBH000= ? AND SFZY00 = 'Y' 12 10:00:16 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 13 10:00:16 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 14 10:00:16 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 15 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 16 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 17 10:00:16 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 18 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 19 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 20 10:00:16 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? order by jyywid desc 21 10:00:16 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='1' 22 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 23 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 24 10:00:16 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 25 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 26 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 27 10:00:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 28 10:00:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 29 10:00:16 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 30 10:00:16 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 31 10:00:16 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 32 10:00:16 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 33 10:00:16 SQL Data In: ORACLE - Param = 9, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 34 10:00:16 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 35 10:00:16 SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20200929 36 10:00:16 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = A50021 37 10:00:16 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,a.WJZSH0,a.JGYCBZ 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,a.WJZSH0,a.JGYCBZ from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 38 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2101 39 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2102 40 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2103 41 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2104 42 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2105 43 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2106 44 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2107 45 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2108 46 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2138 47 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2109 48 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2110 49 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2111 50 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2112 51 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2113 52 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2162 53 10:00:16 SQL Execute: ORACLE - select * from VW_JY_GSJSZD where BGXMID='2103' 54 10:00:16 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='7.4',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '1127',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='A50021' and PYRQ00='20200929' and bgxmid='2103' 55 10:00:16 SQL Data In: ORACLE - Rows affected = 1 56 10:00:16 SQL Execute: ORACLE - commit 57 10:00:16 SQL Data In: ORACLE - Rows affected = 0 58 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2103 59 10:00:16 SQL Execute: ORACLE - select * from VW_JY_GSJSZD where BGXMID='2106' 60 10:00:16 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='24.4',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '1127',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='A50021' and PYRQ00='20200929' and bgxmid='2106' 61 10:00:16 SQL Data In: ORACLE - Rows affected = 1 62 10:00:16 SQL Execute: ORACLE - commit 63 10:00:16 SQL Data In: ORACLE - Rows affected = 0 64 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2106 65 10:00:16 SQL Execute: ORACLE - select * from VW_JY_GSJSZD where BGXMID='2107' 66 10:00:16 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='1.4',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '1127',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='A50021' and PYRQ00='20200929' and bgxmid='2107' 67 10:00:16 SQL Data In: ORACLE - Rows affected = 1 68 10:00:16 SQL Execute: ORACLE - commit 69 10:00:16 SQL Data In: ORACLE - Rows affected = 0 70 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2107 71 10:00:16 SQL Execute: ORACLE - select * from VW_JY_GSJSZD where BGXMID='2109' 72 10:00:16 SQL Execute: ORACLE - update jy_jyjg00_temp set jyjg00='0.9',BGRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD'),CZR000 = '1127',BGSJ00 = TO_CHAR(SYSDATE,'HH24:MI:SS') where ybh000='A50021' and PYRQ00='20200929' and bgxmid='2109' 73 10:00:16 SQL Data In: ORACLE - Rows affected = 1 74 10:00:16 SQL Execute: ORACLE - commit 75 10:00:16 SQL Data In: ORACLE - Rows affected = 0 76 10:00:16 SQL Execute: ORACLE - select WJZSH0 from jy_jyjg00_temp where pyrq00='20200929' and ybh000='A50021' and bgxmid=2109 77 10:00:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1127 78 10:00:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = A5 79 10:00:16 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 80 10:00:16 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 81 10:00:16 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ?