SELECT T.SM_CD VALUE , T.SM_CFNM LABEL FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01118' SELECT SM_CD VALUE,SM_CD LABEL FROM tbz00_commcd WHERE lg_cd = 'B01001' ORDER BY SM_CD SELECT DISTINCT SPEC_STL_GRD VALUE,SPEC_STL_GRD LABEL FROM TBB01_SPEC_INGR ORDER BY SPEC_STL_GRD SELECT SM_CD VALUE,SM_CFNM LABEL FROM TBZ00_COMMCD WHERE LG_CD = 'A01007' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM SELECT DISTINCT FAC_STL_GRD VALUE,FAC_STL_GRD LABEL FROM TBB01_FAC_INGR ORDER BY FAC_STL_GRD SELECT MILL_STD_NO VALUE,MILL_STD_NO LABEL FROM TBB01_MILL_PROD ORDER BY MILL_STD_NO SELECT SMS_STD_NO VALUE,SMS_STD_NO LABEL FROM TBB01_SMS_PROD ORDER BY SMS_STD_NO SELECT DISTINCT DEV_SPEC_CD LABEL,DEV_SPEC_CD VALUE FROM TBB01_SPEC_DEL WHERE CUST_TP='1' ORDER BY DEV_SPEC_CD SELECT SM_CD VALUE,SM_CFNM LABEL FROM TBZ00_COMMCD WHERE LG_CD = 'B01119' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CD SELECT DISTINCT T.SIZE_SPEC_CD LABEL , T.SIZE_SPEC_CD VALUE FROM TBB01_HCMAP_SIZE T SELECT FAC_STL_GRD FROM TBB01_FAC_INGR WHERE FAC_STL_GRD = ? SELECT SMS_STD_NO FROM TBB01_SMS_PROD WHERE SMS_STD_NO = ? SELECT MILL_STD_NO FROM TBB01_MILL_PROD WHERE MILL_STD_NO = ? INSERT INTO TBB01_KEY_PROD( PROD_LINE ,PRDNM_CD ,SPEC_ABBSYM ,THK_MIN ,THK_MAX ,WTH_MIN ,WTH_MAX ,ORD_USE_TP ,SPEC_STL_GRD ,FAC_STL_GRD ,SMS_STD_NO ,MILL_STD_NO ,REG_ID ,REG_DTIME ,C_PRDNM_CD ,C_SPEC_ABBSYM ,C_SPEC_STL_GRD ,C_ORD_USE_TP ,COLD_STD_NO ,SIZE_SPEC_CD )VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'),?,?,?,?,?,?) DELETE FROM TBB01_KEY_PROD WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND THK_MIN = ? AND THK_MAX = ? AND WTH_MIN = ? AND WTH_MAX = ? AND ORD_USE_TP = ? AND SPEC_STL_GRD = ? AND PROD_LINE = ?