1       16:00:47  SQL Execute: ORACLE - SELECT * FROM (SELECT A.ZLXMID,(SELECT ZLXMJC FROM BM_ZLZD00 WHERE ZLXMID = A.ZLXMID) ZLXMJC FROM VW_TJ_ZLJCDY A WHERE ZLXMID IN (0,17157) AND (XB0000 <> '0') AND XB0000 = '2' ) A GROUP BY ZLXMID, ZLXMJC

2       16:00:47  SQL Execute: ORACLE - select Count(*) from TJ_YJDJH0 b where ghid00='4269179' and zlxmid='17157' and ((b.cxdjh0=0) or (b.cxdjh0 is null)) and (not exists (select 'y' from TJ_YJDJH0 a where a.cxdjh0=b.yjdjh0))

3       16:00:47  SQL Execute: ORACLE - select ZXMID0 from VW_YS_YWMXXM where SJXMID='17157'

4       16:00:47  SQL Execute: ORACLE - select MC0000 bmmc00,BH0000 bmbh00 from TJ_ZHXM00
 where ZLXMID=17157 and INSTR(NVL(TSXX00,' '),'|') = 0 AND YYID00 = '220035' AND SFYX00 = 'Y' 

5       16:00:47  SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
6       16:00:47  SQL Data In: ORACLE - Param = 2, Name = PDTZYJD, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
7       16:00:47  SQL Data In: ORACLE - Param = 3, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 17157.000000
8       16:00:47  SQL Data In: ORACLE - Param = 4, Name = PGHID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 4269179
9       16:00:47  SQL Data In: ORACLE - Param = 5, Name = PZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
10      16:00:47  SQL Data In: ORACLE - Param = 6, Name = PZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
11      16:00:47  SQL Data In: ORACLE - Param = 7, Name = PZXMID0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
12      16:00:47  SQL Data In: ORACLE - Param = 8, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
13      16:00:47  SQL Data In: ORACLE - Param = 9, Name = PTZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
14      16:00:47  SQL Data In: ORACLE - Param = 10, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
15      16:00:47  SQL Data In: ORACLE - Param = 11, Name = PKDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000
16      16:00:47  SQL Data In: ORACLE - Param = 12, Name = PKDKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 510.000000
17      16:00:47  SQL Data In: ORACLE - Param = 13, Name = PYJKSBH, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 498
18      16:00:47  SQL Data In: ORACLE - Param = 14, Name = PSL0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
19      16:00:47  SQL Data In: ORACLE - Param = 15, Name = PBZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
20      16:00:47  SQL Data In: ORACLE - Param = 16, Name = POPFLAG, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
21      16:00:47  SQL Data In: ORACLE - Param = 17, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000
22      16:00:47  SQL Data In: ORACLE - Param = 18, Name = PBBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
23      16:00:47  SQL Data In: ORACLE - Param = 19, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
24      16:00:47  SQL Data In: ORACLE - Param = 20, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
25      16:00:47  SQL Data In: ORACLE - Param = 21, Name = PBH0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
26      16:00:47  SQL Data In: ORACLE - Param = 22, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N
27      16:00:47  SQL Execute: ORACLE - BEGIN "SP_YS_JYSQWH" (PYJDJH0 => :PYJDJH0,PDTZYJD => :PDTZYJD,PZLXMID => :PZLXMID,PGHID00 => :PGHID00,PZDID00 => :PZDID00,PZDMC00 => :PZDMC00,PZXMID0 => :PZXMID0,PMZZYBZ => :PMZZYBZ,PTZBZ00 => :PTZBZ00,PJZBZ00 => :PJZBZ00,PKDYS00 => :PKDYS00,PKDKSBH => :PKDKSBH,PYJKSBH => :PYJKSBH,PSL0000 => :PSL0000,PBZ0000 => :PBZ0000,POPFLAG => :POPFLAG,PCZY000 => :PCZY000,PBBID00 => :PBBID00,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PBH0000 => :PBH0000,PCOMMIT => :PCOMMIT); END;
28      16:00:47  SQL Execute: ORACLE - RollBack

29      16:00:47  SQL Data In: ORACLE - Rows affected = 0