1 14:38:41 SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=1038 or (JSKSBH=41 and JSFBH0=0)) and XXCSFX=0 and SFLL00=0 2 14:38:41 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=41 and zyid00 in (597503) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') 3 14:38:41 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (16552300,'165522991') 4 14:38:41 SQL Data In: ORACLE - Rows affected = 1 5 14:38:41 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (16552302,'165523011') 6 14:38:41 SQL Data In: ORACLE - Rows affected = 1 7 14:38:41 SQL Execute: ORACLE - insert into YJ_ZLXMID_TMP(ZLXMID,ZB0000) VALUES (16552306,'165523051') 8 14:38:41 SQL Data In: ORACLE - Rows affected = 1 9 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 10 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 11 14:38:41 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 12 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 13 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 14 14:38:41 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 15 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 16 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 17 14:38:41 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 18 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 19 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 20 14:38:41 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 21 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 22 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 23 14:38:41 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 24 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 25 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 26 14:38:41 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 27 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 28 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 29 14:38:41 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 30 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 31 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 32 14:38:41 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 33 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 34 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 35 14:38:41 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 36 14:38:41 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 37 14:38:41 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 38 14:38:41 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 39 14:38:41 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14.000000 40 14:38:41 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 41 14:38:41 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,SF_BQ_CSRQTONL(csrq00) as nl0000,YYRQ00,CLBZ00 from VW_BQ_JRSYYZ a where BQH000=41 and zyid00 in (597503) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') order by CH0000 42 14:38:41 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=41 and zyid00 in (597503) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=597503 and BQH000=41 and CLBZ00='0' order by a.yzid00,t1.zb0000,t1.ZLXMID 43 14:38:41 SQL Execute: ORACLE - select t1.zb0000,a.*,instr(yznr01,pcmc00),decode(instr(yznr01,pcmc00),0,yznr01,RTRIM(substr(yznr01,1,instr(yznr01,pcmc00)-1))||LTRIM(substr(yznr01,instr(yznr01,pcmc00)+length(pcmc00),length(yznr01)))) as YPYF00 from VW_BQ_JRSYYZ a ,YJ_ZLXMID_TMP t1 where BQH000=41 and zyid00 in (597503) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( XSKDY0,'0')='0') and a.YZMXID=t1.ZLXMID(+) and zyid00=597503 and BQH000=41 and CLBZ00='1' order by a.yzid00,t1.zb0000,t1.ZLXMID