PROMPT 20. ÓÐЧÕïÁÆ×Öµä(VW_ZS_ZLZD00)
CREATE OR REPLACE VIEW VW_ZS_ZLZD00
 (
 ZLXMID, ZLXMBH, LBBZ00, FBZXBZ, ZLXMJC, GDXMBZ, JGDW00, CKZ000, DW0000, 
WBSM00, PYSM00, LBBH00, XXMS00, BZ0000, QYRQ00, TZRQ00, SFYXSQ, ZXKS00, 
DLBQZX, DLKSZX, BQSFBZ, BQDYBZ, BBID00, SSDJBH, CM3000, ZYZBID, SFJE00
 )
 AS 
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- chenqw      20090209    VW_ZS_zlxmsf»»ÎªVW_ZS_zlxmsf_NEW 
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

from   bm_zlzd00 z, VW_ZS_zlxmsf_NEW a  
where  z.zlxmid=a.zlxmid(+) and  z.sfyxsq='Y' and z.zlxmid>100
       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')
/
--modify end.