1 15:54:42 SQL Execute: ORACLE - SELECT BMBH00,BMMC00 FROM BM_BMBM00 WHERE BMXZ00 in ('0','1') AND FLAG00='1' 2 15:54:42 SQL Execute: ORACLE - SELECT YSLB00,YSLBMC FROM BM_YSLB00 3 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11165 4 15:54:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 11165 5 15:54:42 SQL Execute: ORACLE - select YSZID0,YSZMC0,SSKSBH,SSKSMC,XSXH00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,YSZZT0,MZZYBZ from zs_ysz000 where (SSKSBH=? or '0'=?) 6 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 7 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 8 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 9 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 10 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 11 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 12 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 13 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 14 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 15 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 16 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 17 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 18 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 19 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 20 15:54:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 21 15:54:42 SQL Execute: ORACLE - select ZMXID0,(select XKH000 FROM BM_YGBM00 WHERE YGBH00=a.YSBH00) XKH000,YSZID0,YSBH00,YSXM00,YSLB00,KSRQ00,KSSJ00,JSRQ00,JSSJ00,XSXH00,YSZT00 FROM zs_yszmx0 a where yszid0=? and TO_CHAR(SYSDATE,'YYYYMMDDHH24:MI:SS') BETWEEN KSRQ00||KSSJ00 AND JSRQ00||JSSJ00 22 15:54:43 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '6')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',12,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1 AND b.JSKSBH = '12') AND (INSTR (',' || a.jsksbh || ',',',12,') > 0 or a.jsksbh is null)