SELECT 'N' CHK ,CCM.OLD_SAMPL_NO ,CCM.COIL_NO ,CCM.SAMPL_NO ,CCM.SAMPL_CUT_LOC ,CCM.PRODNM_CD ,CCM.SPEC_ABBSYM ,CCM.SPEC_STL_GRD ,CCM.BEF_SPEC_ABBSYM ,CCM.BEF_SPEC_STL_GRD ,CCM.DCS_THK ,CCM.INGR_DEC_GRD ,CCM.MATLQLTY_DEC_GRD ,CCM.SIZE_DEC_RST ,CCM.EXTSHAPE_DEC_GRD ,CCM.TOT_DEC_GRD ,CCM.WGT_DEC_RST ,CCM.COIL_WTH ,CCM.COIL_THK ,CCM.ORD_USE_CD FROM TBH02_COIL_COMM CCM WHERE CCM.ORD_FL = '2' AND CCM.COIL_STAT = '2' AND CCM.MISSNO_CLF_CD IS NULL AND CCM.SMP_STATS IS NULL ORDER BY CCM.OLD_SAMPL_NO UPDATE TBH02_COIL_COMM CCM SET PRODNM_CD = ? ,SPEC_ABBSYM = ? ,SPEC_STL_GRD = ? ,ORD_USE_CD = ? ,CHANGE_SPEC_ID = ? ,CHANGE_SPEC_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') ,BEF_SPEC_ABBSYM = DECODE(CCM.BEF_SPEC_ABBSYM , NULL , CCM.SPEC_ABBSYM , CCM.BEF_SPEC_ABBSYM) ,BEF_SPEC_STL_GRD = DECODE(CCM.BEF_SPEC_STL_GRD , NULL , CCM.SPEC_STL_GRD , CCM.BEF_SPEC_STL_GRD) ,SMP_STATS = '0' --表示未生成试样指示信息 ,QK_YN = 'N' ,COIL_DEFECTIVE = NULL WHERE COIL_NO = ? AND COIL_STAT = '2' AND ORD_FL = '2' AND SMP_STATS IS NULL