        AND cs.domain_id<>'Drug';
 COMMIT;
 
---24 Procedure Drugs who have a mapping to a Drug concept should not also be recorded as Procedures (no Standard Concepts)
+--25 Procedure Drugs who have a mapping to a Drug concept should not also be recorded as Procedures (no Standard Concepts)
 UPDATE concept_stage cs
    SET cs.standard_concept = NULL
  WHERE     EXISTS

       AND cs.invalid_reason = 'U';		
COMMIT;				

--15 Deprecate replacement records if target concept was deprecated 
MERGE INTO concept_relationship_stage r
     USING (WITH upgraded_concepts
                    AS (SELECT crs.concept_code_1,

		  AND NOT (c1.vocabulary_id='RxNorm' AND r.relationship_id='Maps to'); 
COMMIT;

--10 Add upgrade relationships
INSERT /*+ APPEND */ INTO  concept_relationship_stage (
                                        concept_code_1,
                                        concept_code_2,
