1       10:49:44  SQL Execute: ORACLE - select distinct yzid00,xm0000 from VW_BQ_JRKFYK a where BQH000=56 and zyid00 in (605585,605467,605388,605629,605580,605581,605671,605389,605663,605682,604984,605051,605519,605361,605326,605163,605335,605402,605252,605324,605372,604981,605647,605366,605599) 
 and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00  and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')  and nvl( ZXDDY0,'0')='0' )

2       10:49:44  SQL Execute: ORACLE - Select * FROM VW_BQ_JRKFYK a  where BQH000=56 and zyid00 in (605585,605467,605388,605629,605580,605581,605671,605389,605663,605682,604984,605051,605519,605361,605326,605163,605335,605402,605252,605324,605372,604981,605647,605366,605599)  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