CREATE VIEW SD_HOSPITAL.VW_PY_XSPPDJH_X
 (
 BRXM00, BRXM01, FYCKBH, FYDLXH, YFBMBH, ZT0000, JHCS00, JHSJ00, BRID00

 )
 AS 
select
      distinct
       BRXM00 BRXM00,
       substr(SF_XT_GETPDJHBRXM(BRXM00,'0'),1,20) BRXM01,
       substr((select CKMC00 from bm_ckbm00 where CKBH00=y.FYCKBH),1,1) FYCKBH,
       FYDLXH,
       YFBMBH,
       ZT0000,
       JHCS00,
       --(select  ZWXM00 from bm_ygbm00 a where (select CZY000 from BM_CKBM00 where CKBH00=y.FYCKBH)=a.ygbh00) Jhczy0
       decode(y.jhcs00,1,'',(SELECT MAX(JHSJ00) FROM YF_CFDL00 WHERE BRID00=Y.BRID00)) JHSJ00,
       BRID00
   from YF_CFDL00 y
  where DYRQ00=to_char(sysdate,'YYYYMMDD') and y.ZT0000 in ('2') and FYCKBH>0 GROUP BY BRXM00, FYCKBH, FYDLXH, YFBMBH, ZT0000, JHCS00,BRID00
/