1       14:50:26  Log started for: 药房管理系统
2       14:50: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||',', ',342,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =342 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

3       14:50: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||',', ',342,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =342 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

4       14:51:03  SQL Prepare: ORACLE - SELECT 1 FROM YF_YZYPSQ 
 WHERE YFBMBH=45
   AND  BQBMBH=57
   AND QLZT00 IN ('0','1')AND THBZ00='0'
   AND HZBZ00='1'

5       14:51:03  SQL Execute: ORACLE - SELECT 1 FROM YF_YZYPSQ 
 WHERE YFBMBH=45
   AND  BQBMBH=57
   AND QLZT00 IN ('0','1')AND THBZ00='0'
   AND HZBZ00='1'

6       14:51:03  SQL Prepare: ORACLE - SELECT 'X' FROM YF_YZYPSQ 
 WHERE YFBMBH=45
   AND  BQBMBH=57
   AND QLZT00 IN ('0','1') AND THBZ00='0'
   AND HZBZ00='0'

7       14:51:03  SQL Execute: ORACLE - SELECT 'X' FROM YF_YZYPSQ 
 WHERE YFBMBH=45
   AND  BQBMBH=57
   AND QLZT00 IN ('0','1') AND THBZ00='0'
   AND HZBZ00='0'

8       14:51:04  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

9       14:51:04  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

10      14:51:04  SQL Prepare: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2'
 WHERE YFBMBH=45
   AND BQBMBH=57

11      14:51:04  SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='2'
 WHERE YFBMBH=45
   AND BQBMBH=57

12      14:51:04  SQL Data In: ORACLE - Rows affected = 1
13      14:51:04  SQL Prepare: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1'
 WHERE YFBMBH=45
   AND BQBMBH=57
   AND QLZT00 IN ('0','1')
   AND FYBZ00='0'
   AND THBZ00='0'
   AND CXBZ00='Z'

14      14:51:04  SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='1'
 WHERE YFBMBH=45
   AND BQBMBH=57
   AND QLZT00 IN ('0','1')
   AND FYBZ00='0'
   AND THBZ00='0'
   AND CXBZ00='Z'

15      14:51:04  SQL Data In: ORACLE - Rows affected = 36
16      14:51:04  SQL Prepare: ORACLE - COMMIT

17      14:51:04  SQL Execute: ORACLE - COMMIT

18      14:51:04  SQL Data In: ORACLE - Rows affected = 0
19      14:51:04  SQL Prepare: ORACLE - UPDATE YF_YZYPSQ a SET a.qlzt00='3' 
 WHERE a.YFBMBH=45
   AND a.BQBMBH=57
   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:51:04  SQL Execute: ORACLE - UPDATE YF_YZYPSQ a SET a.qlzt00='3' 
 WHERE a.YFBMBH=45
   AND a.BQBMBH=57
   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)='出院带药' )

21      14:51:04  SQL Data In: ORACLE - Rows affected = 0
22      14:51:04  SQL Prepare: ORACLE - COMMIT

23      14:51:04  SQL Execute: ORACLE - COMMIT

24      14:51:04  SQL Data In: ORACLE - Rows affected = 0
25      14:51:04  SQL Prepare: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=342) and  (BMBH00=0 or  BMBH00=45)
 and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' order by YGBH00 

26      14:51:04  SQL Execute: ORACLE - select distinct DBGRIN,YGBH00 from XT_ZDYLXS where (YGBH00=0 or YGBH00=342) and  (BMBH00=0 or  BMBH00=45)
 and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' order by YGBH00 

27      14:51:04  SQL Prepare: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=342 and (BMBH00=0 or BMBH00=45)
 and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' and DBGRIN='DBGridEh1' order by LS0000

28      14:51:04  SQL Execute: ORACLE - select LS0000,SFXS00,FLDNME,CPTNNE,WIDTH00,BTBJYS,WGBJYS from XT_ZDYLXS where YGBH00=342 and (BMBH00=0 or BMBH00=45)
 and DLXTMC='药房管理系统' and CTMC00='frmYF_BQKFFY' and DBGRIN='DBGridEh1' order by LS0000

29      14:51:04  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

30      14:51:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
31      14:51:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
32      14:51:04  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

33      14:51:04  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

34      14:51:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1579465.000000
35      14:51:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
36      14:51:04  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
37      14:51:04  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
38      14:51:04  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

39      14:51:04  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

40      14:51:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1579465.000000
41      14:51:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
42      14:51:04  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
43      14:51:04  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
44      14:51:04  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

45      14:51:04  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

