 left join concept mf on mf_id=mf.concept_id
 where c.concept_id<0 and rd_combo!=' ' -- Exclude Drug Forms, do these in the next step
 ;
-
-select * from rxnorm_unit;
+commit;
 
 -- Add Drug Forms
 insert /*+ APPEND */ into spelled_out

********************/

/*

-- create XXX type concept_codes for hte new ones
drop table pack_seq purge;
create table pack_seq as
select 

create index idx_dcs_concept_code on drug_concept_stage (concept_code)
;
commit;

-- Add existing mappings from previous runs. 
drop view r_to_c;
