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