1       16:52:42  SQL Prepare: ORACLE - BEGIN "SP_YS_HZDLWH" (PSOID00 => :PSOID00,PDEID00 => :PDEID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END;
2       16:52:42  SQL Data In: ORACLE - Param = 1, Name = PSOID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 600054917751.000000
3       16:52:42  SQL Data In: ORACLE - Param = 2, Name = PDEID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
4       16:52:42  SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 63139.000000
5       16:52:42  SQL Data In: ORACLE - Param = 4, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
6       16:52:42  SQL Data In: ORACLE - Param = 5, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
7       16:52:42  SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
8       16:52:42  SQL Execute: ORACLE - BEGIN "SP_YS_HZDLWH" (PSOID00 => :PSOID00,PDEID00 => :PDEID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END;
9       16:52:42  SQL Prepare: ORACLE - select * from vw_ys_hzbr00 
where jzks00=:1 
 and jzys00=:2 and dlxh00>0 
 and PBLX00 in ('0','2') 
order by HZQSSJ,dlxh00

10      16:52:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60050.000000
11      16:52:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 63139.000000
12      16:52:42  SQL Execute: ORACLE - select * from vw_ys_hzbr00 
where jzks00=? 
 and jzys00=? and dlxh00>0 
 and PBLX00 in ('0','2') 
order by HZQSSJ,dlxh00

13      16:52:42  SQL Prepare: ORACLE - select * from vw_ys_hzbr00
where hzlb00=:1 and jzys00=:2
and jzks00=:3 and nvl(dlxh00,0)=0
and PBLX00='0'
order by hzxh00

14      16:52:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
15      16:52:42  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 63139.000000
16      16:52:42  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60050.000000
17      16:52:42  SQL Execute: ORACLE - select * from vw_ys_hzbr00
where hzlb00=? and jzys00=?
and jzks00=? and nvl(dlxh00,0)=0
and PBLX00='0'
order by hzxh00

18      16:52:43  SQL Prepare: ORACLE - SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=63139 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1'

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