1       08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1064265         
2       08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1768304.000000
3       08:36:51  SQL Execute: ORACLE - SELECT X.YPNM00, X.ZYH000,trim(X.YPMC00)||'/'||trim(X.YPGG00) as YPMC00,
DECODE(SUBSTR(X.CSL000,1,1),'.','0','')||X.CSL000||X.JLDW00 AS DJL000,
X.PCMC00,X.CH0000,X.ZCXSL0,rtrim(X.YFSMMC)||trim(X.YPYFMC)||rtrim(X.ZJYFMC)||trim(X.XMYFMC) as YYFF00,
X.LSDJ00,X.YPZSL0,X.YPZSL0||'('||rtrim(X.QLDW00)||')' AS LYSL00,
X.BRXM00,X.ZYID00,X.ZYTS00,X.YPDLBH,X.YZID00,X.CXBZ00,X.SRRQ00,X.TQDJH0,
DECODE(D.YPCZFL ,'3','是','否') SFBYJY,X.FYRQ00,decode(X.SRCS00,-1,null,X.SRCS00) SRCS00, 
(select count(*)  from yf_yzypsq where yzmxid=x.yzmxid and ypnm00=x.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and FYRQ00<to_char(sysdate,'YYYYMMDD') and cxbz00='Z') SFJYZ0,
X.YEXM00,decode(X.YPDLBH,2,substrb(SF_YF_GETYYRQ(X.YZID00,X.ZYTS00),1,20),'') ZYFYRQ, X.ZYDJS0 
 FROM YF_YZYPSQ X,BM_YD0000 D 
 WHERE  X.YPNM00=D.YPNM00 AND CKDH00=? AND ZYID00=? 
 ORDER BY X.CH0000,DECODE(X.YPDLBH,'2',TO_CHAR(X.YZID00),X.YPMC00) 

4       08:36:51  SQL Execute: ORACLE - SELECT DISTINCT Q.CKDH00,Q.FYRQ00,Q.FYSJ00,Y1.ZWXM00 AS FYRXM0,Y2.ZWXM00 AS LYRXM0,Q.LYRQ00,Q.LYSJ00,Q.BZ0000,M.BMMC00,
 (select bz0000 from yf_ypckd0 where ckdh00=q.ckdh00) CLBZ00,Q.BYJXX0,
 (select ZWXM00 from BM_YGBM00 where YGBH00=q.BYR000) BYR000,
 (select ZWXM00 from BM_YGBM00 Y,YF_YZYPDL L where  Y.YGBH00=L.PYR000 and L.CKDH00=Q.CKDH00 and rownum=1) PYR000,
 (select ZWXM00 from BM_YGBM00 where YGBH00=q.FHR000) FHR000
 FROM YF_YZYPSQ Q,BM_YGBM00 Y1,BM_YGBM00 Y2,BM_BMBM00 M,BM_YD0000 D
 WHERE Q.YFBMBH=45
 AND Q.BQBMBH+0=431
 AND Q.LYRQ00>='20221008'
 AND Q.LYRQ00<='20221008'
 AND Q.FYR000=Y1.YGBH00 AND Q.LYR000=Y2.YGBH00(+) AND Q.BQBMBH=M.BMBH00 AND Q.YPNM00=D.YPNM00 
 AND Q.QLZT00 in ('4','5','6') AND  Q.HZBZ00='1'
 ORDER BY CKDH00

5       08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064263
6       08:36:51  SQL Execute: ORACLE - SELECT DISTINCT  BRXM00,ZYID00,BQBMBH,YFBMBH,
     ZYH000, CH0000,CKDH00,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ  a
WHERE  CKDH00=?
ORDER BY CH0000


 

