1 11:00:54 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||',', ',388,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2360,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2360 AND b.JSKSBH = '388') AND (INSTR (',' || a.jsksbh || ',',',388,') > 0 or a.jsksbh is null) 2 11:00:58 SQL Execute: ORACLE - select * from VW_BQ_JRZSYZ a where BQH000=388 and zyid00 in (804969,804990,804939,804948,804976,804877,804999,805015,804835,804818,804879,804566,804997,805024,804912,804888,804914,804943,804940,804992,804886,804847,804884,804933,804498) and exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and ZXRQ00 = TO_CHAR(SYSDATE,'YYYYMMDD') and nvl( ZXDDY0,'0')='1') and (YFLBID=1 or YFID00 in (0)) order by Ch0000,yzid00,yzmxid 3 11:22:24 Log started for: 库存物资管理子系统