                             AND   a.amount_value IN (16.8,10,11,20.4,16.5));
 COMMIT;
 
---17.3 Fentanyl topical
+--16.3 Fentanyl topical
 UPDATE ds_stage
    SET NUMERATOR_VALUE = 0.012,
        DENOMINATOR_VALUE = NULL,


COMMIT;

--33.1 Create links to self 
INSERT /*+ APPEND */ INTO relationship_to_concept
(
  CONCEPT_CODE_1,

			  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'
	  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 */
