1       15:51:16  SQL Execute: ORACLE - select distinct CFLSH0,ch0000,xm0000,nl0000,qssj00,brblh0 from VW_YJ_SYKP00_CF  where CFLSH0 in ('3512364')

2       15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
3       15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
4       15:51:16  SQL Execute: ORACLE - select * from t_ctltemp    where f_sysid=? and f_tempid=?

5       15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
6       15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
7       15:51:16  SQL Execute: ORACLE - select * from t_CtlTemp1   where f_sysid=? and f_tempid=? order by F_Sequence

8       15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
9       15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
10      15:51:16  SQL Execute: ORACLE - select * from t_CtlLabel   where f_sysid=? and f_tempid=? order by F_Sequence

11      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
12      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
13      15:51:16  SQL Execute: ORACLE - select * from t_CtlEdit    where f_sysid=? and f_tempid=? order by F_Sequence

14      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
15      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
16      15:51:16  SQL Execute: ORACLE - select * from t_CtlDate    where f_sysid=? and f_tempid=? order by F_Sequence

17      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
18      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
19      15:51:16  SQL Execute: ORACLE - select * from t_CtlLine    where f_sysid=? and f_tempid=? order by F_Sequence

20      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
21      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
22      15:51:16  SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence

23      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
24      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
25      15:51:16  SQL Execute: ORACLE - select * from t_CtlGrid    where f_sysid=? and f_tempid=? order by F_Sequence

26      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
27      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
28      15:51:16  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
29      15:51:16  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
30      15:51:16  SQL Execute: ORACLE - select a.* from t_sqlparams a ,(select f_paramname,min(f_sequence) f_sequence,min(f_paramid) f_paramid from t_sqlparams where f_sysid=? and f_tempid=? group by f_paramname) b where a.f_sysid=? and a.f_tempid=? and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID

31      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7
32      15:51:16  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000
33      15:51:16  SQL Execute: ORACLE - select * from t_SQLlist    where f_sysid=? and f_tempid=? order by F_Sequence

34      15:51:16  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 3512364
35      15:51:16  SQL Execute: ORACLE - select t2.DXSYSL,t2.CFID00,t2.ZB0001 from VW_YJ_SYKP00_CF t2 WHERE t2.CFLSH0=?

36      15:51:16  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (9889526,'1')

37      15:51:16  SQL Data In: ORACLE - Rows affected = 1
38      15:51:16  SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (9889527,'1')

39      15:51:16  SQL Data In: ORACLE - Rows affected = 1
40      15:51:16  SQL Execute: ORACLE - select t2.zb0000,t2.CSL000,t2.JLDW00,t2.YPMC00||' '||DECode(Sign(t2.CSL000-1),-1,'0','') ||t2.csl000||t2.JLDW00 YPMC00,Substrb(t2.YYZF00,1,10)yyzf00,(SELECT YPYFMC FROM BM_YPYF00 P WHERE t2.YFID00=P.YFID00 AND ROWNUM=1) YPYF00 from YS_CFMX00 t2,YF_MZCFMX t3,YJ_ZLXMID_TMP t1 WHERE t2.cfid00=t1.ZLXMID(+) and t2.CFLSH0='3512364' AND t2.cfid00=t3.cfid00 and t3.cxbz00='Z' order by t2.zb0000,t1.zb0000,t1.ZLXMID