INSERT INTO MRELHR.HR_PROD_QUALITY_MAST(DEPT, Q_CODE, Q_TYPE, 
   Q_DESC, CLOTH_TYPE, QLTY_CODE,
   FINISHLEN, WIDTH, ENDS, SHOTS, 
   WEIGHT, DEPT_CODE, COMP_CODE)
SELECT 
    'BAI' DEPT, A.PRODUCT_CODE, SUBSTR(B.QTY_GROUP, 1, 1) QTYPE, 
    MREL.FUNC_PRODUCT_DESPATCHDESC(A.PRODUCT_CODE,1) QDESC, B.QTY_DESC,
    A.PRODUCT_CODE QLTY_CODE, 
    (SELECT COMPONENT_VALUE FROM MREL.MREL_PRODUCT_DETAILS_NEW WHERE PRODUCT_CODE = A.PRODUCT_CODE AND COMPONENT_CODE = 1) LENGTH,
    (SELECT COMPONENT_VALUE FROM MREL.MREL_PRODUCT_DETAILS_NEW WHERE PRODUCT_CODE = A.PRODUCT_CODE AND COMPONENT_CODE = 3) WIDTH,
    (SELECT COMPONENT_VALUE FROM MREL.MREL_PRODUCT_DETAILS_NEW WHERE PRODUCT_CODE = A.PRODUCT_CODE AND COMPONENT_CODE = 4) ENDS,
    (SELECT COMPONENT_VALUE FROM MREL.MREL_PRODUCT_DETAILS_NEW WHERE PRODUCT_CODE = A.PRODUCT_CODE AND COMPONENT_CODE = 5) SHOTS,
    --(SELECT COMPONENT_VALUE FROM MREL.MREL_PRODUCT_DETAILS_NEW WHERE PRODUCT_CODE = A.PRODUCT_CODE AND COMPONENT_CODE = 6) HEIGHT,
    (SELECT COMPONENT_VALUE FROM MREL.MREL_PRODUCT_DETAILS_NEW WHERE PRODUCT_CODE = A.PRODUCT_CODE AND COMPONENT_CODE = 7) WEIGHT,
    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 = 4159
--AND A.PRODUCT_CODE IN (SELECT DISTINCT PRODUCT_CODE FROM SALES.SALES_SALEADV_QUALITY WHERE COMP_CODE = 5)
ORDER BY 3