modify_cre_views.sql

公务员管理系统

/*修改货币类型*/
create or replace view v_dw_xx as
select  a.dwid dwid,a.dwmc dwmc,a.dwlb dwlb,dp_sys.f_get_mc_by_dm('1001',a.dwlb) lbmc,a.hblx
			 ,a.qx qx,dp_sys.f_get_mc_by_dm('0001',a.qx) qxmc,a.jyjd jd,dp_sys.f_get_mc_by_dm('0002',a.jyjd) jdmc
			 ,a.dbr dbr,a.dwxz dwxz,dp_sys.f_get_mc_by_dm('1002',a.dwxz) dwxzmc,a.zczj zczj
			 ,b.cyrs cyrs,c.jccs jccs,d.ajsl ajsl,decode(d.ajsl,0,'02',null,'02','01') sfyaj
			 ,a.blrq djsj,dp_sys.to_chn_date(a.blrq,'ymd') djsjmc
			 ,e.jbsl,e.zdxcsl,e.zxxcsl,e.njsl,f.xzcl,f.zlgz,f.xzcf,f.qzzx
  from dw_xx a,v_dwcyrs b,v_dwjccs c,v_dwajsl d,v_dwtjcs e,v_dwclqksl f
 where a.dwid = b.dwid(+) and a.dwid = c.dwid(+) and a.dwid = d.dwid(+) and a.dwid = e.dwid(+) and a.dwid = f.dwid(+) and a.flag <> '03'
/