1 16:13:48 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='5401854' and LBBH00='0' 2 16:13:48 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='611000' and ZT0000='1' 3 16:13:48 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='611000' and ZT0000='1' 4 16:13:49 SQL Execute: ORACLE - Select SYSDATE from Dual 5 16:13:49 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 6 16:13:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 7 16:13:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-MMRK' and KLDH00 not in ('CK','JMCK') 8 16:13:49 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 9 16:13:50 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'SBKC19438122' and ICKNBH = 'SBKC19438122' 10 16:13:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3835 11 16:13:50 SQL Execute: ORACLE - select ZDXL00 FROM BM_YD0000 WHERE YPNM00=? 12 16:13:50 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=191 and YPNM00=3858 and SJKCSL>0 13 16:13:50 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=191 and YPNM00=4138 and SJKCSL>0 14 16:13:50 SQL Execute: ORACLE - select * from VW_YS_YBFDMYPSR where YFBMBH=191 and YPNM00=3835 and SJKCSL>0 15 16:13:50 SQL Execute: ORACLE - Delete from ys_cfmx00 where cflsh0='5507121' and cfid00 not in (-1) 16 16:13:50 SQL Data In: ORACLE - Rows affected = 0 17 16:13:50 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, ZJYFID, XMYFMC, YYZF00, SFZBY0,YPZSL0, CFDW00, ZHL000, ZFBL00, YBLB00, THBZ00,TSYS00, CQLY00)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '5507121','3858','ľÏã','10g','0.025','59','','10','g','59','','','N','40','g','1','0','5','0','','') 18 16:13:50 SQL Data In: ORACLE - Rows affected = 1 19 16:13:50 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, ZJYFID, XMYFMC, YYZF00, SFZBY0,YPZSL0, CFDW00, ZHL000, ZFBL00, YBLB00, THBZ00,TSYS00, CQLY00)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '5507121','4138','É°ÈÊ','10g','0.2375','59','','10','g','59','','','N','40','g','1','0','5','0','','') 20 16:13:50 SQL Data In: ORACLE - Rows affected = 1 21 16:13:50 SQL Execute: ORACLE - insert into YS_CFMX00 (CFID00, CFLSH0, YPNM00, YPMC00, YPGG00, LSDJ00, YFID00, PCID00,CSL000, JLDW00, ZJYFID, XMYFMC, YYZF00, SFZBY0,YPZSL0, CFDW00, ZHL000, ZFBL00, YBLB00, THBZ00,TSYS00, CQLY00)Values (SQ_YS_CFMX00_CFID00.NEXTVAL, '5507121','3835','»ÆÜÎ','10g','0.0831','59','','10','g','59','','','N','40','g','1','0','5','0','','') 22 16:13:50 SQL Data In: ORACLE - Rows affected = 1 23 16:13:50 SQL Execute: ORACLE - Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,DJH000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,ZYMRCS,BZID00,CFZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFMBMC,CFZJE0,BRDZ00,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS) Values ('5507121','191','10653483','5401854','611000','»ÆÕæÕæ','Å®',0,'3','979','221','301','2','0','4','0',0,0,'1',0,'979',to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),null,13.82,null, '','N','Y','100','',1) 24 16:13:50 SQL Data In: ORACLE - Rows affected = 1 25 16:13:50 SQL Execute: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,DJH000,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZYMRCS,BCCFH0,TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS)select CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,'19750801',DJH000,YSGZH0,'ÖìÀ¼',SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,a.BZID00,BZMC00,'0','N','0',FJFDJH,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,null,'0',ZYDJS0,ZYMRCS,'',TSBZBH,ZYSFJJ,ZYSFNJ,ZYNJJL,ZJZFID,ZYMRJS from YS_CFXXB0 a,BM_DMZD00 b where a.bzid00=b.bzid00(+) and CFLSH0='5507121' 26 16:13:50 SQL Data In: ORACLE - Rows affected = 1 27 16:13:50 SQL Execute: ORACLE - insert into YF_MZCFMX(CFID00,CFLSH0,YPNM00,YPMC00,YPGG00,LSDJ00,YPYFMC,PCMC00,CSL000,JLDW00,YYSJ00,YYSJDW,YFSMMC,ZB0000,ZJYFMC,XMYFMC,YPZSL0,CFDW00,ZHL000,CXBZ00,SFXS00,SFZBY0,THBZ00,PSLBID,ZFBL00,YBLB00,BZ0000,ZXCS00, CQLY00,F2J000)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00),b.YPYFMC,c.PCMC00,(DECODE(A.CSL000,NULL,NULL,(ROUND((a.CSL000/d.NSBL00),4)))),a.JLDW00,a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,(ROUND((a.YPZSL0/d.NSBL00),3)),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,ZXCS00, a.CQLY00, a.F2J000 from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.YPNM00=d.YPNM00 AND a.CFLSH0='5507121' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 28 16:13:50 SQL Data In: ORACLE - Rows affected = 3 29 16:13:50 SQL Data In: ORACLE - Param = 1, Name = AS_YZCFID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5507121 30 16:13:50 SQL Data In: ORACLE - Param = 2, Name = AD_ZYGHID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5401854 31 16:13:50 SQL Data In: ORACLE - Param = 3, Name = AS_LRXM00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = ÖìÀ¼ 32 16:13:50 SQL Data In: ORACLE - Param = 4, Name = AS_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 33 16:13:50 SQL Data In: ORACLE - Param = 5, Name = AS_ZYCFPD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 34 16:13:50 SQL Execute: ORACLE - BEGIN "SP_YS_YJXMZDDC" (AS_YZCFID => :AS_YZCFID,AD_ZYGHID => :AD_ZYGHID,AS_LRXM00 => :AS_LRXM00,AS_JZBZ00 => :AS_JZBZ00,AS_ZYCFPD => :AS_ZYCFPD); END; 35 16:13:50 SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 36 16:13:50 SQL Data In: ORACLE - Param = 2, Name = V_GHZYID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 10653483.000000 37 16:13:50 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 16:13:50 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 39 16:13:50 SQL Execute: ORACLE - BEGIN "SP_XT_TSXZ00" (V_FLAG00 => :V_FLAG00,V_GHZYID => :V_GHZYID,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0); END;