📢 临时改数据处理小数点的问题

方法：

1、问产线还有几台没过，或者自己查对应工序

2、记录修改的记录，改一下时间

3、更换工单

4、更换物料

从这里查具体物料

UPDATE MES_MO_MTRL_LD SET REMAIN_QTY=DOSAGE*n,REMARK='upd_240723_remain_qty'
WHERE MTRL_LD_ID IN (
SELECT MTRL_LD_ID FROM 
(SELECT row_number() over(partition by mtrl_id order by created_date desc) rn,mml.* 
FROM MES_MO_MTRL_LD  mml 
WHERE MO_ID=(SELECT MO_ID FROM BS_MO 
WHERE MO_CODE='GD5201-202407020004-ZX') 
AND MTRL_ID=(SELECT MTRL_ID FROM BS_MTRL WHERE MTRL_CODE='4020-01302019'))  
where  rn=1
)

More info call： 18375066036