1 16:28:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = Z024 2 16:28:34 SQL Execute: ORACLE - Select g.sfxmid,g.zlxmid,xmmc00,zlxmjc,zlxmbh,gxid00,s.fymc00 from xt_zlsfgx g,vw_bm_zlzd00 z,vw_bm_yysfxm s where g.zlxmid=z.zlxmid and g.sfxmid=s.sfxmid and z.zlxmbh=? 3 16:28:37 SQL Execute: ORACLE - Select dw0000,nvl(FYID00,'0') FYID00 from bm_yysfxm where bh0000='503022010000' 4 16:28:37 SQL Data In: ORACLE - Param = 1, Name = SJXMBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = Z024 5 16:28:37 SQL Data In: ORACLE - Param = 2, Name = LBBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 6 16:28:37 SQL Data In: ORACLE - Param = 3, Name = ZLXMJC, Type = fldZSTRING, Precision = 42, Scale = 0, Data = ²¡¶¾Ãð»îѪ½¬£¨ÆÕͨ±ù¶³Ñª½¬£©[ÆÕͨ±ù¶³Ñª½¬] 7 16:28:37 SQL Data In: ORACLE - Param = 4, Name = GDXMBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 8 16:28:37 SQL Data In: ORACLE - Param = 5, Name = JGDW00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 9 16:28:37 SQL Data In: ORACLE - Param = 6, Name = CKZ000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 10 16:28:37 SQL Data In: ORACLE - Param = 7, Name = DW0000, Type = fldZSTRING, Precision = 9, Scale = 0, Data = ÿ100ºÁÉý 11 16:28:37 SQL Data In: ORACLE - Param = 8, Name = WBM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 12 16:28:37 SQL Data In: ORACLE - Param = 9, Name = PYM000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 13 16:28:37 SQL Data In: ORACLE - Param = 10, Name = LBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 16:28:37 SQL Data In: ORACLE - Param = 11, Name = XXMS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 15 16:28:37 SQL Data In: ORACLE - Param = 12, Name = FBZXBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 16 16:28:37 SQL Data In: ORACLE - Param = 13, Name = SFYXSQ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 17 16:28:37 SQL Data In: ORACLE - Param = 14, Name = BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 18 16:28:37 SQL Data In: ORACLE - Param = 15, Name = QYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 19 16:28:37 SQL Data In: ORACLE - Param = 16, Name = PZLXMBH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 16:28:37 SQL Data In: ORACLE - Param = 17, Name = PZXKS00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 21 16:28:37 SQL Data In: ORACLE - Param = 18, Name = PFYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 22 16:28:37 SQL Execute: ORACLE - BEGIN "SP_YJ_ZLXMADD" (SJXMBH => :SJXMBH,LBBZ00 => :LBBZ00,ZLXMJC => :ZLXMJC,GDXMBZ => :GDXMBZ,JGDW00 => :JGDW00,CKZ000 => :CKZ000,DW0000 => :DW0000,WBM000 => :WBM000,PYM000 => :PYM000,LBBH00 => :LBBH00,XXMS00 => :XXMS00,FBZXBZ => :FBZXBZ,SFYXSQ => :SFYXSQ,BZ0000 => :BZ0000,QYRQ00 => :QYRQ00,PZLXMBH => :PZLXMBH,PZXKS00 => :PZXKS00,PFYID00 => :PFYID00); END; 23 16:28:38 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 = 'C') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 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 = '15') AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null) 24 16:28:38 SQL Execute: ORACLE - select a.zlxmid,b.sfxmid from bm_zlzd00 a ,bm_yysfxm b where zlxmbh='Z024107' and b.bh0000='503022010000' and mzfpid is not null and mzfpid is not null and flag00='1' 25 16:28:38 SQL Execute: ORACLE - insert into xt_zlsfgx (gxid00,zlxmid,sfxmid) select SQ_XT_ZLSFGX_GXID00.Nextval,zlxmid,sfxmid from bm_zlzd00 a ,bm_yysfxm b where zlxmbh='Z024107' and b.bh0000='503022010000' and mzfpid is not null and mzfpid is not null and flag00='1' 26 16:28:38 SQL Data In: ORACLE - Rows affected = 0 27 16:28:38 SQL Execute: ORACLE - commit 28 16:28:38 SQL Data In: ORACLE - Rows affected = 0 29 16:28:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 224465 30 16:28:38 SQL Execute: ORACLE - Select zlxmid,zlxmbh,zlxmjc,lbbz00 "flag00" FROM bm_zlzd00 where ( lbbz00='0' or (lbbz00='1' and tzrq00 is null)) and (rpad(nvl(FYID00,'0'),6,' ')=rpad('0',6,' ') or FYID00=rpad(?,6,' ')) order by zlxmbh 31 16:28:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = Z024107 32 16:28:44 SQL Execute: ORACLE - Select g.sfxmid,g.zlxmid,xmmc00,zlxmjc,zlxmbh,gxid00,s.fymc00 from xt_zlsfgx g,vw_bm_zlzd00 z,vw_bm_yysfxm s where g.zlxmid=z.zlxmid and g.sfxmid=s.sfxmid and z.zlxmbh=? 33 16:28:48 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 = 'C') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 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 = '15') AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null) 34 16:28:58 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 = 'C') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 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 = '15') AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null) 35 16:29:08 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 = 'C') and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',15,')> 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 = '15') AND (INSTR (',' || a.jsksbh || ',',',15,') > 0 or a.jsksbh is null)