--组件清单工序说明字段数据升级
UPDATE T_POM_MANUSTOCKENTRY_A SET FOPERATIONDESC = (SELECT FNAME FROM T_MPDM_WORKPROCEDURE_L WHERE FID=T_POM_MANUSTOCKENTRY_A.FWORKPROCEDUREID AND FLOCALEID='ZH_CN') WHERE FWORKPROCEDUREID IN (SELECT FID FROM T_MPDM_WORKPROCEDURE_L WHERE FNAME<>null);
--组件清单变更单工序说明字段数据升级
UPDATE T_POM_XMANUSTOCKENTRY_A SET FOPERATIONDESC = (SELECT FNAME FROM T_MPDM_WORKPROCEDURE_L WHERE FID=T_POM_XMANUSTOCKENTRY_A.FWORKPROCEDUREID AND FLOCALEID='ZH_CN') WHERE FWORKPROCEDUREID IN (SELECT FID FROM T_MPDM_WORKPROCEDURE_L WHERE FNAME<>null);