1 15:55:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2849765 2 15:55:11 SQL Execute: ORACLE - select * from YS_CFXXB0 where CFLSH0=? and YPDLBH in ('0','1') and CFXZ00='0' 3 15:55:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 2716449 4 15:55:11 SQL Execute: ORACLE - select * from ys_cfxxb0 where cflsh0=(select max(cflsh0) from YS_CFXXB0 where GHH000=? and YPDLBH in ('0','1') and CFXZ00='0') 5 15:55:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6412287 6 15:55:11 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2849069 7 15:55:11 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2849069 8 15:55:11 SQL Execute: ORACLE - select CFZT00,YSXM00,bccfh0 from YF_MZCF00 where ghid00=? and (cflsh0=? or bccfh0=?) 9 15:55:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2849069 10 15:55:11 SQL Execute: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH ,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=? and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 11 15:55:11 SQL Execute: ORACLE - select count(1) from YS_CFXXB0 where GHH000='2716449' and to_number(CFLSH0)to_number('2849069') and YPDLBH in ('0','1') and CFXZ00='0' and rownum=1 12 15:55:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = Ö÷ÖÎÒ½Éú 13 15:55:13 SQL Execute: ORACLE - select ghqxbz from bm_ghlbb0 where lbmc00=? 14 15:55:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 2716449 15 15:55:13 SQL Execute: ORACLE - select HBQX00 from SF_BRXXB0 where GHH000=? 16 15:55:13 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 608844.000000 17 15:55:13 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6412287.000000 18 15:55:13 SQL Data In: ORACLE - Param = 3, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000 19 15:55:13 SQL Data In: ORACLE - Param = 4, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 15:55:13 SQL Data In: ORACLE - Param = 5, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 15:55:13 SQL Execute: ORACLE - BEGIN "SP_YS_KJCFSTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_YSGZH0 => :V_YSGZH0,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE); END; 22 15:55:13 SQL Data In: ORACLE - Param = 1, Name = V_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 608844.000000 23 15:55:13 SQL Data In: ORACLE - Param = 2, Name = V_GHID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6412287.000000 24 15:55:13 SQL Data In: ORACLE - Param = 3, Name = V_RETURN, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 25 15:55:13 SQL Data In: ORACLE - Param = 4, Name = V_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 26 15:55:13 SQL Data In: ORACLE - Param = 5, Name = V_ZYCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = X 27 15:55:13 SQL Data In: ORACLE - Param = 6, Name = V_YSGZH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197.000000 28 15:55:13 SQL Execute: ORACLE - BEGIN "SP_YS_XZCFTSXZ" (V_BRID00 => :V_BRID00,V_GHID00 => :V_GHID00,V_RETURN => :V_RETURN,V_MESSAGE => :V_MESSAGE,V_ZYCFBZ => :V_ZYCFBZ,V_YSGZH0 => :V_YSGZH0); END; 29 15:55:13 SQL Data In: ORACLE - Param = 2, Name = p_LSH, Type = fldZSTRING, Precision = 10, Scale = 0, Data = MZYF_MZCFH 30 15:55:13 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 31 15:55:13 SQL Execute: ORACLE - BEGIN :Result := "SF_YK_GETLSH" (p_LSH => :p_LSH); END; 32 15:55:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2849770 33 15:55:13 SQL Execute: ORACLE - select a.*,'0' as cfmxzt,'N' as cfsffz,b.THBZ00 CFTHBZ,b.THYY00,(select LBBH00 from BM_YD0000 where YPNM00=a.YPNM00) YPLBBH ,(select XGCFZL from BM_YD0000 where YPNM00=a.YPNM00) XGCFZL from YS_CFMX00 a,YS_CFXXB0 b where a.CFLSH0=? and a.CFLSH0=b.CFLSH0 order by a.ZB0000,a.CFID00 34 15:55:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2849770 35 15:55:13 SQL Execute: ORACLE - select * from YS_CFXXB0 where CFLSH0=? 36 15:55:13 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=474 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 37 15:55:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 38 15:55:16 SQL Execute: ORACLE - Select * from (select YPMC00,YPNM00,YPBM00,LBBH00,ypmc02,YPGG00,PYSM00,WBSM00,JLDW00,MZFYDW,LSJ000,KCDW00,K2J000,M2J000,FYDJ00,XYKC00,YBLBMC,ZFBL00,YBLB00,YFID00,PCID00,ZQCD00,YYSJDW,CYL000,ZQS000,SFPSYY,YPSPMC,BZ0000,JXMC00,ypmclb,F2J000,YPBZ00,MRYYZF,NBLBMC,NBZFBL,ZDJKDJ,ZQCS00,YPXZ00,XGCFZL,YPSYSM,Colour from VW_YS_FDMYPSR a where (PYSM00 Like ?) and( LBBH00 in ('0','1','3') AND YFBMBH=479 AND CFJB00 <= 3 AND GZDJ00 <= '1' and KSSDJ0<='3' ) Order By PYSM00) where Rownum<=30 39 15:55:42 SQL Execute: ORACLE - select SF_YS_GETBRLSYPYYL(3391,608844) VTS000 from dual 40 15:55:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3391 41 15:55:42 SQL Execute: ORACLE - SELECT NDJCTS FROM BM_YD0000 WHERE YPNM00=? 42 15:55:42 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 43 15:55:42 SQL Data In: ORACLE - Param = 2, Name = P_YPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3391.000000 44 15:55:42 SQL Data In: ORACLE - Param = 3, Name = P_MCSL00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 45 15:55:42 SQL Data In: ORACLE - Param = 4, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 608844.000000 46 15:55:42 SQL Execute: ORACLE - BEGIN :Result := "SF_YS_GETCLY" (P_YPNM00 => :P_YPNM00,P_MCSL00 => :P_MCSL00,P_BRID00 => :P_BRID00); END; 47 15:55:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 48 15:55:46 SQL Execute: ORACLE - Select * from (select YPYFMC,YFID00,PYSM00,WBSM00,bz0000,YFDYJL from vw_BM_YPYF00 where (PYSM00 Like ?) Order By order0,PYSM00) where Rownum<=30 49 15:55:47 SQL Execute: ORACLE - select YFID00,YPYFMC from BM_YPYF00 50 15:55:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 51 15:55:48 SQL Execute: ORACLE - Select * from (select PCMC00,PCID00,PYSM00,WBSM00,SM0000,ZQCD00,ZQDW00,ZQCS00,BH0000 from VW_BM_PC0000 where (PYSM00 Like ?) and( (MZZYBZ='0' or MZZYBZ='1') ) Order By ORDER0,PYSM00) where Rownum<=30 52 15:55:50 SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3391 53 15:55:50 SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.100000 54 15:55:50 SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.100000 55 15:55:50 SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 56 15:55:50 SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 57 15:55:50 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 58 15:55:50 SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 608844.000000 59 15:55:50 SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 60 15:55:50 SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 61 15:55:50 SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6412287.000000 62 15:55:50 SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END; 63 15:55:55 SQL Data In: ORACLE - Param = 2, Name = p_ypnm00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 3391 64 15:55:55 SQL Data In: ORACLE - Param = 3, Name = p_mcsl00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.100000 65 15:55:55 SQL Data In: ORACLE - Param = 4, Name = p_z2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.100000 66 15:55:55 SQL Data In: ORACLE - Param = 5, Name = p_pcid00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 67 15:55:55 SQL Data In: ORACLE - Param = 6, Name = p_zqs000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000 68 15:55:55 SQL Data In: ORACLE - Param = 1, Name = Result, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 69 15:55:55 SQL Data In: ORACLE - Param = 7, Name = p_brid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 608844.000000 70 15:55:55 SQL Data In: ORACLE - Param = 8, Name = p_sftsbz, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 71 15:55:55 SQL Data In: ORACLE - Param = 9, Name = p_f2j000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 72 15:55:55 SQL Data In: ORACLE - Param = 10, Name = p_ghid00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6412287.000000 73 15:55:55 SQL Execute: ORACLE - BEGIN :Result := "SF_YS_LYLJS0" (p_ypnm00 => :p_ypnm00,p_mcsl00 => :p_mcsl00,p_z2j000 => :p_z2j000,p_pcid00 => :p_pcid00,p_zqs000 => :p_zqs000,p_brid00 => :p_brid00,p_sftsbz => :p_sftsbz,p_f2j000 => :p_f2j000,p_ghid00 => :p_ghid00); END;