SELECT DISTINCT 'N' CHK ,PRDNM_CD ,PRDNM_CD CD ,SPEC_ABBSYM ,SPEC_ABBSYM SYM ,SPEC_STL_GRD ,SPEC_STL_GRD GRD ,ORD_USE_TP ,ORD_USE_TP TP ,MIN(THK_MIN) MINTHK ,MAX(THK_MAX) MAXTHK FROM TBB01_SPEC_QLTY WHERE SPEC_ABBSYM = ? GROUP BY PRDNM_CD ,SPEC_ABBSYM ,SPEC_STL_GRD ,ORD_USE_TP ORDER BY SPEC_STL_GRD SELECT DISTINCT SMP_LOT_CD ,SMP_LEN_LOC ,SMP_WTH_LOC ,SMP_TEST_DIR ,SMP_FORM --试样规格 FROM TBB01_SPEC_QLTY WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ? AND QLTY_CD = 'SAMP' SELECT DISTINCT SEQ.* ,DECODE(SPE.QLTY_CD , NULL , '' , 'Y') EX FROM TBB01_SEQ_QLTY SEQ , TBB01_SPEC_QLTY SPE WHERE SEQ.QLTY_CD = SPE.QLTY_CD(+) AND SPE.PRDNM_CD(+) = ? AND SPE.SPEC_ABBSYM(+) = ? AND SPE.SPEC_STL_GRD(+) = ? AND SPE.ORD_USE_TP(+) = ? ORDER BY EX SELECT T.THK_MIN ,T.THK_MAX ,T.QLTY_MIN ,T.QLTY_MAX ,T.QLTY_UNIT ,T.QLTY_TYPE ,T.QLTY_DETAIL ,T.PRDNM_CD ,T.SPEC_ABBSYM ,T.SPEC_STL_GRD ,T.ORD_USE_TP ,T.QLTY_CD FROM TBB01_SPEC_QLTY T WHERE T.PRDNM_CD = ? AND T.SPEC_ABBSYM = ? AND T.SPEC_STL_GRD = ? AND T.ORD_USE_TP = ? AND T.QLTY_CD = ? INSERT INTO TBB01_SPEC_QLTY( PRDNM_CD ,SPEC_ABBSYM ,SPEC_STL_GRD ,ORD_USE_TP ,THK_MIN ,THK_MAX ,QLTY_CD ,QLTY_MIN ,QLTY_MAX ,QLTY_UNIT ,QLTY_DETAIL ,SMP_LOT_CD ,SMP_LEN_LOC ,SMP_WTH_LOC ,REG_ID ,REG_DTIME ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')) UPDATE TBB01_SPEC_QLTY SET QLTY_MIN = ? ,QLTY_MAX = ? ,QLTY_UNIT = ? ,QLTY_DETAIL = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ? AND THK_MIN = ? AND THK_MAX = ? AND QLTY_CD = ? UPDATE TBB01_SPEC_QLTY SET SMP_LOT_CD = ? ,SMP_LEN_LOC = ? ,SMP_WTH_LOC = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ? AND QLTY_CD = 'SAMP' INSERT INTO TBB01_SPEC_QLTY( PRDNM_CD, SPEC_ABBSYM, SPEC_STL_GRD, ORD_USE_TP, THK_MIN, THK_MAX, QLTY_CD, SMP_LOT_CD, SMP_LEN_LOC, SMP_WTH_LOC ) VALUES(?,?,?,?,?,?,?,?,?,?) UPDATE TBB01_SPEC_QLTY SET PRDNM_CD = ? ,SPEC_ABBSYM = ? ,SPEC_STL_GRD = ? ,ORD_USE_TP = ? ,MOD_ID = ? ,MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ? DELETE FROM TBB01_SPEC_QLTY WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ? AND THK_MIN = ? AND THK_MAX = ? DELETE FROM TBB01_SPEC_QLTY WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND SPEC_STL_GRD = ? AND ORD_USE_TP = ?