1       11:31:04  SQL Prepare: ORACLE - select SF_YS_CKBG00('0',805825,'1',0,5253080) from dual

2       11:31:04  SQL Execute: ORACLE - select SF_YS_CKBG00('0',805825,'1',0,5253080) from dual

3       11:31:05  SQL Prepare: ORACLE - select YPLBBH from BQ_YPYZ00 where YZID00=5253080 

4       11:31:05  SQL Execute: ORACLE - select YPLBBH from BQ_YPYZ00 where YZID00=5253080 

5       11:31:05  SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbys=952 and mbgs00='0' and mblbbh='00'

6       11:31:05  SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=952 and mbgs00='0' and mblbbh='00'

7       11:31:05  SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbks=66 and mbgs00='1' and mblbbh='01'

8       11:31:05  SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbks=66 and mbgs00='1' and mblbbh='01'

9       11:31:05  SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbys=0 and symbks=0 and mbgs00='2' and mblbbh='02'

10      11:31:05  SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=0 and symbks=0 and mbgs00='2' and mblbbh='02'

11      11:31:05  SQL Prepare: ORACLE - Select * from xt_yzmblb where (symbys=952 and mbgs00='0')
 or (symbks=66 and mbgs00='1')
 or (symbys=0 and symbks=0 and mbgs00='2')

12      11:31:05  SQL Execute: ORACLE - Select * from xt_yzmblb where (symbys=952 and mbgs00='0')
 or (symbks=66 and mbgs00='1')
 or (symbys=0 and symbks=0 and mbgs00='2')

13      11:31:05  SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

14      11:31:05  SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf

15      11:31:05  SQL Prepare: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0))) order by mbmc00

16      11:31:05  SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0))) order by mbmc00

17      11:31:05  SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       y.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0'
order by zbbh00,znxh00

18      11:31:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362.000000
19      11:31:05  SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       y.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0'
order by zbbh00,znxh00

20      11:31:05  SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       y.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0'
order by zbbh00,znxh00

21      11:31:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
22      11:31:05  SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       y.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0'
order by zbbh00,znxh00

23      11:31:05  SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       y.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0'
order by zbbh00,znxh00

24      11:31:05  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362.000000
25      11:31:05  SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00,
       m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000,
       y.ypmc00,f.ypyfmc,p.pcmc00,
       m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000,
       decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000,
       y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw,
       y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00
from   xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f
where  m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and
       m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0'
order by zbbh00,znxh00

26      11:31:09  SQL Prepare: ORACLE - Select sf_yj_GetWbsm('h') wbsm00,sf_yj_Getpysm('h') pysm00 from dual where rownum=1

27      11:31:09  SQL Execute: ORACLE - Select sf_yj_GetWbsm('h') wbsm00,sf_yj_Getpysm('h') pysm00 from dual where rownum=1

28      11:31:09  SQL Prepare: ORACLE - Select sf_yj_GetWbsm('ha') wbsm00,sf_yj_Getpysm('ha') pysm00 from dual where rownum=1

29      11:31:09  SQL Execute: ORACLE - Select sf_yj_GetWbsm('ha') wbsm00,sf_yj_Getpysm('ha') pysm00 from dual where rownum=1

30      11:31:09  SQL Prepare: ORACLE - Select sf_yj_GetWbsm('hao') wbsm00,sf_yj_Getpysm('hao') pysm00 from dual where rownum=1

31      11:31:09  SQL Execute: ORACLE - Select sf_yj_GetWbsm('hao') wbsm00,sf_yj_Getpysm('hao') pysm00 from dual where rownum=1

32      11:31:10  SQL Prepare: ORACLE - Select sf_yj_GetWbsm('ha') wbsm00,sf_yj_Getpysm('ha') pysm00 from dual where rownum=1

33      11:31:10  SQL Execute: ORACLE - Select sf_yj_GetWbsm('ha') wbsm00,sf_yj_Getpysm('ha') pysm00 from dual where rownum=1

34      11:31:10  SQL Prepare: ORACLE - Select sf_yj_GetWbsm('h') wbsm00,sf_yj_Getpysm('h') pysm00 from dual where rownum=1

35      11:31:10  SQL Execute: ORACLE - Select sf_yj_GetWbsm('h') wbsm00,sf_yj_Getpysm('h') pysm00 from dual where rownum=1

36      11:31:13  SQL Prepare: ORACLE - Select sf_yj_GetWbsm('ҩ') wbsm00,sf_yj_Getpysm('ҩ') pysm00 from dual where rownum=1

37      11:31:13  SQL Execute: ORACLE - Select sf_yj_GetWbsm('ҩ') wbsm00,sf_yj_Getpysm('ҩ') pysm00 from dual where rownum=1

38      11:31:21  SQL Prepare: ORACLE - select SQ_XT_YZMB00_MBID00.nextval from dual where rownum=1

39      11:31:21  SQL Execute: ORACLE - select SQ_XT_YZMB00_MBID00.nextval from dual where rownum=1

40      11:31:21  SQL Prepare: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000) select 364,mblbid,'ҩ',952,'y','a','1','' from xt_yzmblb where mblbbh='00' and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0))

41      11:31:21  SQL Execute: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000) select 364,mblbid,'ҩ',952,'y','a','1','' from xt_yzmblb where mblbbh='00' and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0))

42      11:31:21  SQL Data In: ORACLE - Rows affected = 1
43      11:31:21  SQL Prepare: ORACLE - BEGIN "SP_ZS_SAVEMB" (PYZID00 => :PYZID00,PMBID00 => :PMBID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END;
44      11:31:21  SQL Data In: ORACLE - Param = 1, Name = PYZID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5253080
45      11:31:21  SQL Data In: ORACLE - Param = 2, Name = PMBID00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 364
46      11:31:21  SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 952.000000
47      11:31:21  SQL Data In: ORACLE - Param = 4, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
48      11:31:21  SQL Data In: ORACLE - Param = 5, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
49      11:31:21  SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
50      11:31:21  SQL Execute: ORACLE - BEGIN "SP_ZS_SAVEMB" (PYZID00 => :PYZID00,PMBID00 => :PMBID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END;
51      11:31:21  SQL Prepare: ORACLE - commit

52      11:31:21  SQL Execute: ORACLE - commit

53      11:31:21  SQL Data In: ORACLE - Rows affected = 0