 );
 commit;
 
---18
+--19
 --deprecate relationships to multiple drug forms or suppliers
 update concept_relationship_stage crs set crs.invalid_reason='D', 
 valid_end_date=(SELECT latest_update-1 FROM vocabulary WHERE vocabulary_id = 'RxNorm Extension') 

and invalid_reason is null;
commit;

--11 
--wrong pack components
update concept_stage  set invalid_reason='D',
valid_end_date=(SELECT latest_update-1 FROM vocabulary WHERE vocabulary_id = 'RxNorm Extension')

and invalid_reason is null;
commit;

--14
--deprecate drugs that have deprecated ingredients (all)
update concept_stage c set invalid_reason='D',
valid_end_date=(SELECT latest_update-1 FROM vocabulary WHERE vocabulary_id = 'RxNorm Extension') 
