成品物料从履历表取数据

insert into TMMBW01
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,
SHORT_FLAG,
MAT_THICK,
MAT_WIDTH,
MAT_LEN,
MAT_LEN_FROM,
MAT_LEN_TO,
CROSS_CODE,
MAT_ACT_THICK,
MAT_ACT_WIDTH,
MAT_ACT_LEN,
MAT_ACT_LEN_FROM,
MAT_ACT_LEN_TO,
MAT_TARG_THICK,
MAT_TARG_WIDTH,
MAT_TARG_LEN,
MAT_NUM,
MAT_WT,
MAT_ACT_WT,
MAT_THEORY_WT,
MEASURE_WT_FLAG,
PRODUCT_PACK_FLAG,
PACK_TYPE_CODE,
PACK_NO,
PRODUCT_PACK_TIME,
PACK_MAT_WT,
PONO,
HEAT_NO,
ST_NO,
PROD_MAKER,
PROD_TIME,
PROD_DATE,
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,
MAT_NO_OLD,
MAT_ID_OLD,
RETURN_MAT_FLAG,
RETURN_MAT_ORIGIN,
RETURN_MAT_CAUSE_CODE,
RETURN_MAT_TIME,
RETURN_MAT_MAKER,
BATCH_NO,
BUNDLE_NO,
OLD_BUNDLE_NO,
ORDER_NO,
OLD_ORDER_NO,
FIX_FLAG,
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,
PSC_DESC,
OLD_PSC,
APN,
OLD_APN,
WKM,
OLD_WKM,
CONFM_FLAG,
CONFM_PLAN_NO,
CONFM_TIME,
CONFM_REJECT_CAUSE,
APP_DECIDE_FLAG,
APP_DECIDE_NO,
TRANSFER_FLAG,
TRANSFER_PLAN_NO,
TRANSFER_REJECT_CAUSE,
PROD_READY_DATE,
BILL_OF_LADING_NO,
COME_PROC_AGREE_NO,
RED_FLAG,
RED_CAUSE_CODE,
RED_CAUSE_DESC,
RED_CONFM_MAKER,
RED_CONFM_TIME,
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,
DETECT_DECIDE_CODE,
DETECT_DECIDE_TIME,
DETECT_DECIDE_MAKER,
DEFECT_DEFECT_REMARK,
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,
SAMPLE_TAKEN_FLAG,
DEFECT_CODE,
DEFECT_CLASS,
TECH_NOTE_NO,
PLAN_NO,
ROLL_PLAN_NO,
OLD_ROLL_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,
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,
LOADING_NO,
COUNT,
TRANSFER_BILL_NO,
LOGISTICS_STATUS,
CMD_FLAG,
IN_MAT_NO,
SAMPLE_LOT_NO_1,
SAMPLE_LOT_NO_2,
SAMPLE_LOT_NO_3,
SAMPLE_LOT_NO_4,
SAMPLE_LOT_NO_5,
FINISH_FLAG,
COME_PROC_FLAG,
COLD_HOT_FLAG,
MERGE_FLAG,
STRA_IS,
BEBEL_IS,
PRODUCT_IS,
CFT_DETECT_IS,
ULT_DETECT_IS,
BP_IS,
ANNEAL_FLAG,
MEND_FLAG,
HEAT_LOT_NO,
PRINT_DATE,
PRINT_FLAG,
PRINT_MAKER,
INGOT_CODE,
RE_MEASURE_CAUSE,
RE_MEASURE_FLAG,
STRAND_NO,
COMPRESS_VAL,
WT_UPDATE_REMARK,
RL_NO,
ALLOW_DESTION,
FACTORY_TJ,
BACKLOG,
BACKLOG_ACT,
FAMILY_CODE,
BILLET_TYPE,
ORDER_NO_ERP,
OUT_FLAG,
ROLLING_REMARK,
PRODUCT_CODE,
SG_SIGN_ORIGN,
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,
DEFECT_CODE1,
DEFECT_CODE2,
DEFECT_CODE3,
DEFECT_CODE4,
SUPPLY_STATUS,
ROLL_COMPRESS_RATE,
LG_ST,
MATERIAL,
STOCK_REMARK,
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,
PONDER_APP_NO,
PONDER_NO,
PONDER_NO_PRE,
BP_COUNT,
INT_BACKLOG,
DEVO_PRODUCT_CODE,
PRE_PRODUCT_CODE,
MAT_DISCREP_WT
FROM tmmbw96
WHERE event_id = 'MM09' and mat_no = '121061219021'