坯料从履历表取数据

insert into TMMBWSM01
SELECT REC_CREATOR,
REC_CREATE_TIME,
REC_REVISOR,
REC_REVISE_TIME,
REC_ERASOR,
REC_ERASE_TIME,
ARCHIVE_FLAG,
ARCHIVE_STAMP_NO,
COMPANY_CODE,
COMPANY_NAME,
MAT_NO,
MAT_ID,
MAT_LINE_TYPE,
MAT_KIND,
UNIT_CODE,
NEXT_UNIT_CODE,
FACTORY_DIV,
FACTORY_STORE,
FACTORY_PROD,
SYS_CODE,
MAT_SHAPE_FLAG,
ORIGIN_MAT_NO,
RAW_ORIGIN,
MAT_ORIGIN,
MAT_ORIGIN_DETAIL,
PRODUCT_FLAG,
MAT_STATUS,
CUST_MAT_STATUS,
MAT_THICK,
MAT_WIDTH,
MAT_LEN,
MAT_ACT_THICK,
MAT_ACT_WIDTH,
MAT_ACT_LEN,
MAT_TARG_THICK,
MAT_TARG_WIDTH,
MAT_TARG_LEN,
MAT_NUM,
MAT_NUM_CUT,
MAT_WT,
MAT_ACT_WT,
MAT_THEORY_WT,
MEASURE_WT_FLAG,
PRODUCT_PACK_FLAG,
PACK_TYPE_CODE,
PACK_MAT_WT,
PONO,
HEAT_NO,
ST_NO,
PROD_MAKER,
PROD_TIME,
PROD_SHIFT_NO,
PROD_SHIFT_GROUP,
PRIM_SHEET_CODE,
PROD_CLASS_CODE,
PROD_CODE,
SG_CODE,
STD_SG_CODE,
SG_SIGN,
SG_STD,
SIGN_CODE,
OLD_STD_SG_CODE,
OLD_SG_SIGN,
OLD_SG_STD,
OLD_SIGN_CODE,
MAT_TRACK_NO,
PASS_BACKLOG_SEQ_NO,
WHOLE_BACKLOG_ACT,
PASSED_UNIT_CODE,
MAT_DESTION,
MAT_MATCH_FLAG,
RETURN_MAT_FLAG,
RETURN_MAT_ORIGIN,
RETURN_MAT_CAUSE_CODE,
RETURN_MAT_TIME,
RETURN_MAT_MAKER,
MANAGE_FLAG,
ORDER_NO,
OLD_ORDER_NO,
FIN_CUST_CODE,
WHOLE_BACKLOG_NO,
WHOLE_BACKLOG,
WHOLE_BACKLOG_SEQ,
WHOLE_BACKLOG_CODE,
NEXT_WHOLE_BACKLOG_SEQ,
NEXT_WHOLE_BACKLOG_CODE,
MSC,
OLD_MSC,
MSC_LINE_NO,
OLD_MSC_LINE,
PSC,
OLD_PSC,
APN,
OLD_APN,
WKM,
OLD_WKM,
CONFM_FLAG,
CONFM_PLAN_NO,
CONFM_TIME,
CONFM_REJECT_CAUSE,
APP_DECIDE_FLAG,
TRANSFER_FLAG,
TRANSFER_PLAN_NO,
TRANSFER_REJECT_CAUSE,
PROD_READY_DATE,
BILL_OF_LADING_NO,
COME_PROC_AGREE_NO,
COMBINE_FLAG,
MERG_MAT_NO,
MERGE_FLAG,
HOLD_FLAG,
MNG_HOLD_CAUSE_CODE,
MNG_HOLD_TIME,
MNG_HOLD_MAKER,
MNG_HOLD_REMARK,
HOLD_CAUSE_CODE,
HOLD_TIME,
HOLD_MAKER,
HOLD_REMARK,
REL_TIME,
REL_MAKER,
REL_REMARK,
REMAIN_CAUSE_CODE,
REMAIN_DECIDE_TIME,
REMAIN_DECIDE_MAKER,
REMAIN_DECIDE_CODE,
REMAIN_REMARK,
DROP_LEVEL_TYPE,
DROP_LEVEL_CAUSE_CODE,
DROP_LEVEL_REMARK,
SCRAP_CAUSE_CODE,
SCRAP_MAKER,
SCRAP_TIME,
SCRAP_REMARK,
SURFACE_DECIDE_CODE,
SURFACE_DECIDE_TIME,
SURFACE_DECIDE_MAKER,
PCH_JUDGE_CODE,
PCH_JUDGE_RESULT,
PCH_JUDGE_ABN,
PCH_JUDGE_TIME,
PCH_JUDGE_MAKER,
COMPLEX_DECIDE_CODE,
COMPLEX_DECIDE_TIME,
COMPLEX_DECIDE_MAKER,
OLD_COMPLEX_DECIDE_CODE,
OLD_COMPLEX_DECIDE_TIME,
OLD_COMPLEX_DECIDE_MAKER,
REPAIR_FLAG,
REPAIR_REMARK,
REPAIR_BACKLOG_CODE,
SAMPLE_LOT_NO,
NEW_TEST_NO,
DEFECT_CODE,
DEFECT_CLASS,
TECH_NOTE_NO,
PLAN_NO,
IN_FLAG,
IN_STOCK_TIME,
OUT_STOCK_TIME,
STOCK_OPER_ORDER,
AIM_STORE,
STOCK_NO,
LOGIC_STOCK_NO,
STOCK_PLACE_NO,
FIELDNO,
HALL_NO,
ROWNO,
COLUMN_NO,
LAYERNO,
STOCK_PLACE_POSITION,
STORE_AREA,
CMD_FLAG,
OLD_STOCK_NO,
OLD_LOGIC_STOCK_NO,
OLD_STOCK_PLACE_NO,
OLD_HALL_NO,
OLD_ROWNO,
OLD_COLUMN_NO,
OLD_LAYERNO,
OLD_STOCK_PLACE_POSITION,
VEHICLE_NO,
TRUCK_NO,
TRUCK_LAYER_NO,
LOAD_NUM,
TRANSFER_BILL_NO,
LOGISTICS_STATUS,
PRODUCT_CODE,
PROD_CONFM,
PROD_CONFM_TIME,
PROD_CONFM_WT,
PREC_SLAB_NO,
PREC_ST_NO,
DECI_ST_NO,
JUDGE_ST_NO,
CUT_ST_NO,
FIN_ST_NO,
JUDGE_TIME,
JUDGE_MAKER,
SLAB_CUT_TIME,
HSF_END_TIME,
TAP_START_TIME,
CAST_NO,
CAST_DIV_NO,
REFINE_ROUTE_CODE,
HOT_CHARGE_FLAG,
HOT_SEND_FLAG,
OUT_SM_STOCK_TIME,
SLABTOP_FLAG,
SLABTOP_TIME,
SLAB_COLD_HOT_FLAG,
MACH_CLEAR_FLAG,
HAND_CLEAR_GRADE,
HEAT_GRADE,
QUALITY_GRADE,
SLAT_UNLADE_CAUSE,
RETURN_FLAG,
SLAB_RETURN_CAUSE_CODE,
SLAB_RETURN_TIME,
FINISH_FLAG,
IC_CC_FLAG,
INGOT_CODE,
MAT_NO_OLD,
OLD_HEAT_NO,
OLD_PONO,
IN_MAT_NO,
SLAB_PLACE_CODE,
STRAND_NO,
COOL_FLAG,
ABNR_CODE_1,
ABNR_CODE_2,
ABNR_CODE_3,
ABNR_CODE_4,
MAT_RETURN_FLAG,
MAT_RETURN_MAKER,
MAT_RETURN_TIME,
ROLL_PLAN_NO,
IF_TRANSFER,
MEND_FLAG,
CON_SLAB_FLAG,
FIX_FLAG,
PSC_DESC,
BATCH_NO,
RHEAT_SLAB_FLAG,
PONO_SLAB,
CUST_MAT_STATUS_UPDATE_TIME,
INITIAL_ST_NO,
INITIAL_STD_SG_CODE,
INITIAL_SG_SIGN,
INITIAL_SG_STD,
INITIAL_SIGN_CODE,
INITIAL_ORDER_NO,
INITIAL_FIN_CUST_CODE,
INITIAL_MSC,
INITIAL_MSC_LINE_NO,
INITIAL_PSC,
INITIAL_APN,
INITIAL_WKM,
DEAL_NOTION,
TRNP_MODE_CODE,
CONCESS_CON_FLAG,
CONCESS_CON_LIST_FLAG,
IN_PLAN_FLAG,
ISE_RESULT,
ABNR_OCC_PLACE_1,
ABNR_OCC_PLACE_2,
ABNR_OCC_PLACE_3,
ABNR_OCC_PLACE_4,
ABNR_END_PLACE_1,
ABNR_END_PLACE_2,
ABNR_END_PLACE_3,
ABNR_END_PLACE_4,
SLAB_HEAT_CAUSE_CODE,
SLAB_HEAT_TIME,
ABN_DEAL_CODE1,
ABN_DEAL_CODE2,
ABN_DEAL_CODE3,
ABN_DEAL_CODE4,
ADJUST_WIDTH_MARK,
SLAB_HEAD_WIDTH,
SLAB_TAIL_WIDTH,
SLAB_TAPPER_WIDTH_START,
SLAB_TAPPER_WIDTH_LEN,
SLAB_PLACE_STD,
PRINT_NO,
CROSS_CODE,
LEN_FROM,
LEN_TO,
SAMPLE_LOT_NO_1,
SAMPLE_LOT_NO_2,
SAMPLE_LOT_NO_3,
SAMPLE_LOT_NO_4,
DEVO_INGOT_WT,
DEVO_FLAN_WT,
MAT_NUM_CONFM,
OLD_ST_NO,
CLD_TIME,
STEEL_GROUP,
DEST_FIN,
CC_NO,
LSLAB_NO,
IF_MIX_POUR,
TRNP_BILL_NO,
STOCK_REMARK,
MERG_FLAG,
ANNEAL_FLAG,
RL_NO,
SPARE_ITEM_0,
SPARE_ITEM_1,
SPARE_ITEM_2,
SPARE_ITEM_3,
SPARE_ITEM_4,
SPARE_ITEM_5,
SPARE_ITEM_6,
SPARE_ITEM_7,
SPARE_ITEM_8,
SPARE_ITEM_9,
SPARE_ITEM_N0,
SPARE_ITEM_N1,
SPARE_ITEM_N2,
SPARE_ITEM_N3,
SPARE_ITEM_N4,
SPARE_ITEM_N5,
SPARE_ITEM_N6,
SPARE_ITEM_N7,
SPARE_ITEM_N8,
SPARE_ITEM_N9,
RETURN_PLAN_NO,
SG_SIGN_ORIGN,
SLAB_NO_L2,
LG_ST,
MATERIAL,
COME_PROC_FLAG,
FACTORY_TJ,
BACKLOG,
BACKLOG_ACT,
FAMILY_CODE,
BILLET_TYPE,
PRODUCT_CODE_1,
AI_WT_1,
AI_TIME_1,
AI_ST_NO_1,
PRODUCT_CODE_2,
AI_WT_2,
AI_TIME_2,
AI_ST_NO_2,
PRODUCT_CODE_3,
AI_WT_3,
AI_TIME_3,
AI_ST_NO_3,
AC_ROUTE,
BP_COUNT,
INT_BACKLOG,
DEVO_PRODUCT_CODE,
PRE_PRODUCT_CODE
FROM hmmbwsm96
WHERE event_id = 'MM0C' and mat_no = 'B2110768805'