create or replace view vw_zs_zlzd00_dzbl as
select z.ZLXMID,z.ZLXMBH,z.LBBZ00,z.FBZXBZ,z.ZLXMJC,z.GDXMBZ,z.JGDW00,z.CKZ000,z.DW0000,
       z.WBSM00,z.PYSM00,z.LBBH00,z.XXMS00,z.BZ0000,z.QYRQ00,z.TZRQ00,z.SFYXSQ,z.ZXKS00,
       z.DLBQZX,z.DLKSZX,z.BQSFBZ,z.BQDYBZ,z.BBID00,z.SSDJBH,z.CM3000,z.ZYZBID,a.sfje00,
       (select t.bbmc00 from BM_BBZD00 t where t.bbid00=z.bbid00)bbmc00
from   BM_ZLZD00 z, VW_ZS_ZLXMSF_NEW_ZYDZBL a
where  z.zlxmid=a.zlxmid(+) and  z.sfyxsq='Y' and z.zlxmid>100  and z.tzrq00  is null
       and nvl(z.tzrq00,to_char(sysdate-1,'yyyymmdd'))<to_char(sysdate,'yyyymmdd')
       and nvl(z.qyrq00,to_char(sysdate+1,'yyyymmdd'))<=to_char(sysdate,'yyyymmdd');