1       09:08:26  SQL Execute: ORACLE - select 'Ò×ÁªÖÚss' ZBRXM0,a.* from VW_BQ_JRZLYZ a  where BQH000=484 and zyid00 in (792085,791990,792595,791302,791252,791251,791305,791322,791366,791304,792158,792468,792227,792621,791236,791248,792335,791308,791231,792416,792506,792221,792414,792561,792537,792534,792535,791295,791151,792349,792640,792533,791482,791301,792652,792633,792489,792352,792339,791977,791427,792563,792605,792323,792529,792558,792365,790810,791331,791255,791246,792618,792609,790717)  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

2       09:08:27  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||',', ',484,')> 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 = '484')
  AND (INSTR (',' || a.jsksbh || ',',',484,') > 0 or a.jsksbh is null)