2937 09:27:58 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 2938 09:27:58 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 2939 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2940 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2941 09:27:58 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 2942 09:27:58 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 2943 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2944 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2945 09:27:58 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 2946 09:27:58 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 2947 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2948 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2949 09:27:58 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 2950 09:27:58 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 2951 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2952 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2953 09:27:58 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 2954 09:27:58 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 2955 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2956 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2957 09:27:58 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 2958 09:27:58 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 2959 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2960 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2961 09:27:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2962 09:27:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2963 09:27:58 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 2964 09:27:58 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 2965 09:27:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 2966 09:27:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 2967 09:27:58 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 2968 09:27:58 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 2969 09:27:58 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 2970 09:27:58 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2971 09:27:58 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2972 09:27:58 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2973 09:27:58 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2974 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2975 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2976 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2977 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2978 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2979 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2980 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2981 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2982 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2983 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2984 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2985 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2986 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443271 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2987 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443271 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2988 09:27:59 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2989 09:27:59 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 2990 09:28:31 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 2991 09:28:31 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 2992 09:28:31 SQL Data In: ORACLE - Rows affected = 0 2993 09:28:31 SQL Prepare: ORACLE - Commit 2994 09:28:31 SQL Execute: ORACLE - Commit 2995 09:28:31 SQL Data In: ORACLE - Rows affected = 0 2996 09:28:32 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 2997 09:28:33 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 2998 09:28:35 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 2999 09:28:35 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3000 09:28:36 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3001 09:28:36 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3002 09:28:36 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3003 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3004 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3005 09:28:36 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3006 09:28:36 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3007 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3008 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3009 09:28:36 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3010 09:28:36 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3011 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3012 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3013 09:28:36 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3014 09:28:36 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3015 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3016 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3017 09:28:36 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3018 09:28:36 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3019 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3020 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3021 09:28:36 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3022 09:28:36 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3023 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3024 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3025 09:28:36 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3026 09:28:36 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3027 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3028 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3029 09:28:36 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3030 09:28:36 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3031 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3032 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3033 09:28:36 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3034 09:28:36 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3035 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3036 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3037 09:28:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3038 09:28:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3039 09:28:36 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 3040 09:28:36 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3041 09:28:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3042 09:28:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3043 09:28:36 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3044 09:28:37 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3045 09:28:37 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3046 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3047 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3048 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3049 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3050 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3051 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3052 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3053 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3054 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3055 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3056 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3057 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3058 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3059 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3060 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3061 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3062 09:28:37 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443271 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3063 09:28:37 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443271 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3064 09:28:38 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3065 09:28:38 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3066 09:32:20 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3067 09:32:20 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3068 09:32:20 SQL Data In: ORACLE - Rows affected = 3 3069 09:32:20 SQL Prepare: ORACLE - Commit 3070 09:32:20 SQL Execute: ORACLE - Commit 3071 09:32:20 SQL Data In: ORACLE - Rows affected = 0 3072 09:32:22 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3073 09:32:22 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3074 09:32:24 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3075 09:32:24 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3076 09:32:26 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3077 09:32:26 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3078 09:32:26 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3079 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3080 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3081 09:32:26 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3082 09:32:26 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3083 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3084 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3085 09:32:26 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3086 09:32:26 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3087 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3088 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3089 09:32:26 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3090 09:32:26 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3091 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3092 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3093 09:32:26 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3094 09:32:26 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3095 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3096 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3097 09:32:26 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3098 09:32:26 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3099 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3100 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3101 09:32:26 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3102 09:32:26 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3103 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3104 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3105 09:32:26 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3106 09:32:26 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3107 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3108 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3109 09:32:26 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3110 09:32:26 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3111 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3112 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3113 09:32:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3114 09:32:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3115 09:32:26 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 3116 09:32:26 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3117 09:32:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3118 09:32:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3119 09:32:26 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3120 09:32:26 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3121 09:32:26 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3122 09:32:26 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3123 09:32:26 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3124 09:32:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3125 09:32:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3126 09:32:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3127 09:32:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3128 09:32:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3129 09:32:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3130 09:32:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3131 09:32:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3132 09:32:27 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3133 09:32:27 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3134 09:32:27 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3135 09:32:27 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3136 09:32:27 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3137 09:32:27 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3138 09:32:27 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3139 09:32:27 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3140 09:32:27 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443271 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3141 09:32:27 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443271 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3142 09:32:27 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3143 09:32:27 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3144 10:05:17 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3145 10:05:17 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3146 10:05:17 SQL Data In: ORACLE - Rows affected = 4 3147 10:05:17 SQL Prepare: ORACLE - Commit 3148 10:05:17 SQL Execute: ORACLE - Commit 3149 10:05:17 SQL Data In: ORACLE - Rows affected = 0 3150 10:05:19 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3151 10:05:19 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3152 10:05:21 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3153 10:05:21 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3154 10:05:23 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3155 10:05:23 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3156 10:05:24 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3157 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3158 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3159 10:05:24 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3160 10:05:24 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3161 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3162 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3163 10:05:24 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3164 10:05:24 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3165 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3166 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3167 10:05:24 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3168 10:05:24 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3169 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3170 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3171 10:05:24 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3172 10:05:24 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3173 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3174 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3175 10:05:24 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3176 10:05:24 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3177 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3178 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3179 10:05:24 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3180 10:05:24 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3181 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3182 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3183 10:05:24 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3184 10:05:24 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3185 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3186 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3187 10:05:24 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3188 10:05:24 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3189 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3190 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3191 10:05:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3192 10:05:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3193 10:05:24 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 3194 10:05:24 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3195 10:05:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3196 10:05:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3197 10:05:24 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3198 10:05:24 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3199 10:05:24 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3200 10:05:24 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3201 10:05:24 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3202 10:05:24 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3203 10:05:24 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3204 10:05:24 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3205 10:05:24 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3206 10:05:24 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3207 10:05:24 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3208 10:05:24 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3209 10:05:24 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3210 10:05:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3211 10:05:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3212 10:05:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3213 10:05:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3214 10:05:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3215 10:05:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3216 10:05:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3217 10:05:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3218 10:05:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3219 10:05:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3220 10:09:21 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3221 10:09:21 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3222 10:09:21 SQL Data In: ORACLE - Rows affected = 0 3223 10:09:21 SQL Prepare: ORACLE - Commit 3224 10:09:21 SQL Execute: ORACLE - Commit 3225 10:09:21 SQL Data In: ORACLE - Rows affected = 0 3226 10:09:24 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3227 10:09:24 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3228 10:09:27 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3229 10:09:27 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3230 10:09:28 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3231 10:09:28 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3232 10:09:28 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3233 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3234 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3235 10:09:28 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3236 10:09:28 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3237 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3238 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3239 10:09:28 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3240 10:09:28 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3241 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3242 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3243 10:09:28 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3244 10:09:28 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3245 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3246 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3247 10:09:28 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3248 10:09:28 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3249 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3250 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3251 10:09:28 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3252 10:09:28 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3253 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3254 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3255 10:09:28 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3256 10:09:28 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3257 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3258 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3259 10:09:28 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3260 10:09:28 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3261 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3262 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3263 10:09:28 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3264 10:09:28 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3265 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3266 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3267 10:09:28 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3268 10:09:28 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3269 10:09:28 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 3270 10:09:28 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3271 10:09:28 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3272 10:09:28 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3273 10:09:28 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3274 10:09:28 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3275 10:09:28 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3276 10:09:28 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3277 10:09:28 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3278 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3279 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3280 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3281 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3282 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3283 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3284 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3285 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3286 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3287 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3288 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3289 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3290 10:09:29 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3291 10:09:29 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3292 10:09:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3293 10:09:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3294 10:09:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3295 10:09:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3296 10:11:22 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3297 10:11:22 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3298 10:11:22 SQL Data In: ORACLE - Rows affected = 0 3299 10:11:22 SQL Prepare: ORACLE - Commit 3300 10:11:22 SQL Execute: ORACLE - Commit 3301 10:11:22 SQL Data In: ORACLE - Rows affected = 0 3302 10:11:23 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3303 10:11:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443294.000000 3304 10:11:23 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3305 10:11:23 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19860401) AS NL FROM DUAL 3306 10:11:23 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19860401) AS NL FROM DUAL 3307 10:11:23 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3308 10:11:23 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443294.000000 3309 10:11:23 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3310 10:11:24 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3311 10:11:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443521.000000 3312 10:11:24 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3313 10:11:24 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3314 10:11:24 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3315 10:11:24 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3316 10:11:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443521.000000 3317 10:11:24 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3318 10:11:25 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3319 10:11:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443030.000000 3320 10:11:25 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3321 10:11:25 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19881029) AS NL FROM DUAL 3322 10:11:25 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19881029) AS NL FROM DUAL 3323 10:11:25 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3324 10:11:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443030.000000 3325 10:11:25 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3326 10:11:25 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3327 10:11:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443271.000000 3328 10:11:25 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3329 10:11:25 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3330 10:11:25 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3331 10:11:25 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3332 10:11:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443271.000000 3333 10:11:25 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3334 10:13:33 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3335 10:13:33 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3336 10:13:36 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3337 10:13:36 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3338 10:13:38 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3339 10:13:38 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3340 10:13:38 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3341 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3342 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3343 10:13:38 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3344 10:13:38 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3345 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3346 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3347 10:13:38 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3348 10:13:38 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3349 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3350 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3351 10:13:38 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3352 10:13:38 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3353 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3354 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3355 10:13:38 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3356 10:13:38 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3357 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3358 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3359 10:13:38 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3360 10:13:38 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3361 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3362 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3363 10:13:38 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3364 10:13:38 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3365 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3366 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3367 10:13:38 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3368 10:13:38 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3369 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3370 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3371 10:13:38 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3372 10:13:38 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3373 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3374 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3375 10:13:38 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3376 10:13:38 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3377 10:13:38 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 3378 10:13:38 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3379 10:13:38 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3380 10:13:38 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3381 10:13:38 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3382 10:13:38 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3383 10:13:38 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3384 10:13:38 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3385 10:13:38 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3386 10:13:38 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3387 10:13:38 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3388 10:13:38 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3389 10:13:38 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3390 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3391 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3392 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3393 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3394 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3395 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3396 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3397 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3398 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3399 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3400 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3401 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3402 10:13:39 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3403 10:13:39 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3404 10:14:06 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3405 10:14:06 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3406 10:14:06 SQL Data In: ORACLE - Rows affected = 0 3407 10:14:06 SQL Prepare: ORACLE - Commit 3408 10:14:06 SQL Execute: ORACLE - Commit 3409 10:14:06 SQL Data In: ORACLE - Rows affected = 0 3410 10:14:06 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3411 10:14:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443267.000000 3412 10:14:06 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3413 10:14:06 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19830401) AS NL FROM DUAL 3414 10:14:06 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19830401) AS NL FROM DUAL 3415 10:14:06 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3416 10:14:06 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443267.000000 3417 10:14:06 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3418 10:14:07 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3419 10:14:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443521.000000 3420 10:14:07 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3421 10:14:07 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3422 10:14:07 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3423 10:14:07 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3424 10:14:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443521.000000 3425 10:14:07 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3426 10:14:07 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3427 10:14:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443222.000000 3428 10:14:07 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3429 10:14:07 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19870401) AS NL FROM DUAL 3430 10:14:07 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19870401) AS NL FROM DUAL 3431 10:14:07 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3432 10:14:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443222.000000 3433 10:14:07 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3434 10:14:08 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3435 10:14:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443514.000000 3436 10:14:08 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3437 10:14:08 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3438 10:14:08 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3439 10:14:08 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3440 10:14:08 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443514.000000 3441 10:14:08 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3442 10:14:09 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3443 10:14:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443463.000000 3444 10:14:09 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3445 10:14:09 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19850401) AS NL FROM DUAL 3446 10:14:09 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19850401) AS NL FROM DUAL 3447 10:14:09 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3448 10:14:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443463.000000 3449 10:14:09 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3450 10:14:09 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3451 10:14:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443266.000000 3452 10:14:09 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3453 10:14:09 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19890412) AS NL FROM DUAL 3454 10:14:09 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19890412) AS NL FROM DUAL 3455 10:14:09 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3456 10:14:09 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443266.000000 3457 10:14:09 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3458 10:14:10 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3459 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443030.000000 3460 10:14:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3461 10:14:10 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19881029) AS NL FROM DUAL 3462 10:14:10 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19881029) AS NL FROM DUAL 3463 10:14:10 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3464 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443030.000000 3465 10:14:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3466 10:14:10 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3467 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443444.000000 3468 10:14:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3469 10:14:10 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19840401) AS NL FROM DUAL 3470 10:14:10 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19840401) AS NL FROM DUAL 3471 10:14:10 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3472 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443444.000000 3473 10:14:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3474 10:14:10 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3475 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443521.000000 3476 10:14:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3477 10:14:10 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3478 10:14:10 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19890401) AS NL FROM DUAL 3479 10:14:10 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3480 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443521.000000 3481 10:14:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3482 10:14:10 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3483 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443573.000000 3484 10:14:10 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3485 10:14:10 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19800401) AS NL FROM DUAL 3486 10:14:10 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19800401) AS NL FROM DUAL 3487 10:14:10 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3488 10:14:10 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 443573.000000 3489 10:14:10 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3490 10:14:20 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3491 10:14:20 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3492 10:14:22 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3493 10:14:22 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3494 10:14:24 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3495 10:14:24 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3496 10:14:24 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3497 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3498 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3499 10:14:24 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3500 10:14:24 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3501 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3502 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3503 10:14:24 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3504 10:14:24 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3505 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3506 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3507 10:14:24 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3508 10:14:24 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3509 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3510 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3511 10:14:24 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3512 10:14:24 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3513 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3514 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3515 10:14:24 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3516 10:14:24 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3517 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3518 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3519 10:14:24 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3520 10:14:24 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3521 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3522 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3523 10:14:24 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3524 10:14:24 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3525 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3526 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3527 10:14:24 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3528 10:14:24 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3529 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3530 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3531 10:14:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3532 10:14:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3533 10:14:24 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 3534 10:14:24 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3535 10:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3536 10:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3537 10:14:24 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3538 10:14:24 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3539 10:14:24 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3540 10:14:24 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3541 10:14:24 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3542 10:14:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3543 10:14:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3544 10:14:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3545 10:14:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3546 10:14:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3547 10:14:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3548 10:14:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3549 10:14:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3550 10:14:25 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3551 10:14:25 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3552 10:14:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3553 10:14:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3554 10:14:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3555 10:14:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3556 10:14:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3557 10:14:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3558 10:14:26 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3559 10:14:26 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3560 10:17:47 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3561 10:17:47 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3562 10:17:47 SQL Data In: ORACLE - Rows affected = 0 3563 10:17:47 SQL Prepare: ORACLE - Commit 3564 10:17:47 SQL Execute: ORACLE - Commit 3565 10:17:47 SQL Data In: ORACLE - Rows affected = 0 3566 10:17:49 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3567 10:17:49 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3568 10:17:50 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3569 10:17:50 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3570 10:17:52 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3571 10:17:52 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3572 10:17:52 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3573 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3574 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3575 10:17:52 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3576 10:17:52 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3577 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3578 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3579 10:17:52 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3580 10:17:52 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3581 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3582 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3583 10:17:52 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3584 10:17:52 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3585 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3586 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3587 10:17:52 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3588 10:17:52 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3589 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3590 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3591 10:17:52 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3592 10:17:52 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3593 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3594 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3595 10:17:52 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3596 10:17:52 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3597 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3598 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3599 10:17:52 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3600 10:17:52 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3601 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3602 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3603 10:17:52 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3604 10:17:52 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3605 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3606 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3607 10:17:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3608 10:17:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3609 10:17:52 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 3610 10:17:52 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3611 10:17:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3612 10:17:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3613 10:17:52 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3614 10:17:52 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3615 10:17:52 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3616 10:17:52 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3617 10:17:52 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3618 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3619 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3620 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3621 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3622 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3623 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3624 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3625 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3626 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3627 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3628 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3629 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3630 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3631 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3632 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3633 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3634 10:17:53 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3635 10:17:53 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3636 10:22:47 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3637 10:22:47 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3638 10:22:47 SQL Data In: ORACLE - Rows affected = 0 3639 10:22:47 SQL Prepare: ORACLE - Commit 3640 10:22:47 SQL Execute: ORACLE - Commit 3641 10:22:47 SQL Data In: ORACLE - Rows affected = 0 3642 10:22:49 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3643 10:22:49 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3644 10:22:51 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3645 10:22:51 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3646 10:22:54 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3647 10:22:54 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3648 10:22:54 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3649 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3650 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3651 10:22:54 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3652 10:22:54 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3653 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3654 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3655 10:22:54 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3656 10:22:54 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3657 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3658 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3659 10:22:54 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3660 10:22:54 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3661 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3662 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3663 10:22:54 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3664 10:22:54 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3665 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3666 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3667 10:22:54 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3668 10:22:54 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3669 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3670 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3671 10:22:54 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3672 10:22:54 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3673 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3674 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3675 10:22:54 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3676 10:22:54 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3677 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3678 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3679 10:22:54 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3680 10:22:54 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3681 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3682 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3683 10:22:54 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3684 10:22:54 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3685 10:22:54 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 3686 10:22:54 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3687 10:22:54 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3688 10:22:54 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3689 10:22:54 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3690 10:22:54 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3691 10:22:54 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3692 10:22:54 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3693 10:22:54 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3694 10:22:54 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3695 10:22:54 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3696 10:22:54 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3697 10:22:54 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3698 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3699 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3700 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3701 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3702 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3703 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3704 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3705 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3706 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3707 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3708 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3709 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3710 10:22:55 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3711 10:22:55 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3712 10:22:58 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3713 10:22:58 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3714 10:22:58 SQL Data In: ORACLE - Rows affected = 0 3715 10:22:58 SQL Prepare: ORACLE - Commit 3716 10:22:58 SQL Execute: ORACLE - Commit 3717 10:22:58 SQL Data In: ORACLE - Rows affected = 0 3718 10:23:24 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3719 10:23:24 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3720 10:23:28 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3721 10:23:28 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3722 10:23:29 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3723 10:23:29 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) 3724 10:23:29 SQL Prepare: ORACLE - select * from t_ctltemp where f_sysid=:1 and f_tempid=:2 3725 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3726 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3727 10:23:29 SQL Execute: ORACLE - select * from t_ctltemp where f_sysid=? and f_tempid=? 3728 10:23:29 SQL Prepare: ORACLE - select * from t_CtlTemp1 where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3729 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3730 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3731 10:23:29 SQL Execute: ORACLE - select * from t_CtlTemp1 where f_sysid=? and f_tempid=? order by F_Sequence 3732 10:23:29 SQL Prepare: ORACLE - select * from t_CtlLabel where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3733 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3734 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3735 10:23:29 SQL Execute: ORACLE - select * from t_CtlLabel where f_sysid=? and f_tempid=? order by F_Sequence 3736 10:23:29 SQL Prepare: ORACLE - select * from t_CtlEdit where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3737 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3738 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3739 10:23:29 SQL Execute: ORACLE - select * from t_CtlEdit where f_sysid=? and f_tempid=? order by F_Sequence 3740 10:23:29 SQL Prepare: ORACLE - select * from t_CtlDate where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3741 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3742 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3743 10:23:29 SQL Execute: ORACLE - select * from t_CtlDate where f_sysid=? and f_tempid=? order by F_Sequence 3744 10:23:29 SQL Prepare: ORACLE - select * from t_CtlLine where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3745 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3746 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3747 10:23:29 SQL Execute: ORACLE - select * from t_CtlLine where f_sysid=? and f_tempid=? order by F_Sequence 3748 10:23:29 SQL Prepare: ORACLE - select * from t_CtlGridCol where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3749 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3750 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3751 10:23:29 SQL Execute: ORACLE - select * from t_CtlGridCol where f_sysid=? and f_tempid=? order by F_Sequence 3752 10:23:29 SQL Prepare: ORACLE - select * from t_CtlGrid where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3753 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3754 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3755 10:23:29 SQL Execute: ORACLE - select * from t_CtlGrid where f_sysid=? and f_tempid=? order by F_Sequence 3756 10:23:29 SQL Prepare: 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=:1 and f_tempid=:2 group by f_paramname) b where a.f_sysid=:3 and a.f_tempid=:4 and a.f_sequence=b.f_sequence and a.f_paramid=b.f_paramid order by a.F_Sequence,a.F_ParamID 3757 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3758 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3759 10:23:29 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3760 10:23:29 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3761 10:23:29 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 3762 10:23:29 SQL Prepare: ORACLE - select * from t_SQLlist where f_sysid=:1 and f_tempid=:2 order by F_Sequence 3763 10:23:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 9 3764 10:23:29 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 13.000000 3765 10:23:29 SQL Execute: ORACLE - select * from t_SQLlist where f_sysid=? and f_tempid=? order by F_Sequence 3766 10:23:29 SQL Prepare: ORACLE - select to_char(sysdate,'day')xqj from dual 3767 10:23:29 SQL Execute: ORACLE - select to_char(sysdate,'day')xqj from dual 3768 10:23:30 SQL Prepare: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3769 10:23:30 SQL Execute: ORACLE - select distinct zyid00,zyh000,ch0000,xm0000,YYRQ00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000 3770 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3771 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443427 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3772 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3773 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443059 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3774 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3775 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443462 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3776 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3777 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443558 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3778 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3779 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443437 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3780 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3781 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443573 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3782 10:23:30 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3783 10:23:30 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=441765 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3784 10:23:31 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3785 10:23:31 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443509 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3786 10:23:31 SQL Prepare: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3787 10:23:31 SQL Execute: ORACLE - select a.* from VW_BQ_JRSYYZ a where zyid00=443403 and BQH000=56 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by yzid00,yzmxid 3788 10:23:32 SQL Prepare: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3789 10:23:32 SQL Execute: ORACLE - update BQ_YZCFMX set ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a where BQH000=56 and zyid00 in (443427,443059,443787,443462,443558,443437,443789,443464,443569,443328,443212,442818,442404,443417,443294,443267,443409,443419,443573,442909,443521,441765,443386,443444,443509,443222,443030,443538,443514,443404,443266,443429,443271,443403,443405,443463,443401,443522,443582,443560,443769) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='0' 3790 10:23:32 SQL Data In: ORACLE - Rows affected = 0 3791 10:23:32 SQL Prepare: ORACLE - Commit 3792 10:23:32 SQL Execute: ORACLE - Commit 3793 10:23:32 SQL Data In: ORACLE - Rows affected = 0 3794 10:23:34 Log started for: Untitled Application 3795 10:23:42 Log started for: Sickberth 3796 10:23:42 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20120417','10:23:39','scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3797 10:23:42 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20120417','10:23:39','scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3798 10:23:42 SQL Data In: ORACLE - Rows affected = 1 3799 10:23:42 SQL Prepare: ORACLE - Commit 3800 10:23:42 SQL Execute: ORACLE - Commit 3801 10:23:42 SQL Data In: ORACLE - Rows affected = 0 3802 10:23:42 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3803 10:23:42 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 3804 10:23:42 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3805 10:23:42 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 3806 10:23:42 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3807 10:23:42 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3808 10:23:42 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20120417','10:23:39','sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3809 10:23:42 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','9',trim(PROGRAM)||'+'||'病区护理系统',SID,serial# ,'20120417','10:23:39','sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3810 10:23:42 SQL Data In: ORACLE - Rows affected = 1 3811 10:23:42 SQL Prepare: ORACLE - Commit 3812 10:23:42 SQL Execute: ORACLE - Commit 3813 10:23:42 SQL Data In: ORACLE - Rows affected = 0 3814 10:23:42 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 3815 10:23:42 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='9' 3816 10:23:42 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3817 10:23:42 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 3818 10:23:42 SQL Prepare: ORACLE - Select SYSDATE from Dual 3819 10:23:42 SQL Execute: ORACLE - Select SYSDATE from Dual 3820 10:23:42 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 3821 10:23:42 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 3822 10:23:42 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3823 10:23:42 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 3824 10:23:42 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 3825 10:23:42 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='9' 3826 10:23:42 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3827 10:23:42 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3828 10:23:42 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 3829 10:23:42 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 3830 10:23:42 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 3831 10:23:42 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('9') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='9' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by BH0000 3832 10:23:44 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 3833 10:23:44 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '9' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) 3834 10:23:44 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3835 10:23:44 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 3836 10:23:44 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3837 10:23:44 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 3838 10:23:44 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3839 10:23:44 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 3840 10:23:44 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3841 10:23:44 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 3842 10:23:44 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3843 10:23:44 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 3844 10:23:44 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 3845 10:23:44 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 3846 10:23:44 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3004078,476,'wlzx-3','9',nvl('38217809',' '),'192.168.12.120#210:1260@SickBerth.exe+病区护理系统',62) 3847 10:23:44 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3004078,476,'wlzx-3','9',nvl('38217809',' '),'192.168.12.120#210:1260@SickBerth.exe+病区护理系统',62) 3848 10:23:44 SQL Data In: ORACLE - Rows affected = 1 3849 10:23:44 SQL Prepare: ORACLE - Commit 3850 10:23:44 SQL Execute: ORACLE - Commit 3851 10:23:44 SQL Data In: ORACLE - Rows affected = 0 3852 10:23:44 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 62 3853 10:23:44 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 62 3854 10:23:44 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 3855 10:23:44 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222137' 3856 10:23:44 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3857 10:23:44 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 3858 10:23:44 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 3859 10:23:44 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 3860 10:23:44 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 62 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3861 10:23:44 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 62 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 3862 10:23:44 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3863 10:23:44 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 3864 10:23:44 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20120417' 3865 10:23:44 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='9') and YXQ000>='20120417' 3866 10:23:44 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3867 10:23:44 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 3868 10:23:44 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3869 10:23:44 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 3870 10:23:44 SQL Prepare: ORACLE - select sysdate from dual 3871 10:23:44 SQL Execute: ORACLE - select sysdate from dual 3872 10:23:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='9' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='9' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 3873 10:23:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='9' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='9' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 3874 10:23:44 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 3875 10:23:44 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '9$%' and A.XTDM00='9' and trim(A.MKDM00)='9$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 3876 10:23:44 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 3877 10:23:44 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 3878 10:23:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3879 10:23:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 3880 10:23:44 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 3881 10:23:44 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=476)))) 3882 10:23:44 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 3883 10:23:44 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 3884 10:23:44 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 3885 10:23:44 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_BQ_%' AND STATUS<>'VALID' 3886 10:23:44 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 3887 10:23:44 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_BQ_%' 3888 10:23:44 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 3889 10:23:44 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%' 3890 10:23:44 SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 3891 10:23:44 SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00='BQ_MRWHTQTS' 3892 10:23:44 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_ZQCYJH') 3893 10:23:44 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('YJ_BQZXMZXM','BQ_LRCZPSYCSPSDZ','BQ_ZQCYJH') 3894 10:23:44 SQL Prepare: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_TSYPYZDY_ZDY') 3895 10:23:44 SQL Execute: ORACLE - SELECT VALUE0,NAME00 FROM XT_XTCS00 WHERE NAME00 in('BQ_CYDJS0','BQ_LSCFSFLRYP','BQ_GCSFTZXM','BQ_SYKDYGS','BQ_RQDSFZDYDX','BQ_SYKDYCD','BQ_XZYZDYZDYID','BQ_YBBRSFKCZ','BQ_SFDJG','BQ_SYKSFCSNO','BQ_YPSFTZ','BQ_YZHDQR','ZS_SFXSBB','XT_QDXXZHYE','BQ_NT5','BQ_RQDCDZ','BQ_DY_JRZS00_TITLE','BQ_YZZX_JYDZJSF','BQ_YZLLTYQY','BQ_ZQSFBXJS','BQ_ZDYDY_SYK','BQ_LSCFWH_TF','BQ_ZDYDY_KFYK','BQ_ZDYDY_YZZXD','ZY_RQDSFABRFYDY','BQ_ZLDDY_GS','BQ_ZDYDY_SYK_LSYZ','BQ_ZDYDY_SYLXSK','BQ_ZDYDY_YZZXD_ZSL','BQ_ZDYDY_YZZXD_SYL','ZS_SSSXSQDCSYZ','BQ_ZDYDY_YZZXD_YSL','ZS_YZDYGS','ZS_YZSFTD','BQ_CGJZSFXZJSXM','BQ_LSYZZXD_LRSJ','BQ_LYCX_RQXZ','XT_SFXSBM','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','BQ_ZFNRWZTQ','BQ_YJZYPSFYXTY','BQ_SRCX_BQBR','BQ_YZSFTYGYP','BQ_YZLLKZYS_ZYYS','BQ_XMSFZJTF','BQ_ZDYDY_ZLK','JY_TXMFS','BQ_YBCYSFBXLRCYZD','BQ_ZDYDY_JYJCZL','BQ_ZDYDY_HLBLPIOJLD','BQ_ZDYDY_HLXXJLD','BQ_KHLGZLTJZDYID','BQ_LS_CD','BQ_YYGXH','YK_RCKTJDSFKZSRHS','YK_RCKTJDDYHS','BQ_YBBRTQTS_ZFBL','BQ_HLGZLTJSXZDY','BQ_YPMCLB','BQ_CGXMWH_LRCLXSFJ','BQ_ZYSFRQD','ZY_RQDGSCS','ZY_RQDSFXSZFBL','ZY_RQDFPXM_SFDY','ZY_QDSFDYZFJE','ZY_RQDMX0_ZFHB','ZY_SFPTCYHZRQDGS','ZY_RQDZZ0_SETUP0','XT_QDXXZHYE_LX','ZY_RQDSJD','BQ_JRYZZDYID','ZY_BDFPQDSFHBXTXM','ZY_RQDSFMYDYYTYW','ZY_ZYRDSFXSJMJE','ZY_SFXSYJSBZ','SF_PageWidth','SF_PageHeigh','SF_PageDirect','ZY_RQDBRPXFS','ZY_RQDZFBLSFXSYBBL','ZY_SFXSXJ','ZY_RQDZFBLSFTXNJYY','ZY_PRINTSCALE','BQ_ZYSFRQD','BQ_SSSQD_SQYSMR','BQ_TMDYJ','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','XT_TFXYSHBZ','BQ_ZDYDY_YZZXD_ZJL','BQ_YJ_BQXMCXSQ','BQ_TFQRFBBQZXSFKETF','YJ_XMSQ_KSYS','YJ_XSSYYXGHGXZ','YJ_XMZJMRKSYS','YJ_XMZJYSWSSKS','YJ_SYBLHCZ','YJ_RHXMLYKSZX','YJ_XMZXSLMRYC','YJ_XMZXDKHQX','B_YJJCD_DYSF00','YJ_TMSFDY','YJ_TMTSY','BQ_TMPrintSet','YJ_ZDYDY_SYK','YJ_XSKDYGS','YJ_ZXDDKDYKS','YJ_ZDDYJYDKS','YS_KDSCTXM','YJ_XSZXM','YJ_XMYXTS','YS_YSXMSQD','YJ_ZDYDY_ZXD','BQ_KYEZDSXJGSJ','BQ_SFYXJC','BQ_HSSFYSKYPYZ','BQ_YBHLJLDGS','BQ_YZZXDDYXS','BQ_WPHYPSLSFYKSWSQDW','BQ_YZZXDKSSJ','BQ_YZZXDJSSJ','BQ_ZQYZTJSFTS','BQ_YZCFCXSFHZ','BQ_QYCWCXSFXSQTCW','BQ_YZZXDZDYID','BQ_YZZXSCSSSQDDSFHB','BQ_YZCDXSFY','BQ_ZDLBSFXZXG','BQ_HZYZXMST','BQ_QQZXWSFTSWHDYZBR','BQ_ZDYDY_SYK_LS','BQ_SSRQSFZDMR','BQ_SSSQSFMRSSYS','BQ_TFQRCFYZSFXS','ZS_YBSFXSWQZFYPBL','BQ_YZLRSFMRDQYZ','BQ_BZSFJCSR','BQ_SFSYDTYYSCXT','BQ_TZYZSFXYHD','BQ_SSSQD_SFFS','BQ_BRXZYZSFXSHS','BQ_JZBRSFYXQF','BQ_SXSQYZSFHDTZ','BQ_SYKDYSFASJPX','WZ_SFQYEJKF','BQ_CYDYCFDDYGS','BQ_TSYPYZDY_ZDY') 3896 10:23:45 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 476 3897 10:23:45 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','BQ_TMPrinterM','BQ_QTPrinterM','BQ_TMPrintSet_N','BQ_SEL_BBTM','SF_USER_PageWidth','SF_USER_PageHeigh','SF_USER_PageDirect','ZYSF_sysRQDSheet') and YGBH00 = 476 3898 10:23:45 SQL Prepare: ORACLE - select sysdate nowtime from dual 3899 10:23:45 SQL Execute: ORACLE - select sysdate nowtime from dual 3900 10:23:45 SQL Prepare: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 3901 10:23:45 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='BQ_ZCYYZLLXS' 3902 10:23:45 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 3903 10:23:45 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00='BQ_SRF_ORDER' 3904 10:23:45 SQL Prepare: ORACLE - select * from VW_BQ_YZLB00 3905 10:23:45 SQL Execute: ORACLE - select * from VW_BQ_YZLB00 3906 10:23:45 SQL Prepare: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 3907 10:23:45 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 3908 10:23:45 SQL Prepare: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=476 3909 10:23:45 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=476 3910 10:23:45 SQL Prepare: ORACLE - select ZZXKH0,ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00) XZYZ00 from VW_BQ_BRZYXX A where DQBQ00 = :1 order by RYCWH0 3911 10:23:45 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 62.000000 3912 10:23:45 SQL Execute: ORACLE - select ZZXKH0,ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00) XZYZ00 from VW_BQ_BRZYXX A where DQBQ00 = ? order by RYCWH0 3913 10:23:46 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 3914 10:23:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 439958.000000 3915 10:23:46 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 3916 10:23:46 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19440301) AS NL FROM DUAL 3917 10:23:46 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19440301) AS NL FROM DUAL 3918 10:23:46 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3919 10:23:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 439958.000000 3920 10:23:46 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYRQ00,PXSJ00,YZID00,YZMXID 3921 10:23:48 SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3922 10:23:48 SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00 3923 10:23:50 SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3924 10:23:50 SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10' 3925 10:23:53 SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3926 10:23:53 SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3927 10:24:25 Log started for: SQL Navigator for Oracle 3928 10:24:27 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 3929 10:24:27 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 3930 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3931 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3932 10:24:29 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 3933 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3934 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3935 10:24:29 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 3936 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3937 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3938 10:24:29 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 3939 10:24:29 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 3940 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3941 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3942 10:24:29 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 3943 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3944 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3945 10:24:29 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 3946 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3947 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3948 10:24:29 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 3949 10:24:29 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3950 10:24:29 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3951 10:24:29 SQL Execute: select text,line from sys.dba_source where owner='SD_HOSPITAL' and name='SP_SB_DAXX00_XGJJBB' and type='PROCEDURE' order by line 3952 10:24:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3953 10:24:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3954 10:24:30 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 3955 10:24:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3956 10:24:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3957 10:24:30 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 3958 10:24:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3959 10:24:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3960 10:24:30 SQL Execute: select v.text_length,v.text,v.type_text_length,v.type_text,v.oid_text_length,v.oid_text,v.view_type_owner,v.view_type,c.comments from user_tab_comments c,user_views v where v.view_name=:object_name and c.table_name=v.view_name and c.table_type='VIEW' 3961 10:24:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3962 10:24:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3963 10:24:30 SQL Execute: select constraint_name,decode(constraint_type,'C',1,'P',2,'U',3,'R',4,'V',5,'O',6,0) constraint_type,table_name,search_condition,r_owner,r_constraint_name,decode(delete_rule,'CASCADE',1,'NO ACTION',2,'SET NULL',3,0) delete_rule,decode(status,'ENABLED','Y','N') enabled,decode(deferrable,'DEFERRABLE','Y','N') deferrable,decode(deferred,'DEFERRED','Y','N') deferred,decode(validated,'VALIDATED','Y','N') validated,decode(generated,'GENERATED NAME','Y','N') generated,decode(bad,'BAD','Y','N') bad,last_change,decode(rely,'RELY','Y','N') rely from sys.dba_constraints where owner=:schema and table_name=:table_name 3964 10:24:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3965 10:24:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3966 10:24:30 SQL Execute: select a.column_name,decode(a.data_type,'VARCHAR2',0,'NUMBER',1,'FLOAT',2,'LONG',3,'VARCHAR',4,'DATE',5,'RAW',6,'LONG RAW',7,'ROWID',8,'CHAR',9,'MLSLABEL',11,'NVARCHAR2',12,'NCHAR VARYING',13,'NCHAR',14,'NCLOB',16,'CLOB',17,'BLOB',18,'BFILE',19,'CFILE',20,'UROWID',30,'BINARY_FLOAT',32,'BINARY_DOUBLE',33,decode(a.data_type_mod,'REF',15,decode(instr(a.data_type,'INTERVAL DAY'),1,29,decode(instr(a.data_type,'INTERVAL YEAR'),1,28,decode(instr(a.data_type,'TIMESTAMP'),1,decode(instr(a.data_type,'TIME ZONE'),0,26,decode(instr(a.data_type,'LOCAL TIME ZONE'),0,27,31)),decode(instr(a.data_type,'TIME'),1,decode(instr(a.data_type,'TIME ZONE'),0,24,25),decode(a.data_type_owner,null,32,21))))))) data_type,decode(a.data_type_owner,null,decode(instr(a.data_type,'INTERVAL'),1,a.data_type,decode(instr(a.data_type,'TIME'),1,a.data_type,'')),a.data_type) type_name,a.data_type_owner type_owner,a.data_length,a.data_precision,a.data_scale,a.nullable,a.column_id,a.data_default,a.num_distinct,cast(a.low_value as varchar2(500)) low_value, cast(a.high_value as varchar2(500)) high_value,a.char_length,USER object_owner,a.table_name object_name,b.ENCRYPTION_ALG, b.SALT from user_tab_columns a, user_encrypted_columns b where a.table_name=:object_name and b.table_name(+)=a.table_name and b.column_name(+)=a.column_name order by a.column_id 3967 10:24:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3968 10:24:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3969 10:24:30 SQL Execute: select column_name,comments from user_col_comments where table_name=:object_name 3970 10:24:33 SQL Execute: - select VW_BQ_JRSYYZ.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3971 10:24:37 SQL Prepare: select VW_BQ_JRSYYZ.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3972 10:24:37 SQL Prepare: select * from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3973 10:24:38 SQL Execute: select * from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3974 10:25:15 SQL Prepare: select VW_BQ_JRSYYZ.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3975 10:25:15 SQL Prepare: select VW_BQ_JRSYYZ.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3976 10:25:20 SQL Prepare: select VW_BQ_JRSYYZ.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3977 10:25:46 SQL Execute: select owner,object_id,created,nvl(last_ddl_time,created) last_ddl_time,decode(status,'VALID',0,'INVALID',1,2) status,object_name,object_name,decode(object_type,'TABLE',1,'VIEW',2,'INDEX',3,'SNAPSHOT LOG',4,'PROCEDURE',5,'FUNCTION',6,'PACKAGE',7,'PACKAGE BODY',8,'TRIGGER',9,'SEQUENCE',10,'SYNONYM',11,'CLUSTER',12,'DATABASE LINK',13,'SNAPSHOT',14,'MATERIALIZED VIEW',14,'TYPE',15,'TYPE BODY',16,'LIBRARY',19,'DIRECTORY',20,'QUEUE',21,'JAVA SOURCE',22,'JAVA CLASS',23,'JAVA RESOURCE',24,'INDEXTYPE',25,'OPERATOR',26,'DIMENSION',31,'CONTEXT',32,'RESOURCE PLAN',33,'CONSUMER GROUP',34,0) object_type from (select owner,object_id,created,last_ddl_time,status,object_name,object_type from sys.all_objects where upper(owner) like 'SD_HOSPITAL' and upper(object_name) like 'VW_BQ_JRSYYZ' and object_type in ('TABLE','VIEW','INDEX','PROCEDURE','FUNCTION','PACKAGE','TRIGGER','SEQUENCE','SYNONYM','CLUSTER','DATABASE LINK','TYPE','LIBRARY','DIRECTORY','QUEUE','JAVA SOURCE','JAVA CLASS','JAVA RESOURCE','INDEXTYPE','OPERATOR','DIMENSION','CONTEXT','RESOURCE PLAN','CONSUMER GROUP') and object_name not in (select OBJECT_NAME from USER_RECYCLEBIN) UNION ALL select owner,-1 object_id,created,to_date(NULL) last_ddl_time,NULL status,db_link object_name,'DATABASE LINK' object_type from sys.all_db_links where upper(owner) like 'SD_HOSPITAL' and upper(db_link) like 'VW_BQ_JRSYYZ') 3978 10:25:47 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 3979 10:25:47 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 3980 10:25:47 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 3981 10:25:54 SQL Prepare: select a.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid 3982 10:25:55 SQL Execute: select a.* , ROWID from VW_BQ_JRSYYZ a where BQH000=62 and zyid00 in (443799,441582,442817,443311,442764,439958,443365,441210,442165,443420,443276,443167,443055,442503,443556,441507,441939,439134,443369,443523,443803,443537,443778,441413,442867,441925,443364,443017,441936,442261,442001,443217,441102,443368,438486,443223,442259,441981,442000,442298,440607,442504,442013,443400,443797,443563,443564,443657,443529,443506,443465,443813,443515,443656,443578,443575,443574,443466,443412,443764,443306,441114,443407,442199,443392,443391,441989,442763) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0') in ('1','0')) order by Ch0000,yzid00,yzmxid