   )
 ;
 commit;
+
+select * from q_mf;
 
 -- create an xxx version of the existing (later all) packs
 drop table complete_pack purge;

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;

-- Add Drug Forms
insert /*+ APPEND */ into spelled_out

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 ing of', 'Clinical Drug Comp' from dual union
select 'Ingredient', 'RxNorm 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
