select qlty_cd, --材质代码 qlty_cd_cfnm --材质代码名称 from TBB01_SEQ_QLTY order by display_seq select t1.PRDNM_CD, --品名代码 t1.PRDNM_CD BEF_PRDNM_CD, t1.QLTY_CD, --材质代码 t1.QLTY_CD QLTY_CD_CFNM, --材质代码 t1.QLTY_CD BEF_QLTY_CD, t1.SPEC_ABBSYM, --标准号 t1.SPEC_ABBSYM BEF_SPEC_ABBSYM, t1.SMP_LOT_CD, --试样LOT代码 t1.DEF_QLTY_TP --指定区分 from TBB02_DEF_CONV t1,TBB01_SEQ_QLTY t2 where t1.qlty_cd = t2.qlty_cd(+) and SPEC_ABBSYM like :1 and t1.QLTY_CD like :2 order by t1.SPEC_ABBSYM select SMP_LOT_CD, --试样LOT代码 SMP_LOT_DETAIL --试样LOT说明 from TBB02_SMP_CODE ORDER BY SMP_LOT_CD insert into TBB02_DEF_CONV (PRDNM_CD,SPEC_ABBSYM,QLTY_CD,SMP_LOT_CD,DEF_QLTY_TP) values(?,?,?,?,?) UPDATE TBB02_DEF_CONV set PRDNM_CD = ?,SPEC_ABBSYM = ? ,QLTY_CD = ?,SMP_LOT_CD = ?,DEF_QLTY_TP = ? WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ? DELETE FROM TBB02_DEF_CONV WHERE PRDNM_CD = ? AND SPEC_ABBSYM = ? AND QLTY_CD = ? SELECT SM_CD --订单用途代码 ,SM_CFNM --订单用途名称 FROM TBZ00_COMMCD WHERE LG_CD = 'A01007' AND UPPER(USED_YN) = 'Y' ORDER BY SM_CFNM SELECT DISTINCT T2.QLTY_CD, --材质代码 T2.QLTY_CD_CFNM --材质代码名称 FROM TBB01_SPEC_QLTY T1,TBB01_SEQ_QLTY T2 WHERE T1.QLTY_CD = T2.QLTY_CD AND T1.SPEC_ABBSYM = ?