1       22:11:39  SQL Execute: ORACLE - select * from VW_BQ_JRTSYFYZ a  where BQH000=768 and zyid00 in (793907,794535,793601,793602,793670,791284,795181,793623,794506,794928,794972,794906,793795,795180,793781,794413,794662,795193,794778,794758,793719,793734,794895,791289,794670,794842,793464)  and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00   and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD')   and nvl( ZXDDY0,'0') in ('1','0')) and YPYFMC1='°òë׳åÏ´' order by Ch0000,yzid00,yzmxid 

2       22:11:42  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',768,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '768')
  AND (INSTR (',' || a.jsksbh || ',',',768,') > 0 or a.jsksbh is null)  

3       22:11:42  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',768,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '768')
  AND (INSTR (',' || a.jsksbh || ',',',768,') > 0 or a.jsksbh is null)