1 09:18:15 SQL Execute: ORACLE - select * from (SELECT '1' chkbox,C.CFLSH0,C.GHH000,C.BRXM00,B.BRBLH0,C.XB0000,b.BRDH00,C.CSRQ00,DECODE('Y','Y',C.YSXM00,DECODE(SRRQ00,TO_CHAR(SYSDATE,'YYYYMMDD'),C.YSXM00,' ')) YSXM00,M.BMMC00 AS GHKS00,C.ZYTS00,F.FBMC00,C.SRRQ00,C.JZRQ00,C.JZSJ00,C.CFZJE0,C.CFZT00,C.YPDLBH,C.DJH000,C.FYRQ00,C.FYSJ00,G.ZWXM00 AS LRY000,C.ZYDJS0,C.BCCFH0||TRIM(C.BZ0000) AS BZ0000,H.ZWXM00 AS FYR000,(Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, substr(SF_YF_GETZDXX(C.GHID00),1,50) as ZZDMC0,' ' ZYZDMC,' ' XYZDMC, NVL(C.CFDGS0,'5') CFDGS0,d.lbmc00,substr(SF_YF_KSSCF0(C.CFLSH0),1,1) KSSCF0, decode(SF_YF_KSSCFDPJG(C.CFLSH0),0,'合 格',1,'不合格','未点评') CFDPJG,NVL(B.BRLXDH,B.BRDH00) BRLXDH,(select nvl(a.ZWXM00,'') from BM_YGBM00 a where a.YGBH00=C.FHR000 and rownum=1) FHR000,(select count(distinct d.YPNM00) YPPZS0 from YF_MZCFMX d where c.CFLSH0=d.CFLSH0 ) YPPZS0,(select MC0000 from BM_TSBZB0 K,IC_YBBRLB I where K.YBZXLB=I.YBZXLB and I.FBBH00=B.FBBH00 and I.YBLB00=B.YBLB00 and K.BH0000=C.TSBZBH) TSBZMC, (select f.LBMC00 from SF_BRXXB0 e,BM_GHLBB0 f where e.GHID00=c.GHID00 and e.GHLB00=f.LBBH00 and rownum=1) GHLBMC,C.GHID00 from BM_BRXXB0 B,YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F,BM_YPLB00 d WHERE C.YFBMBH+0=133 AND C.FYRQ00>='20210101' AND C.FYRQ00<='20210131' AND C.CFXZ00='0' AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00(+) AND C.BRID00=B.BRID00 AND C.BRID00=F.BRID00 AND C.GHH000=F.GHH000 AND C.FYR000=H.YGBH00(+) AND c.YPDLBH=d.lbbh00 ORDER BY C.CFZT00,C.CFLSH0) where 2=2 2 09:18:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190515 3 09:18:16 SQL Execute: ORACLE - SELECT '0' CHECK0,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00,YPNM00,d.TSYS00 FROM YF_MZCFMX d WHERE CFLSH0=? AND SFZBY0='N' 4 09:18:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190515 5 09:18:17 SQL Execute: ORACLE - SELECT '0' CHECK0,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00,YPNM00,d.TSYS00 FROM YF_MZCFMX d WHERE CFLSH0=? AND SFZBY0='N' 6 09:18:17 SQL Execute: ORACLE - select count(distinct C.GHH000) GHS000 from (select C.GHH000 from BM_BRXXB0 B,YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F,BM_YPLB00 d WHERE C.YFBMBH+0=133 AND C.FYRQ00>='20210101' AND C.FYRQ00<='20210131' AND C.CFXZ00='0' AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00(+) AND C.BRID00=B.BRID00 AND C.BRID00=F.BRID00 AND C.GHH000=F.GHH000 AND C.FYR000=H.YGBH00(+) AND c.YPDLBH=d.lbbh00 ORDER BY C.CFZT00,C.CFLSH0) C where 2=2 7 09:18:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190515 8 09:18:17 SQL Execute: ORACLE - SELECT '0' CHECK0,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00,YPNM00,d.TSYS00 FROM YF_MZCFMX d WHERE CFLSH0=? AND SFZBY0='N' 9 09:18:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190515 10 09:18:17 SQL Execute: ORACLE - SELECT '0' CHECK0,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00,YPNM00,d.TSYS00 FROM YF_MZCFMX d WHERE CFLSH0=? AND SFZBY0='N' 11 09:18:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1190515 12 09:18:17 SQL Execute: ORACLE - SELECT '0' CHECK0,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00,YPNM00,d.TSYS00 FROM YF_MZCFMX d WHERE CFLSH0=? AND SFZBY0='N' 13 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19681214) AS NL FROM DUAL 14 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19630930) AS NL FROM DUAL 15 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19360103) AS NL FROM DUAL 16 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19821029) AS NL FROM DUAL 17 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20130219) AS NL FROM DUAL 18 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19220109) AS NL FROM DUAL 19 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20171031) AS NL FROM DUAL 20 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19830107) AS NL FROM DUAL 21 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700103) AS NL FROM DUAL 22 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700103) AS NL FROM DUAL 23 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700103) AS NL FROM DUAL 24 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700103) AS NL FROM DUAL 25 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700103) AS NL FROM DUAL 26 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19700103) AS NL FROM DUAL 27 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19910103) AS NL FROM DUAL 28 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19910103) AS NL FROM DUAL 29 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19910103) AS NL FROM DUAL 30 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19910103) AS NL FROM DUAL 31 09:18:17 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20180103) AS NL FROM DUAL