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