46      14:51:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1579465.000000
47      14:51:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
48      14:51:04  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
49      14:51:04  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
50      14:51:04  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

51      14:51:04  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

52      14:51:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1579465.000000
53      14:51:04  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
54      14:51:04  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
55      14:51:04  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
56      14:51:04  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

57      14:51: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||',', ',342,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =342 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

58      14:51: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||',', ',342,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =342 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

59      14:51:08  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

60      14:51:08  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

61      14:51: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||',', ',342,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =342 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

62      14:51: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||',', ',342,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =342 AND b.JSKSBH = '45')
  AND (INSTR (',' || a.jsksbh || ',',',45,') > 0 or a.jsksbh is null)  

63      14:51:23  SQL Prepare: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='2300'
 and CZBZ00<>'2' and BMBH00='57'

64      14:51:23  SQL Execute: ORACLE - Select YGBH00,DLMM00,ZWXM00 from BM_YGBM00
 where UPPER(XKH000)='2300'
 and CZBZ00<>'2' and BMBH00='57'

65      14:51:23  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

66      14:51:23  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2'

67      14:51:23  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2300' and CZBZ00 in ('1') 

68      14:51:23  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='2300' and CZBZ00 in ('1') 

69      14:51:23  SQL Prepare: ORACLE - Commit

70      14:51:23  SQL Execute: ORACLE - Commit

71      14:51:23  SQL Data In: ORACLE - Rows affected = 0
72      14:51:23  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;
73      14:51:23  SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
74      14:51:23  SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
75      14:51:23  SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 57.000000
76      14:51:23  SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
77      14:51:23  SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
78      14:51:23  SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
79      14:51:23  SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 342.000000
80      14:51:23  SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1662.000000
81      14:51:23  SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
82      14:51:23  SQL Data In: ORACLE - Param = 10, Name = P_BYFHR0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
83      14:51:23  SQL Data In: ORACLE - Param = 11, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
84      14:51:23  SQL Data In: ORACLE - Param = 12, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
85      14:51:23  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;
86      14:51:24  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

87      14:51:24  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL

88      14:51:24  SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

89      14:51:24  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL

90      14:51:24  SQL Prepare: ORACLE -  SELECT b.ZYID00,sf_xt_yymc00(45) YYJC00,
Y.CKDH00,Y.ZYH000,Y.CH0000,Y.BRXM00,Y.TQDJH0,Y.YPQLPC,B.CSRQ00,B.XB0000,Y.YPYFMC,
Y.YPMC00,Y.YPGG00,(select YPTYM0 FROM BM_YD0000 WHERE YPNM00=Y.YPNM00) AS YPTYM0,
Y.LSDJ00,Y.YPZSL0,Y.QLDW00,Y.PCMC00,Y.YZID00,Y.ZYTS00,Y.YPDLBH,Y.FYRQ00,Y.FYSJ00,Y.YFSMMC,
DECODE(SUBSTR(Y.CSL000,1,1),'.','0','')||Y.CSL000||Y.JLDW00 AS DJL000,
TRIM(Y.YPYFMC)||TRIM(Y.XMYFMC) as YYFF00,
(SELECT M.ZWXM00 FROM BM_YGBM00 M WHERE M.YGBH00=Y.YSGZH0) YSXM00,
Y.THBZ00,Y.FJFDJH,Y.SRRQ00,Y.SRSJ00,Y.PCSJ00,Y.FYRQ00,Y.FYSJ00,Y.BZ0000,Y.ZYDJS0,
SF_YF_EXROUND(Y.YPZSL0*Y.LSDJ00,0,2) AS C_YPJE
,(select trim(zqs000||zqdw00) from BQ_YPYZ00 e where e.yzid00=Y.YZID00 AND ROWNUM=1) CXTS00, 
 decode(Y.YPDLBH,2,substrb(SF_YF_GETYYRQ(Y.YZID00,Y.ZYTS00),1,20),'') ZYFYRQ
 FROM YF_YZYPSQ Y,ZY_BRXXB0 B,BM_YD0000 D WHERE Y.ZYID00=B.ZYID00 AND Y.YPNM00=D.YPNM00
 AND Y.CKDH00='798117'
 ORDER BY Y.CH0000,Y.YPDLBH,Y.SRRQ00,DECODE(Y.YPDLBH,'2',TO_CHAR(Y.YZID00),
 Y.YPMC00),DECODE(Y.YPDLBH,'2',Y.TQDJH0),Y.YZMXID 

