1       14:13:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12335720
2       14:13:26  SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  to_char(CSL000,'fm999999990.0999')||JLDW00
  AS DJL000,PCMC00,ZCXSL0,
  YPYFMC||XMYFMC as YYFF00,
  BZ0000  BZ0000,
  YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,
  decode(SFZBY0,'N',YPZSL0-JYSL00,0) SJSL00,
  decode(SFZBY0,'Y','是','否') ZBYP00,
 (select SCCJZW from BM_YPSCCJ where SCCJBH=(select SCCJBH from BM_YD0000 where YPNM00=a.YPNM00)) SCCJZW
FROM YF_MZCFMX a
WHERE  CFLSH0=?  order by CFID00

3       14:13:26  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12335720
4       14:13:26  SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,
  to_char(CSL000,'fm999999990.0999')||JLDW00
  AS DJL000,PCMC00,ZCXSL0,
  YPYFMC||XMYFMC as YYFF00,
  BZ0000  BZ0000,
  YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,
  decode(SFZBY0,'N',YPZSL0-JYSL00,0) SJSL00,
  decode(SFZBY0,'Y','是','否') ZBYP00,
 (select SCCJZW from BM_YPSCCJ where SCCJBH=(select SCCJBH from BM_YD0000 where YPNM00=a.YPNM00)) SCCJZW
FROM YF_MZCFMX a
WHERE  CFLSH0=?  order by CFID00

5       14:13:26  SQL Execute: ORACLE -  select rownum, * from ( 
SELECT  '1' chkbox,C.CFLSH0,C.GHH000,C.BRID00,C.BRXM00,B.BRBLH0,C.XB0000,b.BRDH00,substrb(decode (SF_YF_KSSCF0(C.CFLSH0),'N','否','Y','是' ),1,2)SFKSS0,
C.CSRQ00,substrb(sf_xt_CsrqToNl(C.CSRQ00,NULL),1,20) BRNL00,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,
decode(C.CFZT00,'0',decode(C.BCCFH0,NULL,'未记账','未退费'),'1','已记账','4','未审核','2','已发药','3','已作废','5','已退药','6','已退费') CFZTMC,
 G.ZWXM00 as FHRXM0, 
C.DJH000,C.FYRQ00,C.FYSJ00,C.ZYDJS0,
C.BCCFH0||TRIM(C.BZ0000)||' '||trim(C.CFSM00) AS BZ0000,H.ZWXM00 AS FYR000,
(Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000,
S.TW0000,S.HXCS00,S.SSY000,S.SZY000,S.GMJL00,
(Select sum(CFZJE0) FROM YF_MZCF00 Where BRID00=C.BRID00 and BCCFH0=C.CFLSH0 AND CFZT00 IN ('5','6')) TYTFJE,
rpad(nvl(trim(decode(TRIM(SF_YF_GETXYZYZD(c.GHH000,'1')),'','','(西)'||trim(SF_YF_GETXYZYZD(c.GHH000,'1')))  ||chr(10)||decode(trim(SF_YF_GETXYZYZD(c.GHH000,'0')),'','','(中)'||trim(SF_YF_GETXYZYZD(c.GHH000,'0')))  ),'待查'  ),60,' '  ) ZZDMC0,
SUBSTR((SELECT SF_YF_GETXYZYZD(C.GHH000,'0') FROM DUAL),1,100) as ZYZDMC,
SUBSTR((SELECT SF_YF_GETXYZYZD(C.GHH000,'1') FROM DUAL),1,100) as XYZDMC,
 NVL(C.CFDGS0,'5') CFDGS0,d.lbmc00,substr(SF_YF_KSSCF0(C.CFLSH0),1,1)  KSSCF0, 
decode(SF_YF_KSSCFDPJG(C.CFLSH0,'1'),0,'合  格',1,'不合格','未点评') CFDPJG,B.BRLXDH, 
substrb(SF_YF_CFDP_NHGJG(C.CFLSH0,'1'),1,248) BHGYY0, 
R.FYDLXH,substr(SF_PY_PYLBMC(c.CFLSH0),1,10) PYLBMC,C.BCCFH0, 
R.DYSJ00 PYDYSJ,R.PYSJ00 PYJHSJ,R.FYSJ00 PYFYSJ, 
round((to_date(R.PYRQ00||R.PYSJ00,'YYYYMMDDHH24:MI:SS')-to_date(R.DYRQ00||R.DYSJ00,'YYYYMMDDHH24:MI:SS'))*86400) DYJHJG, 
round((to_date(R.PYRQ00||R.PYSJ00,'YYYYMMDDHH24:MI:SS')-to_date(R.CJRQ00||R.CJSJ00,'YYYYMMDDHH24:MI:SS'))*86400) QHJHJG, 
(select CKMC00 from BM_CKBM00 where flag00='3' and CKBH00=R.FYCKBH and rownum=1) FYCKMC,
(select Y.ZWXM00 from BM_YGBM00 Y,YF_DSCFDL Z where Y.YGBH00 = Z.CZY000 and Z.CFLSH0 = C.CFLSH0) ZWXM00, 
(select max(MC0000) from bm_tsbzb0 where BH0000 = (select nvl(c.TSBZBH,a.TSBZBH) from sf_BRXXB0 A where a.GHH000 = C.GHH000 and rownum = 1)) TSBZMC 
from BM_BRXXB0 B,YF_MZCF00 C,YF_CFDL00 R,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F,BM_YPLB00 d,VW_YF_BRTZXX S
 WHERE C.YFBMBH+0=195
 AND C.FYRQ00>='20210901'
 AND C.FYRQ00<='20210901'
 AND (C.CFXZ00='0' or C.cfdgs0='1')
 AND C.GHKS00=M.BMBH00
 AND C.FHR000=G.YGBH00(+)
 AND C.BRID00=B.BRID00
 AND C.BRID00=F.BRID00
 AND C.GHH000=F.GHH000
 AND C.CFLSH0=R.CFLSH0(+)
 AND C.FYR000=H.YGBH00(+)
 AND c.YPDLBH=d.lbbh00
 AND C.GHH000=S.GHH000
 AND C.BRID00=S.BRID00
 and C.SFKSLY='N' 
 and not exists (select 1 from YF_CFDPB0  where cflsh0=c.cflsh0)   ORDER by  dbms_random.value ,nvl(C.BCCFH0,C.CFLSH0),C.CFLSH0)   where rownum <= 20

6       14:13:26  SQL Error: ORACLE - ORA-00936: 缺失表达式

7       14:13:26  SQL Error: ORACLE - Unmapped SQL Error Code: 936
8       14:13:26  SQL Data In: ORACLE - Rows affected = 0