 AND   DRUG_CONCEPT_CODE = '310463'
 AND   AMOUNT = 7;
 
---insert missing packs
+--insert missing packs from AMIS and AMT (only those taht have => 2 components)
 INSERT INTO pc_stage
 (
   pack_concept_code,

       amount_unit = NULL
WHERE amount_unit = '%';

-- More manual fixes
UPDATE DS_STAGE
   SET NUMERATOR_VALUE = 25
WHERE DRUG_CONCEPT_CODE = 'OMOP303266';

WHERE CONCEPT_CODE_1 = 'OMOP425698'
AND   CONCEPT_CODE_2 = 'OMOP440161';

--Delete relationship from packs to their components' brand names
DELETE
FROM INTERNAL_RELATIONSHIP_STAGE
WHERE CONCEPT_CODE_1 = 'OMOP339685'