91      14:51:24  SQL Execute: ORACLE -  SELECT b.ZYID00,sf_xt_yymc00(45) YYJC00,
Y.CKDH00,Y.ZYH000,Y.CH0000,Y.BRXM00,Y.TQDJH0,Y.YPQLPC,B.CSRQ00,B.XB0000,Y.YPYFMC,
Y.YPMC00,Y.YPGG00,(select YPTYM0 FROM BM_YD0000 WHERE YPNM00=Y.YPNM00) AS YPTYM0,
Y.LSDJ00,Y.YPZSL0,Y.QLDW00,Y.PCMC00,Y.YZID00,Y.ZYTS00,Y.YPDLBH,Y.FYRQ00,Y.FYSJ00,Y.YFSMMC,
DECODE(SUBSTR(Y.CSL000,1,1),'.','0','')||Y.CSL000||Y.JLDW00 AS DJL000,
TRIM(Y.YPYFMC)||TRIM(Y.XMYFMC) as YYFF00,
(SELECT M.ZWXM00 FROM BM_YGBM00 M WHERE M.YGBH00=Y.YSGZH0) YSXM00,
Y.THBZ00,Y.FJFDJH,Y.SRRQ00,Y.SRSJ00,Y.PCSJ00,Y.FYRQ00,Y.FYSJ00,Y.BZ0000,Y.ZYDJS0,
SF_YF_EXROUND(Y.YPZSL0*Y.LSDJ00,0,2) AS C_YPJE
,(select trim(zqs000||zqdw00) from BQ_YPYZ00 e where e.yzid00=Y.YZID00 AND ROWNUM=1) CXTS00, 
 decode(Y.YPDLBH,2,substrb(SF_YF_GETYYRQ(Y.YZID00,Y.ZYTS00),1,20),'') ZYFYRQ
 FROM YF_YZYPSQ Y,ZY_BRXXB0 B,BM_YD0000 D WHERE Y.ZYID00=B.ZYID00 AND Y.YPNM00=D.YPNM00
 AND Y.CKDH00='798117'
 ORDER BY Y.CH0000,Y.YPDLBH,Y.SRRQ00,DECODE(Y.YPDLBH,'2',TO_CHAR(Y.YZID00),
 Y.YPMC00),DECODE(Y.YPDLBH,'2',Y.TQDJH0),Y.YZMXID 

92      14:51:24  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(19710827) AS NL FROM DUAL

93      14:51:24  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19710827) AS NL FROM DUAL

94      14:51:24  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(19681004) AS NL FROM DUAL

95      14:51:24  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19681004) AS NL FROM DUAL

96      14:51:24  SQL Prepare: ORACLE - SELECT  SF_BQ_CSRQTONL(19500805) AS NL FROM DUAL

97      14:51:24  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19500805) AS NL FROM DUAL

98      14:51:24  SQL Prepare: ORACLE - SELECT COUNT(1) as Counter FROM YF_YZYPSQ
 WHERE BQBMBH=57
 AND YFBMBH=45
 AND QLZT00 IN ('0','1')
 AND CXBZ00='Z'
 AND THBZ00='0'

99      14:51:24  SQL Execute: ORACLE - SELECT COUNT(1) as Counter FROM YF_YZYPSQ
 WHERE BQBMBH=57
 AND YFBMBH=45
 AND QLZT00 IN ('0','1')
 AND CXBZ00='Z'
 AND THBZ00='0'

100     14:51:24  SQL Prepare: ORACLE - UPDATE BM_BQFYZT SET FYZT00='1'
 WHERE YFBMBH=45
   AND BQBMBH=57

101     14:51:24  SQL Execute: ORACLE - UPDATE BM_BQFYZT SET FYZT00='1'
 WHERE YFBMBH=45
   AND BQBMBH=57

102     14:51:24  SQL Data In: ORACLE - Rows affected = 1
103     14:51:24  SQL Prepare: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='0'
 WHERE YFBMBH=45
   AND BQBMBH=57
   AND QLZT00 IN ('0','1')
   AND FYBZ00 <>'0'

104     14:51:24  SQL Execute: ORACLE - UPDATE YF_YZYPSQ SET FYBZ00='0'
 WHERE YFBMBH=45
   AND BQBMBH=57
   AND QLZT00 IN ('0','1')
   AND FYBZ00 <>'0'

105     14:51:24  SQL Data In: ORACLE - Rows affected = 32
106     14:51:24  SQL Prepare: ORACLE - COMMIT

107     14:51:24  SQL Execute: ORACLE - COMMIT

108     14:51:24  SQL Data In: ORACLE - Rows affected = 0
109     14:51:24  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

110     14:51:24  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