CREATE OR REPLACE VIEW SD_HOSPITAL.VW_BQ_ZYHLXMCX_FY
 (
 ZYH000, ZYID00, DJH000, XMMC00, CZRQ00, KZYS00, XMSL00, HJJE00, BRXM00, 
XB0000, BRNL00, KZYSXM, ZDMC00, BZ0000, KDBQ00

 )
 AS 
select  d.ZYH000,      --住院号
        d.ZYID00,       --住院ID
        a.DJH000,             --单据号
        a.XMMC00,             --项目名称
        a.CZRQ00,             --医嘱启用日期
        a.KDYS00,             --开医嘱医生
        a.XMSL00,      --数量
        a.HJJE00,     --金额
        d.XM0000 BRXM00 ,            --病人姓名
        d.XB0000,             --性别
        SF_ZS_CSRQTONL(d.CSRQ00) BRNL00,  --病人年龄
        (select ZWXM00 from BM_YGBM00 where YGBH00=a.KDYS00) kzysxm ,  --开嘱医生姓名
        SF_ZS_LJ_RYZDMC(d.zyid00,'c',0) ZDMC00, --诊断名称
        ' ' BZ0000,
        a.KDBQ00
  from  ZY_FYMX00 a,ZY_BRFY00 b,ZY_BRXXB0 d where  a.DJH000=b.DJH000 and b.ZYID00=d.ZYID00  
        and exists(select 1 from BM_YYSFXM where SFXMID=a.XMBH00 and FLAG00='1' and bh0000 like '04%' and BH0000 not like '040%' and BH0000 not like '048%' )
/