-- Start of DDL Script for View SD_HOSPITAL.VW_ZS_DBZSJ0_ZYDZBL
-- Generated 07-九月-2021 09:08:37 from SD_HOSPITAL@FW2

CREATE OR REPLACE VIEW vw_zs_dbzsj0_zydzbl (
   count,
   xm0000,
   dbzbm0,
   dbzmc0,
   zyid00,
   zyh000,
   zdmc00,
   zdm000,
   jrbzbm,
   jrbzmc,
   sjryrq,
   sjcyrq,
   rycwh0,
   dqks00,
   brzt00,
   dqksmc,
   dbzfh0,
   sxysxm,
   zzysxm,
   zrysxm,
   dbzde0,
   ssczmc,
   dbzfy0 )
AS
select distinct '1' COUNT,
                A.XM0000,
                NVL(SF_dbzhq_jcbb_dzbl(a.zyid00,0),'未满足单病种') DBZBM0,
                NVL((select DBZMC0 from bm_dbzdeb b where b.dbzbm0=SF_dbzhq_jcbb_dzbl(a.zyid00,0) and rownum=1),'未满足单病种') DBZMC0,
                A.ZYID00,
                A.ZYH000,
              --  C.ZDMC00,
                SF_dbzhq_jcbb_dzbl(a.zyid00,2) ZDMC00,
               -- C.ZDM000,
                SF_dbzhq_jcbb_dzbl(a.zyid00,1) ZDM000,
                A.DBZBM0 JRBZBM,
                A.DBZMC0 JRBZMC,
                A.SJRYRQ,
                A.SJCYRQ,
                A.RYCWH0,
                A.DQKS00,
                A.BRZT00,
                (select BMMC00 from BM_BMBM00 where BMBH00 = A.DQKS00) DQKSMC,
                DECODE(A.dbzbm0,'',0,1) DBZFH0,
                A.SXYSXM,
                A.ZZYSXM,
                A.ZRYSXM,
                (select YBHDJE from BM_DBZDEB where DBZBM0=SF_dbzhq_jcbb_dzbl(a.zyid00,0)  and  rownum=1) DBZDE0,
                (select SSCZMC from BM_DBZDEB where DBZBM0=SF_dbzhq_jcbb_dzbl(a.zyid00,0)  and  rownum=1) SSCZMC,
                (select nvl(sum(HJJE00),0) ZJE000 from ZY_BRFY00 where ZYID00=a.ZYID00)  DBZFY0
  from ZY_BRXXB0 A
 where  
 case when A.BRZT00 like '2%' THEN '1' ELSE SF_dbzhq_jcbb_dzbl(a.zyid00,0) END <> case when A.BRZT00 like '2%' THEN '2' ELSE ' ' END
 AND EXISTS(SELECT 1 FROM ZS_BLXX01 WHERE ZYID00=A.ZYID00)
/


-- End of DDL Script for View SD_HOSPITAL.VW_ZS_DBZSJ0_ZYDZBL