1       16:37:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 279
2       16:37:45  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 733
3       16:37:45  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 4849860     
4       16:37:45  SQL Execute: ORACLE - select id0000 from sf_hzbr00 where jzks00=? and ghys00=? and ghh000=? and hzzt00<>'3'

5       16:37:45  SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2497743.000000
6       16:37:45  SQL Data In: ORACLE - Param = 2, Name = PJZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
7       16:37:45  SQL Data In: ORACLE - Param = 3, Name = PJZKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 279.000000
8       16:37:45  SQL Data In: ORACLE - Param = 4, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
9       16:37:45  SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
10      16:37:45  SQL Data In: ORACLE - Param = 6, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      16:37:45  SQL Data In: ORACLE - Param = 7, Name = PZXBZ00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL
12      16:37:45  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
13      16:37:45  SQL Data In: ORACLE - Param = 9, Name = PGHHZCK, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000
14      16:37:45  SQL Execute: ORACLE - BEGIN "SP_YS_CZJZCL" (PID0000 => :PID0000,PJZYS00 => :PJZYS00,PJZKS00 => :PJZKS00,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,PGHHZCK => :PGHHZCK); END;
15      16:37:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 733
16      16:37:45  SQL Execute: ORACLE -  select YGBH00 from XT_YHZB00 a,XT_ZBQX00 b,xt_xtmk00 c 
 where a.zbdm00=a.zbdm00 and b.mkdm00=c.mkdm00
 and mknbmc='YS_P_BRHZCL' and a.ygbh00=?

17      16:37:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 279
18      16:37:45  SQL Execute: ORACLE - select count(*) vcount from  bm_ckbm00 where bmbh00=? and PBLX00='1' and flag00='4' 

19      16:37:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 279.000000
20      16:37:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
21      16:37:46  SQL Execute: ORACLE - select total,a.hzlb00,hzlbmc from bm_hzlb00 a,
 (select count(*) total,hzlb00 from VW_YS_HZBR00
  where hzlb00>1 and jzks00=? 
    and jzys00=? 
    and PBLX00='1' 
  group by hzlb00 ) b 
where  a.hzlb00=b.hzlb00

22      16:37:46  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

23      16:37:46  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

24      16:37:46  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

25      16:37:46  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

26      16:37:46  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

27      16:37:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 279.000000
28      16:37:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
29      16:37:46  SQL Execute: ORACLE - select * from vw_ys_hzbr00  where jzks00=?  and  jzys00=?  and dlxh00>0 order by KSPBFZ ,jzys00 desc,PBLX00,dlxh00 

30      16:37:46  SQL Data In: ORACLE - Param = 1, Name = PID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2497747.000000
31      16:37:46  SQL Data In: ORACLE - Param = 2, Name = PJZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
32      16:37:46  SQL Data In: ORACLE - Param = 3, Name = PJZKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 279.000000
33      16:37:46  SQL Data In: ORACLE - Param = 4, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000
34      16:37:46  SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
35      16:37:46  SQL Data In: ORACLE - Param = 6, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
36      16:37:46  SQL Data In: ORACLE - Param = 7, Name = PZXBZ00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL
37      16:37:46  SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
38      16:37:46  SQL Data In: ORACLE - Param = 9, Name = PGHHZCK, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 29.000000
39      16:37:46  SQL Execute: ORACLE - BEGIN "SP_YS_CZJZCL" (PID0000 => :PID0000,PJZYS00 => :PJZYS00,PJZKS00 => :PJZKS00,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT,PGHHZCK => :PGHHZCK); END;
40      16:37:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 279.000000
41      16:37:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 733.000000
42      16:37:46  SQL Execute: ORACLE - select * from vw_ys_hzbr00  where jzks00=?  and  jzys00=?  and dlxh00>0 order by KSPBFZ ,jzys00 desc,PBLX00,dlxh00 

43      16:37:51  SQL Execute: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=733 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'