INSERT INTO MRELHR.HR_PROD_QUALITY_MAST(DEPT, Q_CODE, Q_TYPE, CLOTH_TYPE, Q_DESC, QLTY_CODE, DEPT_CODE, COMP_CODE) SELECT 'BALING' DEPT, A.PRODUCT_CODE, SUBSTR(B.QTY_GROUP, 1, 1) QTYPE, B.QTY_DESC, MREL.FUNC_PRODUCT_DESPATCHDESC(A.PRODUCT_CODE,1) QDESC, A.PRODUCT_CODE QLTY_CODE, 14 DEPT_CODE, 5 COMP_CODE FROM MREL.MREL_PRODUCT_MASTER A, MREL.MREL_QUALITY_MAST B WHERE A.QTY_CODE = B.QTY_CODE AND A.OLD_NEW = 'N' AND A.PRODUCT_CODE IN (SELECT DISTINCT PRODUCT_CODE FROM SALES.SALES_SALEADV_QUALITY WHERE COMP_CODE = 5) ORDER BY 3