7       08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1064263         
8       08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1768304.000000
9       08:36:51  SQL Execute: ORACLE - SELECT X.YPNM00, X.ZYH000,trim(X.YPMC00)||'/'||trim(X.YPGG00) as YPMC00,
DECODE(SUBSTR(X.CSL000,1,1),'.','0','')||X.CSL000||X.JLDW00 AS DJL000,
X.PCMC00,X.CH0000,X.ZCXSL0,rtrim(X.YFSMMC)||trim(X.YPYFMC)||rtrim(X.ZJYFMC)||trim(X.XMYFMC) as YYFF00,
X.LSDJ00,X.YPZSL0,X.YPZSL0||'('||rtrim(X.QLDW00)||')' AS LYSL00,
X.BRXM00,X.ZYID00,X.ZYTS00,X.YPDLBH,X.YZID00,X.CXBZ00,X.SRRQ00,X.TQDJH0,
DECODE(D.YPCZFL ,'3','是','否') SFBYJY,X.FYRQ00,decode(X.SRCS00,-1,null,X.SRCS00) SRCS00, 
(select count(*)  from yf_yzypsq where yzmxid=x.yzmxid and ypnm00=x.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and FYRQ00<to_char(sysdate,'YYYYMMDD') and cxbz00='Z') SFJYZ0,
X.YEXM00,decode(X.YPDLBH,2,substrb(SF_YF_GETYYRQ(X.YZID00,X.ZYTS00),1,20),'') ZYFYRQ, X.ZYDJS0 
 FROM YF_YZYPSQ X,BM_YD0000 D 
 WHERE  X.YPNM00=D.YPNM00 AND CKDH00=? AND ZYID00=? 
 ORDER BY X.CH0000,DECODE(X.YPDLBH,'2',TO_CHAR(X.YZID00),X.YPMC00) 

10      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064263
11      08:36:51  SQL Execute: ORACLE - SELECT DISTINCT  BRXM00,ZYID00,BQBMBH,YFBMBH,
     ZYH000, CH0000,CKDH00,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ  a
WHERE  CKDH00=?
ORDER BY CH0000


 

12      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1064263         
13      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1768304.000000
14      08:36:51  SQL Execute: ORACLE - SELECT X.YPNM00, X.ZYH000,trim(X.YPMC00)||'/'||trim(X.YPGG00) as YPMC00,
DECODE(SUBSTR(X.CSL000,1,1),'.','0','')||X.CSL000||X.JLDW00 AS DJL000,
X.PCMC00,X.CH0000,X.ZCXSL0,rtrim(X.YFSMMC)||trim(X.YPYFMC)||rtrim(X.ZJYFMC)||trim(X.XMYFMC) as YYFF00,
X.LSDJ00,X.YPZSL0,X.YPZSL0||'('||rtrim(X.QLDW00)||')' AS LYSL00,
X.BRXM00,X.ZYID00,X.ZYTS00,X.YPDLBH,X.YZID00,X.CXBZ00,X.SRRQ00,X.TQDJH0,
DECODE(D.YPCZFL ,'3','是','否') SFBYJY,X.FYRQ00,decode(X.SRCS00,-1,null,X.SRCS00) SRCS00, 
(select count(*)  from yf_yzypsq where yzmxid=x.yzmxid and ypnm00=x.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and FYRQ00<to_char(sysdate,'YYYYMMDD') and cxbz00='Z') SFJYZ0,
X.YEXM00,decode(X.YPDLBH,2,substrb(SF_YF_GETYYRQ(X.YZID00,X.ZYTS00),1,20),'') ZYFYRQ, X.ZYDJS0 
 FROM YF_YZYPSQ X,BM_YD0000 D 
 WHERE  X.YPNM00=D.YPNM00 AND CKDH00=? AND ZYID00=? 
 ORDER BY X.CH0000,DECODE(X.YPDLBH,'2',TO_CHAR(X.YZID00),X.YPMC00) 

