1       15:15:49  SQL Prepare: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRSYYZ a where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667) 
 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00  and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')  and nvl( ZXDDY0,'0')='0' )

2       15:15:49  SQL Execute: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRSYYZ a where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667) 
 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00  and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')  and nvl( ZXDDY0,'0')='0' )

3       15:15:50  SQL Prepare: ORACLE - update BQ_YZCFMX set  ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a  where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0')='0'

4       15:15:50  SQL Execute: ORACLE - update BQ_YZCFMX set  ZXDDY0='1' where YZID00 in (select YZID00 from VW_BQ_JRSYYZ a  where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667) ) and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0')='0'

5       15:15:50  SQL Data In: ORACLE - Rows affected = 0
6       15:15:50  SQL Prepare: ORACLE - Commit

7       15:15:50  SQL Execute: ORACLE - Commit

8       15:15:50  SQL Data In: ORACLE - Rows affected = 0
9       15:15:54  SQL Prepare: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00

10      15:15:54  SQL Execute: ORACLE - SELECT DM0000, MC0000 FROM BQ_ZXDLB0 WHERE SFYX00='1' ORDER BY PLXH00

11      15:15:57  SQL Prepare: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10'

12      15:15:57  SQL Execute: ORACLE - select yfid00,MC0000,SFFPC0,DYFS00,SQLTJ0 from BQ_ZXDLB0 where DM0000='10'

13      15:15:57  SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a  where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0')='0') order by Ch0000,yzid00,yzmxid

14      15:15:57  SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a  where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0')='0') order by Ch0000,yzid00,yzmxid

15      15:16:00  SQL Prepare: ORACLE - Commit

16      15:16:00  SQL Execute: ORACLE - Commit

17      15:16:00  SQL Data In: ORACLE - Rows affected = 0
18      15:16:01  SQL Prepare: ORACLE - select * from VW_BQ_JRSYYZ a  where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667)  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

19      15:16:01  SQL Execute: ORACLE - select * from VW_BQ_JRSYYZ a  where BQH000=57 and zyid00 in (443570,443265,441275,443659,443377,443470,441960,443221,443309,442756,442806,443517,443219,443579,443041,443324,443362,443186,443658,443434,443322,443545,443539,441923,442808,442707,442024,443177,443513,443614,443667)  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