create or replace view vw_bq_ysfwzx as
select YJDJH0,
       ZLXMJC,
       to_char(SL0000) || DW0000 SL0000STR,
       ZJE000,
       BMMC00,
       YEXM00,
       KDYSXM,
       TO_DATE(KDRQ00 || KDSJ00, 'yyyymmddhh24:mi:ss') KDRQSJ,
       DECODE(XMZT00, '2', '已收费','3','已执行', '已收费') XMZT00,
       CXDJH0,
       KDBQ00,
       ZYGHID,
       BZ0000
  FROM BM_BMBM00 B, YJ_YW0000 Y
 where Y.MZZYBZ = '1'
   and ((exists(select 1 from XT_XTCS00 where NAME00='BQ_YSFWZXSFBXSYZXXM' and VALUE0='Y') and  Y.XMZT00='2') or (not exists(select 1 from XT_XTCS00 where NAME00='BQ_YSFWZXSFBXSYZXXM' and VALUE0='Y') and  Y.XMZT00 in('2','3')))
   and Y.cxdjh0 is  null
   AND Y.YJKSBH = B.BMBH00
   AND y.ZLXMID in (select ZLXMID from  BM_ZLZD00 where LBBH00 = '4')
   and nvl(CXDJH0, 0) = 0
   AND YJLRBZ = 'N'
   and not exists (select 1
          from YJ_YW0000
         where CXDJH0 = y.YJDJH0
           and ZYGHID = y.ZYGHID
           and MZZYBZ = y.MZZYBZ)
 order by KDRQ00;