CREATE OR REPLACE VIEW SD_HOSPITAL.VW_MZHS_YYHZDDY
 (
 YYID00, JZID00, GHHBID, YYH000, BRID00, BRXM00, BRDH00, KMH000, ICKH00, 
YYKSBH, YYKSMC, YYYSBH, YYYSXM, YYLB00, YYRQ00, YYJSSJ, YYZT00, YYYGBH, 
YYYGXM, DJH000, GHLB00, DJRQ00, DJSJ00, QXRQ00, QXSJ00, BZ0000, CZYBM0, 
GHID00, WLYYID, GHCJ00, SFZH00, QXR000, HZDYCS, CKMC00, DDRS00, HZXH00, 
YYRQGS, YYSD00, CKXXDZ

 )
 AS 
select a.YYID00, a.JZID00, a.GHHBID, a.YYH000, a.BRID00, a.BRXM00, a.BRDH00, a.KMH000, a.ICKH00,
       a.YYKSBH, a.YYKSMC, a.YYYSBH, a.YYYSXM, a.YYLB00, a.YYRQ00, a.YYJSSJ, a.YYZT00, a.YYYGBH,
       a.YYYGXM, a.DJH000, a.GHLB00, a.DJRQ00, a.DJSJ00, a.QXRQ00, a.QXSJ00, a.BZ0000, a.CZYBM0,
       GHID00, WLYYID, GHCJ00, SFZH00, QXR000, HZDYCS,
       (select c.ckmc00 from sf_ysghhb b,bm_ckbm00 c where b.ghhbid=a.ghhbid and b.ghhzck=c.ckbh00 and c.flag00='4') ckmc00,
       SF_MZHS_YYHZDDY_DDRS00(a.GHHBID,a.YYRQ00,a.YYKSBH,a.YYYSBH,a.YYH000) DDRS00,
       a.YYH000 HZXH00,
       substr(a.YYRQ00,1,4)||'-'||substr(a.YYRQ00,5,2)||'-'||substr(a.YYRQ00,7,2) yyrqgs
       --,(select HZSJ00 from YS_HBHZXH where GHHBID=a.GHHBID and HZXH00=a.YYH000) yysd01
       ,substr(SF_MZHS_YYHZSD(a.YYJSSJ,(select GHJSSJ from SF_YSGHHB where GHHBID=a.GHHBID),
       (select HZSJ00 from YS_HBHZXH where GHHBID=a.GHHBID and HZXH00=a.YYH000)),1,20) YYSD00,
       (select b.ckxxdz from bm_ckbm00 b,sf_ysghhb c where b.ckbh00=c.ghhzck and c.ghhbid=a.ghhbid) CKXXDZ
  from SF_YYBRB0 a
/