1 15:48:05 SQL Execute: ORACLE - Select 1 from SF_BRXXB0 where GHH000='955484' and LBBH00='0' 2 15:48:05 SQL Execute: ORACLE - select KLDH00 from IC_YHXX00 where BRID00='121340' and ZT0000='1' 3 15:48:05 SQL Execute: ORACLE - select ICKH00 from IC_YHXX00 where BRID00='121340' and ZT0000='1' 4 15:48:05 SQL Execute: ORACLE - Select SYSDATE from Dual 5 15:48:05 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') 6 15:48:05 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') 7 15:48:05 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = 'FZYBK58273787' and ICKNBH = 'FZYBK58273787' 8 15:48:05 SQL Execute: ORACLE - select a.*,decode(sign(instr(',6344953,',CFID00||',')),0,0,1) XZBZ00 from VW_YS_BSCFMX a where cflsh0='1340720' 9 15:48:05 SQL Data In: ORACLE - Param = 2, Name = p_LSH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = MZYF_MZCFH 10 15:48:05 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 15:48:05 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (p_LSH => :p_LSH); END; 12 15:48:05 SQL Execute: ORACLE - select a.YFBMBH from YF_MZCF00 a where a.CFLSH0='1340720 ' 13 15:48:05 SQL Execute: ORACLE - select 1 from YS_CFMX00 a,YF_YPKCXX b where (b.pdxh00<>'0' and NVL(b.ztbz00,'0')='0') and b.ypnm00=a.ypnm00 and b.yfbmbh=133 and a.cflsh0='1340720 ' and instr(',6344953,',','||a.CFID00||',')>0 14 15:48:05 SQL Execute: ORACLE - select sum(round((((ROUND(B.LSDJ00/C.NSBL00,4)/C.K2J000)*C.M2J000)*a.YPZSL0) * 100) / 100) cfzje0 from YS_CFMX00 a,YF_YPKCXX b, bm_yd0000 c where a.ypnm00=c.ypnm00 and b.ypnm00=a.ypnm00 and (b.pdxh00<>'0' and NVL(b.ztbz00,'0')='0') and b.yfbmbh=133 and a.cflsh0='1340720 ' 15 15:48:05 SQL Execute: ORACLE - Insert into ys_cfxxb0 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,BRLB00,YSGZH0,SSKS00,GHKS00,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,CFZT00,CZY000,SRRQ00,SRSJ00,CFMBMC, CFZJE0,BRDZ00,ZJZFID,DJH000)select '1340733',133,2544253,'955484',BRID00,BRXM00,XB0000,BRLB00,277,144,139,YPDLBH,CFXZ00,ZYTS00,ZYDJS0,BZID00,'0',277,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),CFMBMC, 50.47 ,BRDZ00,ZJZFID,0 from ys_cfxxb0 where cflsh0='1340720 ' 16 15:48:05 SQL Data In: ORACLE - Rows affected = 1 17 15:48:05 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,YYSJ00,TSYS00,ZXCS00)select SQ_YS_CFMX00_CFID00.NEXTVAL,'1340733',a.YPNM00, A.YPMC00, A.YPGG00, ((ROUND(B.LSDJ00/C.NSBL00,4)/C.K2J000)*C.M2J000) LSDJ00, a.YFID00, a.PCID00, round(a.CSL000*a.F2J000/c.F2J000,4), nvl(trim(c.MZKFDW),c.JLDW00), a.ZJYFID, a.XMYFMC, a.YYZF00, a.SFZBY0, a.YPZSL0, a.CFDW00, a.ZHL000, a.ZFBL00, a.YBLB00, a.THBZ00,a.YYSJ00,null,a.ZXCS00 from YS_CFMX00 a,YF_YPKCXX b, BM_YD0000 C where A.YPNM00=C.YPNM00 and b.ypnm00=a.ypnm00 AND (b.pdxh00<>'0' and NVL(b.ztbz00,'0')='0') and b.yfbmbh=133 and a.cflsh0='1340720 ' and instr(',6344953,',','||a.CFID00||',')>0 18 15:48:05 SQL Data In: ORACLE - Rows affected = 1 19 15:48:05 SQL Execute: ORACLE - insert into YF_MZCF00 (CFLSH0,YFBMBH,GHID00,GHH000,BRID00,BRXM00,XB0000,CSRQ00,YSGZH0,YSXM00,SSKS00,GHKS00,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,CFZT00,SFKSLY,PSZT00,CZY000,SRRQ00,SRSJ00,CFZJE0,BRDZ00,BZ0000,CFSRBZ,ZYDJS0,ZJZFID,DJH000)select '1340733',133,2544253,'955484',BRID00,BRXM00,XB0000,CSRQ00,277,'»ÆÖÒÐý',144,139,ZYTS00,YPDLBH,CFXZ00,BZID00,BZMC00,'0',SFKSLY,'0',277,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),CFZJE0,BRDZ00,BZ0000,'0',ZYDJS0,ZJZFID,0 from YF_MZCF00 where CFLSH0='1340720 ' 20 15:48:05 SQL Data In: ORACLE - Rows affected = 1 21 15:48:05 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,TSYS00)select a.CFID00,a.CFLSH0,a.YPNM00,a.YPMC00,a.YPGG00,(a.LSDJ00*d.NSBL00) LSDJ00,b.YPYFMC,c.PCMC00,ROUND((a.CSL000*a.F2J000/d.F2J000)/d.NSBL00,2) CSL000,nvl(trim(d.MZKFDW),d.JLDW00),a.YYSJ00,a.YYSJDW,a.YYZF00,a.ZB0000,b.YPYFMC,a.XMYFMC,ROUND(a.YPZSL0/d.NSBL00,2),a.CFDW00,a.ZHL000,'Z','Y',SFZBY0,'0',a.PSLBID,a.ZFBL00,a.YBLB00,a.YYZF00,null from YS_CFMX00 a,BM_YPYF00 b,BM_PC0000 c, BM_YD0000 d where a.ypnm00=d.ypnm00 and a.CFLSH0='1340733' and a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) 22 15:48:05 SQL Data In: ORACLE - Rows affected = 1 23 15:48:05 SQL Data In: ORACLE - Param = 1, Name = V_FLAG00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 24 15:48:05 SQL Data In: ORACLE - Param = 2, Name = V_GHZYID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2544253.000000 25 15:48:05 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 26 15:48:05 SQL Data In: ORACLE - Param = 4, Name = V_ERROR0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 15:48:05 SQL Data In: ORACLE - Param = 5, Name = V_SFZDZD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 28 15:48:05 SQL Data In: ORACLE - Param = 6, Name = P_CFLSH0, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1340733 29 15:48:05 SQL Data In: ORACLE - Param = 7, Name = P_YSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 30 15:48:05 SQL Execute: ORACLE - BEGIN "SP_XT_TSXZ00" (V_FLAG00 => :V_FLAG00,V_GHZYID => :V_GHZYID,V_RETURN => :V_RETURN,V_ERROR0 => :V_ERROR0,V_SFZDZD => :V_SFZDZD,P_CFLSH0 => :P_CFLSH0,P_YSBH00 => :P_YSBH00); END; 31 15:48:05 SQL Data In: ORACLE - Param = 1, Name = AS_YZCFID, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1340733 32 15:48:05 SQL Data In: ORACLE - Param = 2, Name = AD_ZYGHID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 955484 33 15:48:05 SQL Data In: ORACLE - Param = 3, Name = AS_LRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = »ÆÖÒÐý 34 15:48:05 SQL Data In: ORACLE - Param = 4, Name = AS_JZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 35 15:48:05 SQL Data In: ORACLE - Param = 5, Name = AS_ZYCFPD, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 15:48:05 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; 37 15:48:05 SQL Execute: ORACLE - Update SF_BRXXB0 set THBZ00='2' where GHH000='955484' and THBZ00='1' 38 15:48:05 SQL Data In: ORACLE - Rows affected = 0 39 15:48:05 SQL Execute: ORACLE - commit 40 15:48:05 SQL Data In: ORACLE - Rows affected = 0