CREATE VIEW "nl_jc_bjcz_view" AS  SELECT d.rownum,
    d.bsm,
    d.xzqhdm,
    d.bjbh,
    d.czzt,
    d.czsj,
    d.cznr,
    d.czbg,
    d.jlry,
    d.gxsj,
    d.bz,
    d.yskzjbz,
    d.sjtbzt,
    d.tbsj,
    d.czjg,
    d.xcpcry,
    d.xcpcrylxdh,
    d.czfa,
    d.ksczsj,
    d.wcczsj,
    d.xctpspwj
   FROM ( SELECT row_number() OVER (PARTITION BY nl_jc_bjcz.bsm ORDER BY nl_jc_bjcz.tbsj DESC) AS rownum,
            nl_jc_bjcz.bsm,
            nl_jc_bjcz.xzqhdm,
            nl_jc_bjcz.bjbh,
            nl_jc_bjcz.czzt,
            nl_jc_bjcz.czsj,
            nl_jc_bjcz.cznr,
            nl_jc_bjcz.czbg,
            nl_jc_bjcz.jlry,
            nl_jc_bjcz.gxsj,
            nl_jc_bjcz.bz,
            nl_jc_bjcz.yskzjbz,
            nl_jc_bjcz.sjtbzt,
            nl_jc_bjcz.tbsj,
            nl_jc_bjcz.czjg,
            nl_jc_bjcz.xcpcry,
            nl_jc_bjcz.xcpcrylxdh,
            nl_jc_bjcz.czfa,
            nl_jc_bjcz.ksczsj,
            nl_jc_bjcz.wcczsj,
            nl_jc_bjcz.xctpspwj
           FROM ztfbk_sjg.nl_jc_bjcz) d
  WHERE d.rownum = 1;
ALTER TABLE "nl_jc_bjcz_view" OWNER TO "adq_sjg";

CREATE VIEW "nl_jc_bjfx_view" AS  SELECT d.rownum,
    d.bsm,
    d.bjbh,
    d.bjdwwz,
    d.xcpcry,
    d.xcpcrylxdh,
    d.ddxcsj,
    d.xczkms,
    d.zsry,
    d.zsrylxdh,
    d.zsrydw,
    d.zsryfxjs,
    d.xcryfxbg,
    d.zsryfxsj,
    d.fxnr,
    d.xctpspwj,
    d.gxsj,
    d.bz,
    d.yskzjbz,
    d.sjtbzt,
    d.tbsj,
    d.bjsfwb
   FROM ( SELECT row_number() OVER (PARTITION BY nl_jc_bjfx.bsm ORDER BY nl_jc_bjfx.tbsj DESC) AS rownum,
            nl_jc_bjfx.bsm,
            nl_jc_bjfx.bjbh,
            nl_jc_bjfx.bjdwwz,
            nl_jc_bjfx.xcpcry,
            nl_jc_bjfx.xcpcrylxdh,
            nl_jc_bjfx.ddxcsj,
            nl_jc_bjfx.xczkms,
            nl_jc_bjfx.zsry,
            nl_jc_bjfx.zsrylxdh,
            nl_jc_bjfx.zsrydw,
            nl_jc_bjfx.zsryfxjs,
            nl_jc_bjfx.xcryfxbg,
            nl_jc_bjfx.zsryfxsj,
            nl_jc_bjfx.fxnr,
            nl_jc_bjfx.xctpspwj,
            nl_jc_bjfx.gxsj,
            nl_jc_bjfx.bz,
            nl_jc_bjfx.yskzjbz,
            nl_jc_bjfx.sjtbzt,
            nl_jc_bjfx.tbsj,
            nl_jc_bjfx.bjsfwb
           FROM ztfbk_sjg.nl_jc_bjfx) d
  WHERE d.rownum = 1;
ALTER TABLE "nl_jc_bjfx_view" OWNER TO "adq_sjg";

CREATE VIEW "nl_jc_jcbj_view" AS  SELECT d.rownum,
    d.bsm,
    d.bjmc,
    d.bjbh,
    d.dwbsm,
    d.sbbsm,
    d.jcbjzb,
    d.dqbjjb,
    d.ccbjsj,
    d.ccbjz,
    d.dqbjsj,
    d.dqbjz,
    d.ljbjpc,
    d.bjsfjc,
    d.bjjcsj,
    d.bjjcsm,
    d.bz,
    d.yskzjbz,
    d.sjtbzt,
    d.tbsj,
    d.bjjb,
    d.bjsj,
    d.bjz,
    d.qxyjqhmc,
    d.bjyz
   FROM ( SELECT row_number() OVER (PARTITION BY nl_jc_jcbj.bsm ORDER BY nl_jc_jcbj.tbsj DESC) AS rownum,
            nl_jc_jcbj.bsm,
            nl_jc_jcbj.bjmc,
            nl_jc_jcbj.bjbh,
            nl_jc_jcbj.dwbsm,
            nl_jc_jcbj.sbbsm,
            nl_jc_jcbj.jcbjzb,
            nl_jc_jcbj.dqbjjb,
            nl_jc_jcbj.ccbjsj,
            nl_jc_jcbj.ccbjz,
            nl_jc_jcbj.dqbjsj,
            nl_jc_jcbj.dqbjz,
            nl_jc_jcbj.ljbjpc,
            nl_jc_jcbj.bjsfjc,
            nl_jc_jcbj.bjjcsj,
            nl_jc_jcbj.bjjcsm,
            nl_jc_jcbj.bz,
            nl_jc_jcbj.yskzjbz,
            nl_jc_jcbj.sjtbzt,
            nl_jc_jcbj.tbsj,
            nl_jc_jcbj.bjjb,
            nl_jc_jcbj.bjsj,
            nl_jc_jcbj.bjz,
            nl_jc_jcbj.qxyjqhmc,
            nl_jc_jcbj.bjyz
           FROM ztfbk_sjg.nl_jc_jcbj) d
  WHERE d.rownum = 1;
ALTER TABLE "nl_jc_jcbj_view" OWNER TO "adq_sjg";