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

select 'Dose Form', 'RxNorm dose form of', 'Quant Clinical Box' from dual union
select 'Dose Form', 'RxNorm dose form of', 'Quant Clinical Drug' from dual union
select 'Ingredient', 'Has brand name', 'Brand Name' from dual union
select 'Ingredient', 'RxNorm q_ing of', 'Clinical Drug Comp' from dual union
select 'Ingredient', 'RxNorm q_ing of', 'Clinical Drug Form' from dual union
select 'Marketed Product', 'Has Supplier', 'Supplier' from dual union 
select 'Supplier', 'Supplier of', 'Marketed Product' from dual union
select 'Quant Branded Box', 'Has marketed form', 'Marketed Product' from dual union

create index idx_dcs_concept_code on drug_concept_stage (concept_code)
;
commit;

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