SELECT DISTINCT SPEC_ABBSYM LABEL , SPEC_ABBSYM VALUE FROM TBB01_SPEC_QLTY SELECT DISTINCT CQ.QLTY_CD , SQ.QLTY_CD_CFNM FROM TBB01_CUST_QLTY CQ , TBB01_SEQ_QLTY SQ WHERE CQ.QLTY_CD = SQ.QLTY_CD AND substr(CQ.CUST_SPEC_NO , 1 , 6) LIKE ? AND ( CQ.QLTY_MIN IS NOT NULL OR CQ.QLTY_MAX IS NOT NULL OR CQ.QLTY_UNIT IS NOT NULL OR CQ.QLTY_TYPE IS NOT NULL) SELECT DISTINCT SPE.QLTY_CD , SEQ.QLTY_CD_CFNM , SEQ.DISPLAY_SEQ FROM TBB01_SPEC_QLTY SPE , TBB01_SEQ_QLTY SEQ WHERE SPE.QLTY_CD = SEQ.QLTY_CD AND SPE.SPEC_ABBSYM LIKE ? AND SPE.SPEC_STL_GRD LIKE ? AND ( SPE.QLTY_MIN IS NOT NULL OR SPE.QLTY_MAX IS NOT NULL OR SPE.QLTY_UNIT IS NOT NULL OR SPE.QLTY_TYPE IS NOT NULL) ORDER BY SEQ.DISPLAY_SEQ , max(decode(QLTY_CD , '{0}' , QLTY_MIN , NULL)) QLTY_MIN{1} , max(decode(QLTY_CD , '{0}' , QLTY_MAX , NULL)) QLTY_MAX{1} , max(decode(QLTY_CD , '{0}' , QLTY_UNIT , NULL)) QLTY_UNIT{1} , max(decode(QLTY_CD , '{0}' , QLTY_TYPE , NULL)) QLTY_TYPE{1} FROM TBB01_CUST_QLTY WHERE substr(CUST_SPEC_NO , 1 , 6) LIKE ? GROUP BY CUST_SPEC_NO SELECT PRDNM_CD , PKG_QUALITY_COMM.FZ00_COMM('A01007' , ORD_USE_TP) ORD_USE_TP , SPEC_ABBSYM , SPEC_STL_GRD , THK_MIN , THK_MAX , max(SMP_LOT_CD||SMP_LEN_LOC||SMP_TEST_DIR||SMP_FORM) SAMPLING_CODE FROM TBB01_SPEC_QLTY WHERE SPEC_ABBSYM LIKE ? AND SPEC_STL_GRD LIKE ? GROUP BY PRDNM_CD , ORD_USE_TP , SPEC_ABBSYM , SPEC_STL_GRD , THK_MIN , THK_MAX ORDER BY SPEC_STL_GRD