create or replace view vw_bq13_yjyw00_fjf as
select b."YJDJH0", b."YJFZH0", b."BRID00", b."ZYGHID", b."ZYHGHH", b."MZZYBZ", b."BRXM00", b."XB0000", b."CSRQ00", b."YEXM00", b."ZLXMID", a.XMMC00 "ZLXMJC", b."SL0000", b."ZXSL00", b."DW0000", b."YJKSBH", b."KDYS00", b."KDYSXM", b."KDKSBH", b."YSSZKS", b."KDRQ00", b."KDSJ00", b."LRXM00", b."JZBZ00", b."FBZXBZ", b."BWMC00", b."APRXM0", b."APRQ00", b."APSJ00", b."JGLR00", b."ZXR000", b."ZXRXM0", b."ZXRQ00", b."ZXSJ00", b."ZDID00", b."ZDMC00", b."JGBGRQ", b."JGBGYS", b."BGYSXM", b."XMZT00", b."SFDJH0", b."YZCFID", b."YPNM00", b."DCBZ00", b."TQPC00", b."CXDJH0", b."ZJE000", b."BZ0000", b."YJLRBZ", b."KDBQ00", b."JGZCBZ", b."BQSFBZ", b."CH0000", b."NL0000", b."ZLDCCF", b."SM0000", b."JZQRR0", b."JZQRRQ", b."JZQRSJ", b."ZHXMID", b."YJDJDY", b."BBID00", b."CFID00", b."MC0000", b."BH0000", b."CXSL00", b."TXM000", b."DYRQTM", b."DYSJTM", b."JCQZY0", b."SQID00", b."QSPC00", b."QSRQ00", b."QSSJ00", b."QSR000", b."QSRXM0", b."ZSDYMC", b."TSBSMC", b."LRY000", b."BBBZ00", b."DYBGRQ", b."SYLSH0", b."SMKSBH", b."ZXYS00", b."CJKSBH", b."YYID00", b."FJDJBZ", b."SFXYSH", b."SHZT00", b."ZHJE00", b."DWZBID", b."JKZT00", b."DQKS00", b."YSZID0", a.yzid00, a.tqdjh0
          from bq_fjf000 a, yj_yw0000 b
         where --a.id0000 = b.cfid00
         to_char(a.id0000)= b.cfid00
           and a.zyid00 = b.zyghid
           and b.fjdjbz = 'e'
           and b.mzzybz = '1'
              -- and a.yzid00 = 20970
              --and a.tqdjh0 = ?
              --and zyid00 = ?
           and b.sfdjh0 > 0
           and not exists (select 1
                  from yj_yw0000
                 where cxdjh0 = b.yjdjh0
                   and zyghid = b.zyghid
                   and mzzybz = '1');