亨泰光學_MES復原案

1. btox.erp_info 增加欄位 nominal_add decimal(19,2) nullable

2. dbo.capte 增加一筆資料
   INSERT INTO [dbo].[capte]
   ([apteid],[apcls],[des],[update_dt],[update_uid],[create_dt])
   VALUES
   (5, '','CP2',GETDATE(),-1,GETDATE())

3. 新增 sp_app_cp2_measurement_get

4. 更新標準途程 APP type
   UPDATE [dbo].[mdo]
   SET
   apteid = 5
   WHERE
   mdoid IN (SELECT mdoid FROM dbo.mdoinsp WHERE eqpid = 38)

5. 更新工單途程 APP type
   UPDATE [dbo].[mpo]
   SET
   apteid = 5
   WHERE
   mpoid IN (SELECT mpoid FROM dbo.mpoinsp WHERE eqpid = 38)

測試用 只改一張單的工單途程
UPDATE [dbo].[mpo]
SET
apteid = 5
WHERE
mpoid IN (SELECT mpoid FROM dbo.mpoinsp WHERE eqpid = 38) AND
mpcid IN (SELECT mpcid FROM dbo.mpc WHERE rcid IN (SELECT runcard_id FROM btox.erp_info WHERE runcard_no = ''))

調整 sp_web_ct_sheet_type_list
調整 sp_web_equip_create