insert into bq_zxdpzb (DM0000, MC0000, BQH000, SFYX00, YZLB00, SQL000, DMXID0, BZ0000, PLXH00, ZDYID0, MSQL00, DJLB00, CZY000, KPBTNR, FRXWJ0, PSQL00, SCEWM0, MSQLFZ, FRDATA, PYSM00, WBSM00, BBH000, PX0000, PSQL02, PSQL03, PXZD00, YYFFOP, YPMCOP, ZLXMOP, YPYZOP, CFBZ00, ZXDLB0, SFXSBS, ZXSQL0)
values ('1413', '中医护理执行单(1-9F)', '2403', '1', '1', 'select ZLXMJC,YZFW00,ZXRQ00,QYRQ00,QYSJ00,BQH000,PCMC00,YPYFMC,CH0000,XM0000,YZCLLB,YZNR00, YZNR01,ZXRQ01,ZXSJ00,CLBZ00,YZMXID,YZID00,ZYID00 from(select  ZLXMJC,YZFW00,ZXRQ00,QYRQ00,QYSJ00,BQH000,PCMC00,YPYFMC,CH0000,XM0000,YZCLLB,YZNR00, YZNR01,ZXRQ01,ZXSJ00,CLBZ00,YZMXID,YZID00,ZYID00
 from VW_BQ_YJYZZXDNEW_ZYYDHL_YPBSM0 t where  exists (
 select  1 from bq_zxdwhb v where t.ypnm00=v.zlxmid and v.dm0000=''1413''
 )union all
 select
distinct ''''ZLXMJC,YZFW00,ZXRQ00,QYRQ00,QYSJ00,BQH000,PCMC00,YPYFMC,CH0000,XM0000,YZCLLB,YPYFMC||'' ''||PCMC00 YZNR00,'''' YZNR01,ZXRQ01,''''AS ZXSJ00,CLBZ00,0 YZMXID,YZID00,ZYID00 
from VW_BQ_YPYZZXD_QXCF_7QTS2_BSM t where  exists (
select  1 from bq_zxdwhb v where T.yfid00=v.yfid00 and v.dm0000=''1413''
 ))T where 1=1', '', '', null, 0, 'select CLBZ00,
        YZFW00,
        T.BQH000,
        BQMC00,
        ZYID00,
        XM0000,
        ZYH000,
        CH0000,
        YZID00,
        ZXRQ01,
        zxrq00
   from (Select CLBZ00,
                YZFW00,
                BQH000,
                (select bmmc00 from bm_bmbm00 where bmbh00 = bqh000) bqmc00,
                ZYID00,
                xm0000,
                zyh000,
                ch0000,
                yzid00,
                zxrq01,
                zxrq00
           from VW_BQ_YJYZZXDNEW_ZYYDHL_YPBSM0 T1
          where exists (select 1
                   from bq_zxdwhb v
                  where T1.ypnm00 = v.zlxmid
                    and v.dm0000 = ''1413'')
         union all
         Select distinct CLBZ00,
                         YZFW00,
                         BQH000,
                         (select bmmc00 from bm_bmbm00 where bmbh00 = bqh000) bqmc00,
                         ZYID00,
                         xm0000,
                         zyh000,
                         ch0000,
                         yzid00,
                         zxrq01,
                         zxrq00
           from VW_BQ_YPYZZXD_QXCF_7QTS2_BSM T2
          where exists (select 1
                   from bq_zxdwhb v
                  where T2.yfid00 = v.yfid00
                    and v.dm0000 = ''1413'')) T
  WHERE 1 = 1', '0', 2, '', '中医护理执行单(1-9F).frx', 'select t.yzfw00,t.bqh000,t.clbz00,t.zxrq01,t.zxsj00,yzid00,yzmxid,zyid00,zxrq00,bq0000,ch0000,zyh000,xm0000,xb0000,nl0000,yznr00,bz0000,zyzd00,YPBSM0 from
(select t.yzfw00,t.bqh000,t.clbz00,t.zxrq01,t.zxsj00,t.yzid00,t.yzmxid,t.zyid00,t.zxrq00,(select bmmc00 from bm_bmbm00 where bmbh00 = t.bqh000) bq0000,CH0000,t.zyh000,k.xm0000,k.xb0000,sf_bq_csrqtonl(k.csrq00) nl0000, t.yznr00,T.BZ0000,sf_xt_getzyzd(k.zyid00) AS ZYZD00,YPBSM0
  from VW_BQ_YJYZZXDNEW_ZYYDHL_YPBSM0 t,zy_brxxb0 k where t.zyid00=k.zyid00
AND EXISTS (
 select  1 from bq_zxdwhb v where t.ypnm00=v.zlxmid and v.dm0000=''1413''
 )
union all
select distinct t.yzfw00,t.bqh000,clbz00, zxrq00 as zxrq01, ''''zxsj00,t.yzid00,0 yzmxid,t.zyid00,t.zxrq00,(select bmmc00 from bm_bmbm00 where bmbh00 = t.bqh000) bq0000,CH0000,
       t.zyh000,k.xm0000,k.xb0000,sf_bq_csrqtonl(k.csrq00) nl0000,
       t.ypyfmc||'' ''||t.pcmc00,T.BZ0000,sf_xt_getzyzd(k.zyid00) AS ZYZD00,YPBSM0
  from VW_BQ_YPYZZXD_QXCF_7QTS2_BSM t,zy_brxxb0 k where t.zyid00=k.zyid00
AND EXISTS (
 select  1 from bq_zxdwhb v where t.yfid00=v.yfid00 and v.dm0000=''1413''
 )) t where 1=1', '', 'CLBZ00,YZFW00,BQMC00,BQH000,xm0000,zyh000,ch0000,ZYID00,yzid00,zxrq01,zxrq00', '<BLOB>', 'zyhlzhd(1-9f)', 'kargrtu(1-9f)', '201504091653386149', '', '', '', 'decode(sf_xt_isnumber(CH0000), ''1'', to_number(CH0000), 0), CLBZ00,ZXRQ01,ZXSJ00,YZID00,YZMXID', 'IN', 'IN', 'IN', 'AND', 'N', '01', '', '');