1 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = TC 2 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 3 18:37:03 SQL Execute: ORACLE - select count(*) from JY_ZLKZBB where YQDH00=? and YQDH00||YBH000= ? AND SFZY00 = 'Y' 4 18:37:03 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 5 18:37:03 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 6 18:37:03 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 7 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 8 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 9 18:37:03 SQL Execute: ORACLE - SELECT BBID00 FROM VW_JY_YW0000 WHERE YBH000 = ? AND PYRQ00=? 10 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 11 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 12 18:37:03 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000=? and PYRQ00=? order by jyywid desc 13 18:37:03 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='7' 14 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 15 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 16 18:37:03 SQL Execute: ORACLE - select b.zlxmjc from jy_ywmx00 a,bm_zlzd00 b where YBH000 = ? and PYRQ00 = ? and a.zlxmid=b.zlxmid 17 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 18 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 19 18:37:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 20 18:37:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 21 18:37:03 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 22 18:37:03 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 23 18:37:03 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 24 18:37:03 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 25 18:37:03 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, FCYSJG 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, FCYSJG 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 26 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 27 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = TC 28 18:37:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 29 18:37:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGXG 30 18:37:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 31 18:37:03 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 32 18:37:03 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = TC 33 18:37:03 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 34 18:37:03 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = CKJM 35 18:37:03 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 36 18:37:06 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where pyrq00='20171120' and ybh000='TC0223' and rownum=1 37 18:37:06 SQL Execute: ORACLE - select JYRXM0 from vw_JY_YW0000 where YBH000='TC0223' and pyrq00='20171120' and rownum=1 38 18:37:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 39 18:37:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = TC 40 18:37:06 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGCL 41 18:37:06 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = JGSH 42 18:37:06 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = ? and YQDH00 = ? AND QXLX00 = ? and QXGNDH = ? 43 18:37:06 SQL Execute: ORACLE - select a.bgxmid,a.jyjg00,a.BGXMMC,b.ECTSBZ,b.ECSHNR,b.SFJZSH from vw_jy_jyjg00_temp a,JY_BGXMZD b where a.bgxmid=b.bgxmid and a.PYRQ00='20171120' and a.YBH000='TC0223' and nvl(a.jyywid,0)<>0 44 18:37:06 SQL Execute: ORACLE - delete JY_JYJG00_temp where YBH000='TC0223' and yqdh00 in (select yqdh00 from jy_jyyqzd where SCKJL0='1') and PYRQ00='20171120' and BGXMID in (0) 45 18:37:06 SQL Data In: ORACLE - Rows affected = 0 46 18:37:06 SQL Execute: ORACLE - update JY_YW0000 set bbid00='7' where YBH000='TC0223' and PYRQ00='20171120' 47 18:37:06 SQL Data In: ORACLE - Rows affected = 1 48 18:37:06 SQL Execute: ORACLE - update JY_YW0000 set JGZT00='6',BGJYR0='121',CBGRQ0=TO_CHAR(SYSDATE,'YYYYMMDD'),CBGSJ0=TO_CHAR(SYSDATE,'HH24:MI:SS'),YXBZ00='N',BBSM00='ºÏ¸ñ', BBBZ00='', SFKY00='N' where YBH000='TC0223' and PYRQ00='20171120' 49 18:37:06 SQL Data In: ORACLE - Rows affected = 1 50 18:37:06 SQL Execute: ORACLE - select zlxmjc from vw_jy_yw0000 where jgzt00 in ('1','2') and txm000='0500467013' 51 18:37:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = TC0223 52 18:37:06 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20171120 53 18:37:06 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' 54 18:37:06 SQL Execute: ORACLE - Commit 55 18:37:06 SQL Data In: ORACLE - Rows affected = 0 56 18:37:06 SQL Execute: ORACLE - select distinct jyywid,ybh000,sftj00,yjdjh0,sfbz00 from jy_yw0000 where nvl(SFLSTD,'N')<>'Y' and pyrq00='20171120' and ybh000 between 'TC0223' and 'TC0223' order by ybh000,jyywid 57 18:37:06 SQL Execute: ORACLE - Rollback 58 18:37:06 SQL Data In: ORACLE - Rows affected = 0