SELECT * FROM CPS.MTL_UPH WHERE MTL_NO LIKE '70200312%'
INSERT INTO CPS.PRODUCT_INFO
SELECT '70200312A2',DEPT_ID,MTL_MODEL,MTL_CUST,MTL_SET,SET_NO,0,0,GETDATE(),GETDATE()
FROM CPS.PRODUCT_INFO WHERE MTL_NO='70200312A0'
INSERT INTO CPS.PRODUCT_PROCE
SELECT '70200312A2',SEQ_NO,PROCE_NO,SEQ_DESC,STATUS_NO,0,0,GETDATE(),GETDATE()
FROM CPS.PRODUCT_PROCE WHERE MTL_NO='70200312A0'
INSERT INTO CPS.PRODUCT_EQUIP
SELECT '70200312A2',SEQ_NO,TYPE_NO,CAV_QTY,CT_TIME,INSD_CNT,OUSD_CNT,START_DATE,END_DATE,OPT_STATION,0,0,GETDATE(),GETDATE()
FROM CPS.PRODUCT_EQUIP WHERE MTL_NO='70200312A0'