-- Start of DDL Script for View SD_HOSPITAL.VW_ZS_HZKSML_ZYDZBL
-- Generated 27-十月-2025 14:49:11 from SD_HOSPITAL@YLZHIS_NEW

CREATE OR REPLACE VIEW vw_zs_hzksml_zydzbl (
   bmbh00,
   bh0000,
   flag00,
   bmmc00,
   pysm00,
   wbsm00,
   bmxz00,
   fybz00,
   sycw00,
   yjxx00,
   ckxx00,
   jzxx00,
   czbz00,
   yyid00,
   ksdh00,
   xzghlb,
   zxwxts,
   pxxh00,
   sficu0,
   kfcw00,
   sbksid,
   qfsx00,
   chqz00,
   sfwkks,
   zjfz00,
   ksflbh,
   sfqtxs,
   yyksbm,
   dymzks,
   dyzyks,
   bktszx,
   whksid,
   whksmc,
   zbcw00,
   bmlx00 )
AS
select BMBH00,
       BH0000,
       FLAG00,
       BMMC00,
       PYSM00,
       WBSM00,
       BMXZ00,
       FYBZ00,
       SYCW00,
       YJXX00,
       CKXX00,
       JZXX00,
       CZBZ00,
       YYID00,
       KSDH00,
       XZGHLB,
       ZXWXTS,
       PXXH00,
       SFICU0,
       KFCW00,
       SBKSID,
       QFSX00,
       CHQZ00,
       SFWKKS,
       ZJFZ00,
       KSFLBH,
       SFQTXS,
       YYKSBM,
       DYMZKS,
       DYZYKS,
       BKTSZX,
       WHKSID,
       WHKSMC,
       ZBCW00,
       decode(BMXZ00, '0', '病区', '1', '门诊', 'h', '介入室') BMLX00
  from BM_BMBM00 a
 where --(BMXZ00 in ('0', '1', 'h') and FLAG00 = '1' and CZBZ00 <> '2' and bmbh00 not in ('2216','2141','10635','10633' )) or
    exists (select 1 from bm_tyzd00 where bh0000 = a.bmbh00 and zdmc00 = '会诊科室') and FLAG00 = '1' and CZBZ00 <> '2'
 order by bmxz00
/


-- End of DDL Script for View SD_HOSPITAL.VW_ZS_HZKSML_ZYDZBL