日期:2014-05-17 浏览次数:21205 次
case when nvl(pa_ptm,'0')='0' then v_invptm else to_date(pa_ptm,'yyyy/MM/dd HH24:mi:ss') end
insert into businv(
invid,invoid,invlln,invpki,invown,invownnam,invdpt,
invlot,invrmk,invrtm,invatm,invstm,
invsku,invdes,invqty,invant,invcan,
invlck,invloc,invunt,invvor,invwgt,
invlpn,invsze,invlor,invatr,invtyp,
invsty,invytm,invstp,invpkg,invscn,
invscd,invtlc,invwhs,invwhsnam,
invcon,invlocnam,invptm)
values(s_businv.nextval,v_newinvoid,v_invlln,v_invpki,v_invown,v_invownnam,v_invdpt,
case when nvl(pa_lot,'0')='0' then v_invlot else pa_lot end,--批次
case when nvl(pa_rmk,'0')='0' then v_invrmk else pa_rmk end,--备注
case when nvl(pa_rtm,'0')='0' then v_invrtm else to_date(pa_rtm,'yyyy/MM/dd HH24:mi:ss') end,--收货时间
case when nvl(pa_atm,'0')='0' then v_invatm else to_date(pa_atm,'yyyy/MM/dd HH24:mi: