1 14:49:57 SQL Prepare: 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 2 14:49:57 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 3 14:49:58 SQL Prepare: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' and B.CZBZ00<>'2' ORDER BY B.BH0000 4 14:49:58 SQL Execute: ORACLE - SELECT F.FYZT00 FROM BM_BQFYZT F,BM_BMBM00 B WHERE F.BQBMBH=B.BMBH00 AND F.YFBMBH=45 AND B.BMXZ00='9' AND B.FLAG00='1' and B.CZBZ00<>'2' ORDER BY B.BH0000 5 14:49:58 SQL Prepare: ORACLE - SELECT 1 FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=61 AND QLZT00 IN ('0','1')AND THBZ00='0' AND HZBZ00='1' 6 14:49:58 SQL Execute: ORACLE - SELECT 1 FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=61 AND QLZT00 IN ('0','1')AND THBZ00='0' AND HZBZ00='1' 7 14:49:58 SQL Prepare: ORACLE - SELECT 'X' FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=61 AND QLZT00 IN ('0','1') AND THBZ00='0' AND HZBZ00='0' 8 14:49:58 SQL Execute: ORACLE - SELECT 'X' FROM YF_YZYPSQ WHERE YFBMBH=45 AND BQBMBH=61 AND QLZT00 IN ('0','1') AND THBZ00='0' AND HZBZ00='0' 9 14:49:59 SQL Prepare: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2' WHERE YFBMBH=45 AND BQBMBH=61 10 14:49:59 SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2' WHERE YFBMBH=45 AND BQBMBH=61 11 14:49:59 SQL Data In: ORACLE - Rows affected = 1 12 14:49:59 SQL Prepare: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1' WHERE YFBMBH=45 AND BQBMBH=61 AND QLZT00 IN ('0','1') AND FYBZ00='0' AND THBZ00='0' AND CXBZ00='Z' 13 14:49:59 SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1' WHERE YFBMBH=45 AND BQBMBH=61 AND QLZT00 IN ('0','1') AND FYBZ00='0' AND THBZ00='0' AND CXBZ00='Z' 14 14:49:59 SQL Data In: ORACLE - Rows affected = 49 15 14:49:59 SQL Prepare: ORACLE - COMMIT 16 14:49:59 SQL Execute: ORACLE - COMMIT 17 14:49:59 SQL Data In: ORACLE - Rows affected = 0 18 14:49:59 SQL Prepare: ORACLE - UPDATE YF_YZYPSQ a SET a.qlzt00='3' WHERE a.YFBMBH=45 AND a.BQBMBH=61 AND a.QLZT00 IN ('0') AND a.CXBZ00='Z' and exists ( select 1 from zy_brxxb0 where a.zyid00=zyid00 and ((nvl(cyrq00,'20991231')<>'20991231') and (brzt00 in ('4','5')))) and not exists(select 1 from bq_ypyzmx where a.yzmxid=yzmxid and trim(yzcllb)='出院带药' ) 19 14:49:59 SQL Execute: ORACLE - UPDATE YF_YZYPSQ a SET a.qlzt00='3' WHERE a.YFBMBH=45 AND a.BQBMBH=61 AND a.QLZT00 IN ('0') AND a.CXBZ00='Z' and exists ( select 1 from zy_brxxb0 where a.zyid00=zyid00 and ((nvl(cyrq00,'20991231')<>'20991231') and (brzt00 in ('4','5')))) and not exists(select 1 from bq_ypyzmx where a.yzmxid=yzmxid and trim(yzcllb)='出院带药' ) 20 14:49:59 SQL Data In: ORACLE - Rows affected = 0 21 14:49:59 SQL Prepare: ORACLE - COMMIT 22 14:49:59 SQL Execute: ORACLE - COMMIT 23 14:49:59 SQL Data In: ORACLE - Rows affected = 0 24 14:49:59 SQL Prepare: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=335) and (BMBH00=0 or BMBH00=45) and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' order by YGBH00 25 14:49:59 SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=335) and (BMBH00=0 or BMBH00=45) and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' order by YGBH00 26 14:50:00 SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=335 and (BMBH00=0 or BMBH00=45) and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' and DBGRIN='DBGridEh1' order by LS0000 27 14:50:00 SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=335 and (BMBH00=0 or BMBH00=45) and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' and DBGRIN='DBGridEh1' order by LS0000 28 14:50:00 SQL Prepare: ORACLE - SELECT DISTINCT BRXM00,ZYID00,BQBMBH,YFBMBH,ZYH000,CH0000 FROM YF_YZYPSQ WHERE BQBMBH=:1 AND YFBMBH=:2 AND QLZT00 IN ('0','1') AND HZBZ00='1' AND FYBZ00='1' AND CXBZ00='Z' ORDER BY CH0000 29 14:50:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 30 14:50:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 31 14:50:00 SQL Execute: ORACLE - SELECT DISTINCT BRXM00,ZYID00,BQBMBH,YFBMBH,ZYH000,CH0000 FROM YF_YZYPSQ WHERE BQBMBH=? AND YFBMBH=? AND QLZT00 IN ('0','1') AND HZBZ00='1' AND FYBZ00='1' AND CXBZ00='Z' ORDER BY CH0000 32 14:50:00 SQL Prepare: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=:1 AND a.BQBMBH=:2 AND a.YFBMBH=:3 AND a.CLBZ00 LIKE :4 AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 33 14:50:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1541384.000000 34 14:50:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 35 14:50:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 36 14:50:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 37 14:50:00 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 38 14:50:00 SQL Prepare: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=:1 AND a.BQBMBH=:2 AND a.YFBMBH=:3 AND a.CLBZ00 LIKE :4 AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 39 14:50:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1541384.000000 40 14:50:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 41 14:50:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 42 14:50:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 43 14:50:00 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 44 14:50:00 SQL Prepare: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=:1 AND a.BQBMBH=:2 AND a.YFBMBH=:3 AND a.CLBZ00 LIKE :4 AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 45 14:50:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1541384.000000 46 14:50:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 47 14:50:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 48 14:50:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 49 14:50:00 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 50 14:50:00 SQL Prepare: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=:1 AND a.BQBMBH=:2 AND a.YFBMBH=:3 AND a.CLBZ00 LIKE :4 AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 51 14:50:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1541384.000000 52 14:50:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 53 14:50:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 54 14:50:00 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 55 14:50:00 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 56 14:50:00 SQL Prepare: ORACLE - INSERT INTO XT_YHXXRZ(ID0000,XH0000,XTDM00,JSKSBH,JSYGBH,JSRQ00,JSSJ00) VALUES(SQ_XT_YHXXRZ_ID0000.NEXTVAL,'89396','-1','45','335',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 57 14:50:00 SQL Execute: ORACLE - INSERT INTO XT_YHXXRZ(ID0000,XH0000,XTDM00,JSKSBH,JSYGBH,JSRQ00,JSSJ00) VALUES(SQ_XT_YHXXRZ_ID0000.NEXTVAL,'89396','-1','45','335',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 58 14:50:00 SQL Data In: ORACLE - Rows affected = 1 59 14:50:00 SQL Prepare: ORACLE - Commit 60 14:50:00 SQL Execute: ORACLE - Commit 61 14:50:00 SQL Data In: ORACLE - Rows affected = 0 62 14:50:01 SQL Prepare: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=:1 AND a.BQBMBH=:2 AND a.YFBMBH=:3 AND a.CLBZ00 LIKE :4 AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 63 14:50:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1541482.000000 64 14:50:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 65 14:50:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 66 14:50:01 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 67 14:50:01 SQL Execute: ORACLE - SELECT a.YPQLPC,a.YPMC00,a.YPGG00,a.LSDJ00,a.YPZSL0,a.QLDW00, DECODE(SUBSTR(a.CSL000,1,1),'.','0','')||a.CSL000||a.JLDW00 AS DJL000, decode(a.YPDLBH,'2',to_char(a.ZYDJS0),a.PCMC00) PCMC00, a.YFSMMC||a.YPYFMC||a.ZJYFMC||a.XMYFMC as YYFF00,a.THBZ00, a.ZYTS00,a.YZID00,a.SRRQ00,a.SRSJ00,(select count(*) from yf_yzypsq where yzmxid=a.yzmxid and ypnm00=a.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and cxbz00='Z') SFJYZ0,decode(a.SRCS00,-1,null,a.SRCS00) SRCS00,a.YEXM00, decode(a.YPDLBH,2,substrb(SF_YF_GETYYRQ(a.YZID00,a.ZYTS00),1,20),'') ZYFYRQ,a.ZYDJS0 FROM YF_YZYPSQ a WHERE ZYID00=? AND a.BQBMBH=? AND a.YFBMBH=? AND a.CLBZ00 LIKE ? AND a.QLZT00 IN('0','1') AND a.HZBZ00='1' AND a.FYBZ00='1' AND a.CXBZ00='Z' ORDER BY a.SRRQ00,a.SRSJ00,DECODE(a.YPDLBH,'2',TO_CHAR(a.YZID00),a.YPMC00),a.YZMXID 68 14:50:03 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 69 14:50:03 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 70 14:50:07 SQL Prepare: 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 71 14:50:07 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 72 14:50:10 SQL Prepare: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='2733' and CZBZ00<>'2' and BMBH00='61' 73 14:50:10 SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00 where UPPER(XKH000)='2733' and CZBZ00<>'2' and BMBH00='61' 74 14:50:10 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 75 14:50:10 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 76 14:50:10 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2733' and CZBZ00 in ('1') 77 14:50:10 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2733' and CZBZ00 in ('1') 78 14:50:10 SQL Prepare: ORACLE - Commit 79 14:50:10 SQL Execute: ORACLE - Commit 80 14:50:10 SQL Data In: ORACLE - Rows affected = 0 81 14:50:10 SQL Prepare: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END; 82 14:50:10 SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 83 14:50:10 SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000 84 14:50:10 SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 61.000000 85 14:50:10 SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1541482.000000 86 14:50:10 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 87 14:50:10 SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 88 14:50:10 SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 335.000000 89 14:50:10 SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1724.000000 90 14:50:10 SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 91 14:50:10 SQL Data In: ORACLE - Param = 10, Name = P_BYFHR0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 92 14:50:10 SQL Data In: ORACLE - Param = 11, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 93 14:50:10 SQL Data In: ORACLE - Param = 12, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 14:50:10 SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_BYFHR0 => :P_BYFHR0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE); END; 95 14:50:17 SQL Prepare: 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 96 14:50:17 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 97 14:50:27 SQL Prepare: 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 98 14:50: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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 99 14:50:37 SQL Prepare: 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 100 14:50:37 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 101 14:50:47 SQL Prepare: 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null) 102 14:50:47 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 = '2') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',45,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',335,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =335 AND b.JSKSBH = '45') AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)