----首营审批表  单号：SYPZ2018062100000013   申请人改为：王彩玲00640，申请部门改为：计划组0902。
update gsp_syyp_148 p set  p.vproposer='0001Q910000000005RPV' ,p.pk_reqdept='1001Q91000000000032V' ,
       p.pk_reqdept_v ='0001Q910000000003248' where p.vbillcode='SYPZ2018062100000013'
       
---首营审批表 审批人改为：刘秀兰    
update gsp_syyp_148 p set p.approver='1001Q910000000009QSC' where  p.vbillcode in ('SYPZ2018061500000010','SYPZ2018062500000015')
--select p.approver from gsp_syyp_148 p where p.vbillcode in ('SYPZ2018061500000010','SYPZ2018062500000015')
--1001Q910000000001Y8V
--select * from sm_user r where r.user_name ='刘秀兰'
--1001Q910000000009QSC

---药品退货入库质量单  ，将验收员，创建人，制单人，审批人改为  张雪峰
--查询
/*select k.vbillcode,k.vbillmaker,k.creator,k.approver from gsp_incheck_148 k where nvl(k.dr,0)=0 and k.vbillcode in ('XTYS2018042400000032',
'XTYS2018042400000033','XTYS2018042400000034','XTYS2018042400000035','XTYS2018042800000095','XTYS2018042800000096',
'XTYS2018042800000097','XTYS2018050300000110','XTYS2018050300000111','XTYS2018050300000112',
'XTYS2018050300000113','XTYS2018050300000114','XTYS2018050300000115')*/
-- 1001Q9100000000083XM
--select * from sm_user r where r.user_name ='张雪峰'
--1001Q910000000001YAC
update gsp_incheck_148 k set k.vbillmaker='1001Q910000000001YAC',k.creator='1001Q910000000001YAC',k.approver ='1001Q910000000001YAC'
where nvl(k.dr,0)=0 and k.vbillcode in ('XTYS2018042400000032',
'XTYS2018042400000033','XTYS2018042400000034','XTYS2018042400000035','XTYS2018042800000095','XTYS2018042800000096',
'XTYS2018042800000097','XTYS2018050300000110','XTYS2018050300000111','XTYS2018050300000112',
'XTYS2018050300000113','XTYS2018050300000114','XTYS2018050300000115');

---查询
/*select kb.ccheckmanid from gsp_incheck_b_148 kb where nvl(kb.dr,0)=0 and kb.pk_incheck in (
select k.pk_incheck from gsp_incheck_148 k where nvl(k.dr,0)=0 and k.vbillcode in ('XTYS2018042400000032','XTYS2018042400000033',
'XTYS2018042400000034','XTYS2018042400000035','XTYS2018042800000095','XTYS2018042800000096',
'XTYS2018042800000097','XTYS2018050300000110','XTYS2018050300000111','XTYS2018050300000112',
'XTYS2018050300000113','XTYS2018050300000114','XTYS2018050300000115')
)*/
---0001Q910000000005BRA 
--select * from bd_psndoc dc where  dc.name ='白秀杰'
--0001Q910000000005RPP  0001Q910000000005BRA

update gsp_incheck_b_148 kb set kb.ccheckmanid='0001Q910000000005RPP' 
where nvl(kb.dr,0)=0 and kb.pk_incheck in (
select k.pk_incheck from gsp_incheck_148 k where nvl(k.dr,0)=0 and k.vbillcode in ('XTYS2018042400000032','XTYS2018042400000033',
'XTYS2018042400000034','XTYS2018042400000035','XTYS2018042800000095','XTYS2018042800000096',
'XTYS2018042800000097','XTYS2018050300000110','XTYS2018050300000111','XTYS2018050300000112',
'XTYS2018050300000113','XTYS2018050300000114','XTYS2018050300000115')
)