SELECT DISTINCT CUST_SPEC_NO VALUE1 ,T.SPEC_STL_GRD VALUE2 FROM TBB01_CUST_INGR T WHERE SUBSTR(T.CUST_SPEC_NO ,1,6) = SUBSTR(? , 1,6) SELECT DISTINCT CUST_SPEC_NO VALUE1 ,T.SPEC_STL_GRD VALUE2 FROM TBB01_CUST_QLTY T WHERE SUBSTR(T.CUST_SPEC_NO ,1,6) = SUBSTR(? , 1,6) SELECT DISTINCT CUST_SPEC_NO VALUE1 ,T.SPEC_STL_GRD VALUE2 FROM TBB01_CUST_DEL T WHERE SUBSTR(T.CUST_SPEC_NO ,1,6) = SUBSTR(? , 1,6) SELECT DISTINCT FAC_STL_GRD from TBB01_FAC_INGR WHERE FAC_STL_GRD = ? SELECT DISTINCT SMS_STD_NO FROM TBB01_SMS_PROD WHERE SMS_STD_NO = ? SELECT DISTINCT MILL_STD_NO FROM TBB01_MILL_PROD WHERE MILL_STD_NO = ? SELECT 'N' CHK ,CR.* ,CUST_SPEC_NO CUST_SPEC_NO1 --客户参数号 ,PKG_QUALITY_COMM.FZ00_COMM('A01007' , ORD_USE_TP) ORD_USE ,PKG_QUALITY_COMM.FIB010204(CR.CUST_SPEC_NO) INGR_REQ ,PKG_QUALITY_COMM.FIB010205(CR.CUST_SPEC_NO) QLTY_REQ ,PKG_QUALITY_COMM.FIB020202(SUBSTR(CR.CUST_SPEC_NO , 1,6)) CUST_NM FROM TBB01_CUST_REQ CR WHERE CUST_CD = DECODE(? , NULL , CUST_CD , ?) ORDER BY CUST_SPEC_NO INSERT INTO TBB01_CUST_REQ( CUST_SPEC_NO --客户参数号 , CUST_SPEC_NO_INGR , CUST_SPEC_NO_QLTY , CUST_SPEC_NO_DEL , CUST_CD --客户公司代码 , SPEC_ABBSYM --标准号 , SPEC_STL_GRD --标准钢号 , THK_MIN --厚度min , THK_MAX --厚度max , WTH_MIN --宽度min , WTH_MAX --宽度max , ORD_USE_TP --订单用途 , FAC_STL_GRD --厂内钢号 , SMS_STD_NO --炼钢生产规范 , MILL_STD_NO --轧钢生产规范 , COLD_STD_NO --冷轧生产规范 , DEV_SPEC_CD --交付条件 , DEV_DGR_CD --等级代码 , SIZE_SPEC_CD --尺寸对应码 , REG_ID , REG_DTIME ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')) DELETE FROM TBB01_CUST_REQ WHERE CUST_SPEC_NO = ? UPDATE TBB01_CUST_REQ SET CUST_SPEC_NO = ? --客户参数号 , CUST_SPEC_NO_INGR = ? , CUST_SPEC_NO_QLTY = ? , CUST_SPEC_NO_DEL = ? , CUST_CD = ? --客户公司代码 , SPEC_ABBSYM = ? --标准号 , SPEC_STL_GRD = ? --标准钢号 , THK_MIN = ? --厚度min , THK_MAX = ? --厚度max , WTH_MIN = ? --宽度min , WTH_MAX = ? --宽度max , ORD_USE_TP = ? --订单用途 , FAC_STL_GRD = ? --厂内钢号 , SMS_STD_NO = ? --炼钢生产规范 , MILL_STD_NO = ? --轧钢生产规范 , COLD_STD_NO = ? , DEV_SPEC_CD = ? --交付条件 , DEV_DGR_CD = ? , SIZE_SPEC_CD = ? , MOD_ID = ? , MOD_DTIME = TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') WHERE CUST_SPEC_NO = ? SELECT SM_CD VALUE,SM_CD LABEL FROM tbz00_commcd WHERE lg_cd = 'B01001' AND UPPER(USED_YN) = 'Y' 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 '*' VALUE,'*' LABEL FROM DUAL UNION ALL SELECT * FROM ( SELECT DISTINCT FAC_STL_GRD VALUE,FAC_STL_GRD LABEL FROM TBB01_FAC_INGR ORDER BY FAC_STL_GRD) SELECT '*' VALUE,'*' LABEL FROM DUAL UNION ALL SELECT * FROM( SELECT MILL_STD_NO VALUE,MILL_STD_NO LABEL FROM TBB01_MILL_PROD ORDER BY MILL_STD_NO) SELECT '*' VALUE,'*' LABEL FROM DUAL UNION ALL SELECT * FROM( 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 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