SELECT COUNT(*) FROM MREL_PRODUCT_MASTER
where product_code not in
(    SELECT product_code
    FROM SALES.SALES_SALEADV_QUALITY)
    and product_code not in
(    SELECT product_code
    FROM SALES.SALES_PUR_CONT_QUALITY)   
    AND PRODUCT_CODE NOT IN
(SELECT PRODUCT_CODE FROM MREL_PRODUCT_OB)

INSERT INTO MREL_PRODUCT_MASTER_UNUSED
(
SELECT * FROM MREL_PRODUCT_MASTER
where product_code not in
(    SELECT product_code
    FROM SALES.SALES_SALEADV_QUALITY)
    and product_code not in
(    SELECT product_code
    FROM SALES.SALES_PUR_CONT_QUALITY)   
    AND PRODUCT_CODE NOT IN
(SELECT PRODUCT_CODE FROM MREL_PRODUCT_OB)    
)


INSERT INTO MREL_PRODUCT_DETAILS_UNUSED
(
SELECT * FROM MREL_PRODUCT_DETAILS
where product_code not in
(    SELECT product_code
    FROM SALES.SALES_SALEADV_QUALITY)
    and product_code not in
(    SELECT product_code
    FROM SALES.SALES_PUR_CONT_QUALITY)   
    AND PRODUCT_CODE NOT IN
(SELECT PRODUCT_CODE FROM MREL_PRODUCT_OB)    
)


DELETE FROM MREL_PRODUCT_DETAILS
WHERE product_code not in
(    SELECT product_code
    FROM SALES.SALES_SALEADV_QUALITY)
    and product_code not in
(    SELECT product_code
    FROM SALES.SALES_PUR_CONT_QUALITY)   
    AND PRODUCT_CODE NOT IN
(SELECT PRODUCT_CODE FROM MREL_PRODUCT_OB)  
  
DELETE FROM MREL_PRODUCT_MASTER
WHERE product_code not in
(    SELECT product_code
    FROM SALES.SALES_SALEADV_QUALITY)
    and product_code not in
(    SELECT product_code
    FROM SALES.SALES_PUR_CONT_QUALITY)   
    AND PRODUCT_CODE NOT IN
(SELECT PRODUCT_CODE FROM MREL_PRODUCT_OB)