15      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15028.000000
16      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
17      08:36:51  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,
       CXBZ00,ZCXSL0,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00,
      (select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ a
WHERE YPNM00=?
  AND CKDH00=?
ORDER BY CH0000

18      08:36:51  SQL Execute: ORACLE - SELECT DISTINCT Q.CKDH00,Q.FYRQ00,Q.FYSJ00,Y1.ZWXM00 AS FYRXM0,M.BMMC00, Y2.ZWXM00 AS LYRXM0,Q.LYRQ00,Q.LYSJ00,Q.YFBMBH,DECODE(Q.CXBZ00,'+','Z',Q.CXBZ00) CXBZ00,
 (select ZWXM00 from BM_YGBM00 where YGBH00=q.BYR000) BYR000,
 (select ZWXM00 from BM_YGBM00 Y,YF_YZYPDL L where  Y.YGBH00=L.PYR000 and L.CKDH00=Q.CKDH00 and rownum=1) PYR000,
 (select ZWXM00 from BM_YGBM00 where YGBH00=q.FHR000) FHR000,
 (select bz0000 from yf_ypckd0 where ckdh00=q.ckdh00) CLBZ00
 FROM YF_YZYPSQ Q,BM_YGBM00 Y1,BM_YGBM00 Y2,BM_BMBM00 M
 WHERE Q.YFBMBH=45
 AND  Q.BQBMBH+0=431
 AND Q.LYRQ00>='20221008'
 AND Q.LYRQ00<='20221008'
 AND Q.FYR000=Y1.YGBH00 AND Q.LYR000=Y2.YGBH00(+) AND Q.BQBMBH=M.BMBH00
 AND  Q.QLZT00 in ('4','5','6') AND Q.HZBZ00='0'
 ORDER BY CKDH00

19      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
20      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
21      08:36:51  SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
    C.LSDJ00,C.CKSL00||TRIM(C.CKDW00) as LYSL00,C.CKSL00,
    D.DXSYBZ,D.JXBH00,D.YLBH00,
    nvl((select X.GZDJ00 from YF_YPKCXX X where C.YPNM00=X.YPNM00
      AND  X.YFBMBH=?),D.GZDJ00) GZDJ00 ,
    C.CKDH00,C.YPNM00,
    D.YPBM00
FROM YF_YPCKMX C,BM_YD0000 D
WHERE C.CKDH00=?
      AND  C.YPNM00=D.YPNM00
ORDER BY GZDJ00,D.DXSYBZ,D.YPBM00


22      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15028.000000
23      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
24      08:36:51  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,
       CXBZ00,ZCXSL0,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00,
      (select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ a
WHERE YPNM00=?
  AND CKDH00=?
ORDER BY CH0000

25      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
26      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
27      08:36:51  SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
    C.LSDJ00,C.CKSL00||TRIM(C.CKDW00) as LYSL00,C.CKSL00,
    D.DXSYBZ,D.JXBH00,D.YLBH00,
    nvl((select X.GZDJ00 from YF_YPKCXX X where C.YPNM00=X.YPNM00
      AND  X.YFBMBH=?),D.GZDJ00) GZDJ00 ,
    C.CKDH00,C.YPNM00,
    D.YPBM00
FROM YF_YPCKMX C,BM_YD0000 D
WHERE C.CKDH00=?
      AND  C.YPNM00=D.YPNM00
ORDER BY GZDJ00,D.DXSYBZ,D.YPBM00


28      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15028.000000
29      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
30      08:36:51  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,
       CXBZ00,ZCXSL0,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00,
      (select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ a
WHERE YPNM00=?
  AND CKDH00=?
ORDER BY CH0000

31      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064263
32      08:36:51  SQL Execute: ORACLE - SELECT DISTINCT  BRXM00,ZYID00,BQBMBH,YFBMBH,
     ZYH000, CH0000,CKDH00,(select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ  a
WHERE  CKDH00=?
ORDER BY CH0000


 

33      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1064263         
34      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1768304.000000
35      08:36:51  SQL Execute: ORACLE - SELECT X.YPNM00, X.ZYH000,trim(X.YPMC00)||'/'||trim(X.YPGG00) as YPMC00,
DECODE(SUBSTR(X.CSL000,1,1),'.','0','')||X.CSL000||X.JLDW00 AS DJL000,
X.PCMC00,X.CH0000,X.ZCXSL0,rtrim(X.YFSMMC)||trim(X.YPYFMC)||rtrim(X.ZJYFMC)||trim(X.XMYFMC) as YYFF00,
X.LSDJ00,X.YPZSL0,X.YPZSL0||'('||rtrim(X.QLDW00)||')' AS LYSL00,
X.BRXM00,X.ZYID00,X.ZYTS00,X.YPDLBH,X.YZID00,X.CXBZ00,X.SRRQ00,X.TQDJH0,
DECODE(D.YPCZFL ,'3','是','否') SFBYJY,X.FYRQ00,decode(X.SRCS00,-1,null,X.SRCS00) SRCS00, 
(select count(*)  from yf_yzypsq where yzmxid=x.yzmxid and ypnm00=x.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and FYRQ00<to_char(sysdate,'YYYYMMDD') and cxbz00='Z') SFJYZ0,
X.YEXM00,decode(X.YPDLBH,2,substrb(SF_YF_GETYYRQ(X.YZID00,X.ZYTS00),1,20),'') ZYFYRQ, X.ZYDJS0 
 FROM YF_YZYPSQ X,BM_YD0000 D 
 WHERE  X.YPNM00=D.YPNM00 AND CKDH00=? AND ZYID00=? 
 ORDER BY X.CH0000,DECODE(X.YPDLBH,'2',TO_CHAR(X.YZID00),X.YPMC00) 

36      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1064263         
37      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1768304.000000
38      08:36:51  SQL Execute: ORACLE - SELECT X.YPNM00, X.ZYH000,trim(X.YPMC00)||'/'||trim(X.YPGG00) as YPMC00,
DECODE(SUBSTR(X.CSL000,1,1),'.','0','')||X.CSL000||X.JLDW00 AS DJL000,
X.PCMC00,X.CH0000,X.ZCXSL0,rtrim(X.YFSMMC)||trim(X.YPYFMC)||rtrim(X.ZJYFMC)||trim(X.XMYFMC) as YYFF00,
X.LSDJ00,X.YPZSL0,X.YPZSL0||'('||rtrim(X.QLDW00)||')' AS LYSL00,
X.BRXM00,X.ZYID00,X.ZYTS00,X.YPDLBH,X.YZID00,X.CXBZ00,X.SRRQ00,X.TQDJH0,
DECODE(D.YPCZFL ,'3','是','否') SFBYJY,X.FYRQ00,decode(X.SRCS00,-1,null,X.SRCS00) SRCS00, 
(select count(*)  from yf_yzypsq where yzmxid=x.yzmxid and ypnm00=x.YPNM00 and qlzt00 in('2','4') and fyrq00<>'20991231' and FYRQ00<to_char(sysdate,'YYYYMMDD') and cxbz00='Z') SFJYZ0,
X.YEXM00,decode(X.YPDLBH,2,substrb(SF_YF_GETYYRQ(X.YZID00,X.ZYTS00),1,20),'') ZYFYRQ, X.ZYDJS0 
 FROM YF_YZYPSQ X,BM_YD0000 D 
 WHERE  X.YPNM00=D.YPNM00 AND CKDH00=? AND ZYID00=? 
 ORDER BY X.CH0000,DECODE(X.YPDLBH,'2',TO_CHAR(X.YZID00),X.YPMC00) 

39      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15028.000000
40      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
41      08:36:51  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,
       CXBZ00,ZCXSL0,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00,
      (select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ a
WHERE YPNM00=?
  AND CKDH00=?
ORDER BY CH0000

42      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 45.000000
43      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
44      08:36:51  SQL Execute: ORACLE - SELECT trim(C.YPMC00)||'/'||trim(C.YPGG00) as YPMC00,
    C.LSDJ00,C.CKSL00||TRIM(C.CKDW00) as LYSL00,C.CKSL00,
    D.DXSYBZ,D.JXBH00,D.YLBH00,
    nvl((select X.GZDJ00 from YF_YPKCXX X where C.YPNM00=X.YPNM00
      AND  X.YFBMBH=?),D.GZDJ00) GZDJ00 ,
    C.CKDH00,C.YPNM00,
    D.YPBM00
FROM YF_YPCKMX C,BM_YD0000 D
WHERE C.CKDH00=?
      AND  C.YPNM00=D.YPNM00
ORDER BY GZDJ00,D.DXSYBZ,D.YPBM00


45      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15028.000000
46      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
47      08:36:51  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,
       CXBZ00,ZCXSL0,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00,
      (select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ a
WHERE YPNM00=?
  AND CKDH00=?
ORDER BY CH0000

48      08:36:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15028.000000
49      08:36:51  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1064262
50      08:36:51  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,
       CXBZ00,ZCXSL0,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00,
      (select BRID00 from ZY_BRXXB0 where ZYID00=a.ZYID00) BRID00
FROM YF_YZYPSQ a
WHERE YPNM00=?
  AND CKDH00=?
ORDER BY CH0000

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

52      08:37:16  Log started for: SQL Navigator for Oracle