SELECT 'N' CHK , SMP_LOT_CD , SMP_LOT_WGT , SMP_LOT_CNT , SMP_LOT_DETAIL FROM TBB02_SMP_CODE SELECT DISTINCT SQ.QLTY_CD , SQY.QLTY_CD_CFNM FROM TBB01_SPEC_QLTY SQ , TBB01_SEQ_QLTY SQY WHERE SQ.QLTY_CD = SQY.QLTY_CD AND SQ.PRDNM_CD = 'AR' AND SQ.SPEC_ABBSYM like ? SELECT 'N' CHK , PRDNM_CD , SPEC_ABBSYM {1} FROM TBB02_DEF_CONV WHERE SPEC_ABBSYM LIKE ? GROUP BY PRDNM_CD , SPEC_ABBSYM , max(decode(QLTY_CD , '{1}' , SMP_LOT_CD)) {2} SELECT DISTINCT SQ.QLTY_CD , SQY.QLTY_CD_CFNM FROM TBB01_SPEC_QLTY SQ , TBB01_SEQ_QLTY SQY WHERE SQ.QLTY_CD = SQY.QLTY_CD AND SQ.PRDNM_CD = 'AR' AND SQ.SPEC_ABBSYM like ? SELECT SQ.SPEC_STL_GRD , SQ.ORD_USE_TP , SQ.THK_MIN , SQ.THK_MAX {1} , MAX(decode(SQ.QLTY_CD , 'SAMP' , SQ.SMP_LOT_CD||SQ.SMP_LEN_LOC||SQ.SMP_WTH_LOC )) SAMP FROM TBB01_SPEC_QLTY SQ , TBB02_DEF_CONV DC WHERE SQ.SPEC_ABBSYM = DC.SPEC_ABBSYM(+) AND SQ.PRDNM_CD = DC.PRDNM_CD(+) AND SQ.QLTY_CD = DC.QLTY_CD(+) AND SQ.SPEC_ABBSYM LIKE ? AND SQ.PRDNM_CD = 'AR' GROUP BY SQ.SPEC_STL_GRD , SQ.ORD_USE_TP , SQ.THK_MIN , SQ.THK_MAX , max(decode(DC.QLTY_CD , '{1}' , DC.SMP_LOT_CD)) LOTCD{2} SELECT 1 FROM TBB02_DEF_CONV WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ? INSERT INTO TBB02_DEF_CONV(PRDNM_CD , SPEC_ABBSYM , QLTY_CD , SMP_LOT_CD) VALUES(?,?,?,?) UPDATE TBB02_DEF_CONV SET SMP_LOT_CD = ? WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ? DELETE FROM TBB02_DEF_CONV WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ?