        amount_unit = NULL
 WHERE amount_unit = '%';
 
--- More manual fixes
+-- More manual fixes (insert numerator_value in order to proceed it in the next query)
 UPDATE DS_STAGE
    SET NUMERATOR_VALUE = 25
 WHERE DRUG_CONCEPT_CODE = 'OMOP303266';

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

--Packs BN
DELETE
FROM INTERNAL_RELATIONSHIP_STAGE
WHERE CONCEPT_CODE_1 = 'OMOP339685'

WHEN MATCHED THEN UPDATE
  SET DENOMINATOR_VALUE = cx WHERE d.DRUG_CONCEPT_CODE = ds.DRUG_CONCEPT_CODE;


/*
-- XXX ?? ????
--rounding
UPDATE ds_stage
   SET AMOUNT_VALUE = ROUND(AMOUNT_VALUE,3 - FLOOR(LOG(10,AMOUNT_VALUE)) -1),
       NUMERATOR_VALUE = ROUND(NUMERATOR_VALUE,3 - FLOOR(LOG(10,NUMERATOR_VALUE)) -1),
       DENOMINATOR_VALUE = ROUND(DENOMINATOR_VALUE,3 - FLOOR(LOG(10,DENOMINATOR_VALUE)) -1);
*/
COMMIT;

--fix solid forms with denominator
