SELECT SMP_LOT_CD SM_CD, SMP_LOT_DETAIL SM_CFNM FROM TBB02_SMP_CODE ORDER BY SM_CFNM --试样LOT重量 SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01102' UNION ALL SELECT '' , '' FROM DUAL --试样长度方向位置 SELECT SM_CD,SM_CFNM FROM TBZ00_COMMCD WHERE LG_CD = 'B01103' UNION ALL SELECT '' , '' FROM DUAL --试样宽度方向位置 SELECT T1.QLTY_CD ,T1.QLTY_CD_CFNM ,T1.QLTY_MIN_TP ,T1.QLTY_MAX_TP ,T1.QLTY_UNIT_TP ,T1.QLTY_TYPE ,T2.QLTY_MIN ,T2.QLTY_MAX ,T2.QLTY_UNIT ,T2.QLTY_DETAIL ,T2.QLTY_DEC_CD FROM TBB01_SEQ_QLTY T1 , TBB01_CUST_QLTY T2 WHERE T1.QLTY_CD = T2.QLTY_CD(+) AND T2.CUST_SPEC_NO(+) = NVL(?||?||?||? , 'X') ORDER BY DECODE(T2.QLTY_MIN||T2.QLTY_MAX||T2.QLTY_UNIT , NULL , 1 , 0) , T1.DISPLAY_SEQ SELECT * FROM TBB01_CUST_QLTY T WHERE T.QLTY_CD = ? AND T.CUST_SPEC_NO = ? SELECT SMP_LOT_CD , SMP_LEN_LOC , SMP_WTH_LOC FROM TBB01_CUST_QLTY T WHERE T.QLTY_CD = 'SAMP' AND T.CUST_SPEC_NO = NVL(?||?||?||? , 'X') INSERT INTO TBB01_CUST_QLTY( CUST_SPEC_NO ,QLTY_CD ,QLTY_MIN ,QLTY_MAX ,QLTY_DEC_CD ,QLTY_UNIT ,QLTY_TYPE ,QLTY_DETAIL ,SPEC_STL_GRD ,REG_ID ,REG_DTIME ) VALUES(?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) INSERT INTO TBB01_CUST_QLTY( CUST_SPEC_NO ,QLTY_CD ,SMP_LOT_CD ,SMP_LEN_LOC ,SMP_WTH_LOC ,REG_ID ,REG_DTIME) VALUES(?,?,?,?,?,?,TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS')) UPDATE TBB01_CUST_QLTY T SET T.QLTY_MIN = ? ,T.QLTY_MAX = ? ,T.QLTY_UNIT = ? ,T.QLTY_TYPE = ? ,T.QLTY_DEC_CD = ? ,T.QLTY_DETAIL = ? ,T.MOD_ID = ? ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.CUST_SPEC_NO = ? AND T.QLTY_CD = ? UPDATE TBB01_CUST_QLTY T SET T.SMP_LOT_CD = ? ,T.SMP_LEN_LOC = ? ,T.SMP_WTH_LOC = ? ,T.MOD_ID = ? ,T.MOD_DTIME = TO_CHAR(SYSDATE , 'YYYYMMDDHH24MISS') WHERE T.CUST_SPEC_NO = ? AND T.QLTY_CD = 'SAMP' DELETE FROM TBB01_CUST_QLTY WHERE CUST_SPEC_NO = ? DELETE FROM TBB01_CUST_QLTY WHERE CUST_SPEC_NO = ? AND QLTY_CD = ?