 			  WHERE dc.concept_class_id = 'Drug Product' AND dc.concept_name LIKE '%Pack%[%]%')
 	SELECT t.concept_code, dc2.concept_code
 	  FROM t JOIN drug_concept_stage dc2 ON dc2.concept_name = REGEXP_REPLACE (t.concept_name, '.* Pack .*\[(.*)\]', '\1') 
-	  AND dc2.concept_class_id = 'Brand Name';
-COMMIT;
-
---26.1 Add missing suppliers
+	  AND dc2.concept_class_id = 'Brand Name'
+	  WHERE  t.concept_code NOT IN (SELECT concept_code_1 FROM internal_relationship_stage JOIN drug_concept_stage ON concept_code=concept_code_2 AND concept_class_id = 'Brand Name' );
+COMMIT;
+
+--24.1 Add missing suppliers
 INSERT /*+ APPEND */ INTO  internal_relationship_stage
    WITH dc
         AS (SELECT /*+ materialize */

 WHERE a.concept_class_id = 'Unit';
COMMIT;

--33.3 insert additional mapping that doesn't exist in concept
INSERT INTO relationship_to_concept
(
  CONCEPT_CODE_1,

								   JOIN concept c_int ON c_int.concept_id = ds.drug_concept_id AND c_int.vocabulary_id = 'RxNorm Extension');
COMMIT;

--4.7 Get a supplier that hadn't been connected to any drug
INSERT /*+ APPEND */
      INTO  DRUG_CONCEPT_STAGE (CONCEPT_NAME,
                                VOCABULARY_ID,
