SELECT SM_CFNM LABEL --公差名 , SM_CD VALUE --公差代码 FROM TBZ00_COMMCD WHERE LG_CD = 'B01012' SELECT SM_CD LABEL , SM_CD VALUE FROM TBZ00_COMMCD WHERE LG_CD='B01119' SELECT T1.SM_CD LABEL ,T1.SM_CD VALUE FROM TBZ00_COMMCD T1 WHERE T1.LG_CD = 'B01120' AND T1.USED_YN = 'Y' MINUS SELECT T2.DEV_SPEC_CD ,T2.DEV_SPEC_CD FROM TBB01_SPEC_DEL T2 SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD FROM TBB01_SPEC_CUT WHERE SPEC_STL_GRD LIKE ? || '%' ORDER BY SPEC_STL_GRD SELECT 'N' CHK, t.wth_min, t.wth_max, t.thk_min, t.thk_max,t.EMEC_TP,t.add_wth,t.mark from tbb01_spec_cut t where t.SPEC_STL_GRD = ? INSERT INTO TBB01_SPEC_CUT( SPEC_STL_GRD --交付条件标准号 , EMEC_TP , WTH_MIN --宽度min , WTH_MAX --宽度max , THK_MIN --厚度min , THK_MAX --厚度max , ADD_WTH , MOD_ID --操作人 , MOD_DTIME --操作时间 , MARK ) VALUES(?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM TBB01_SPEC_CUT)) UPDATE TBB01_SPEC_CUT SET EMEC_TP = ? ,WTH_MIN = ? --宽度min , WTH_MAX = ? --宽度max , THK_MIN = ? --厚度min , THK_MAX = ? --厚度max , ADD_WTH = ? --宽度min , MOD_ID = ? , MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE SPEC_STL_GRD = ? --交付条件标准号 AND MARK = ? DELETE FROM TBB01_SPEC_CUT WHERE SPEC_STL_GRD=? DELETE FROM TBB01_SPEC_NOQLTY WHERE MARK=? DELETE FROM TBB01_SPEC_CUT WHERE MARK=? SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD FROM TBB01_SPEC_SPM WHERE SPEC_STL_GRD LIKE ? || '%' ORDER BY SPEC_STL_GRD SELECT 'N' CHK, t.wth_min, t.wth_max, t.thk_min, t.thk_max,t.EMEC_TP,t.add_wth,t.mark from TBB01_SPEC_SPM t where t.SPEC_STL_GRD = ? UPDATE TBB01_SPEC_SPM SET EMEC_TP = ? ,WTH_MIN = ? --宽度min , WTH_MAX = ? --宽度max , THK_MIN = ? --厚度min , THK_MAX = ? --厚度max , ADD_WTH = ? --宽度min , MOD_ID = ? , MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE SPEC_STL_GRD = ? --牌号 AND MARK = ? INSERT INTO TBB01_SPEC_SPM( SPEC_STL_GRD --交付条件标准号 , EMEC_TP , WTH_MIN --宽度min , WTH_MAX --宽度max , THK_MIN --厚度min , THK_MAX --厚度max , ADD_WTH , MOD_ID --操作人 , MOD_DTIME --操作时间 , MARK ) VALUES(?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM TBB01_SPEC_SPM)) DELETE FROM TBB01_SPEC_SPM WHERE MARK=? DELETE FROM TBB01_SPEC_SPM WHERE SPEC_STL_GRD=? SELECT DISTINCT SPEC_STL_GRD DEV_SPEC_CD FROM tbb01_spec_cooltime WHERE SPEC_STL_GRD LIKE ? || '%' ORDER BY SPEC_STL_GRD SELECT 'N' CHK, t.btime, t.etime, t.descmak, t.mark,t.cooltime,t.thk_min,t.thk_max from tbb01_spec_cooltime t where t.SPEC_STL_GRD = ? UPDATE tbb01_spec_cooltime SET BTIME = ? ,ETIME = ? --宽度min , DESCMAK = ? --宽度max , COOLTIME = ? --厚度min , THK_MIN = ? --宽度max , THK_MAX = ? --厚度min , MOD_ID = ? , MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE SPEC_STL_GRD = ? --牌号 AND MARK = ? INSERT INTO tbb01_spec_cooltime( SPEC_STL_GRD --交付条件标准号 , btime , etime --宽度min , descmak --宽度max , cooltime --厚度min , THK_MIN --宽度max , THK_MAX --厚度min , MOD_ID --操作人 , MOD_DTIME --操作时间 , MARK ) VALUES(?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS'),(SELECT NVL(MAX(MARK),0) + 1 FROM tbb01_spec_cooltime)) DELETE FROM tbb01_spec_cooltime WHERE MARK=? DELETE FROM tbb01_spec_cooltime WHERE SPEC_STL_GRD=? SELECT SPEC_STL_GRD DEV_SPEC_CD,MOD_DTIME FROM TBB01_SPEC_NOQLTY WHERE SPEC_STL_GRD LIKE ? || '%' ORDER BY SPEC_STL_GRD INSERT INTO TBB01_SPEC_NOQLTY( SPEC_STL_GRD --交付条件标准号 , MOD_ID --操作人 , MOD_DTIME --操作时间 ) VALUES(?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') ) DELETE FROM TBB01_SPEC_NOQLTY WHERE SPEC_STL_GRD = ? --交付条件标准号 {call ZL_NORM_MANAGE.COPY_SPEC_DELE(?,?,?,?,?,?)}