 -- Instillations
 insert /*+ APPEND */ into drug_concept_stage_tmp
 select 
-  '' as concept_name, 'HCPCS' as vocabulary_id, 'Ingredient' as concept_class_id, null as standard_concept, regexp_replace(lower(concept_name), '(.+?),? ?per instillation.*', '\1') as concept_code, 
+  '' as concept_name, 'Drug' as domain_id, 'HCPCS' as vocabulary_id, 'Ingredient' as concept_class_id, regexp_replace(lower(concept_name), '(.+?),? ?per instillation.*', '\1') as concept_code, 
   null as possible_excipient, null as valid_start_date, null as valid_end_date, null as invalid_reason, null as dose_form
 from drug_concept_stage where dose_form='Instillation' 
 ;

-- Write units
insert /*+ APPEND */ into drug_concept_stage
select distinct 
  u as concept_name, 'HCPCS' as vocabulary_id, 'Unit' as concept_class_id, null as standard_concept, u as concept_code, 
  null as possible_excipient, null as valid_start_date, null as valid_end_date, null as invalid_reason, null as dose_form
from (
  select case


-- Manually create Dose Form mapping to RxNorm
begin
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Infusion', 19082103, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Infusion', 19082104, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Infusion', 46234469, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19082259, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19095898, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19126918, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19082162, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19126919, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19127579, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19082258, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Inhalant', 19018195, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19082103, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19126920, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19082104, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 46234469, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 46234468, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19095913, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19095914, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19082105, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 44784844, 9);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 46234466, 10);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 46234467, 11);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 46275062, 12);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19095915, 13);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Injection', 19082260, 14);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082573, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082168, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082191, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082170, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082251, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19001144, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082652, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19095976, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082651, 9);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082253, 10);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082101, 11);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19111148, 12);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082169, 13);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19001943, 14);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19135868, 15);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19021887, 16);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082223, 17);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082077, 18);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082079, 19);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082080, 20);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 44817840, 21);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082255, 22);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19001949, 23);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082076, 24);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19103220, 25);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082048, 26);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082256, 27);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082050, 28);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 40164192, 29);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 40175589, 30);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082222, 31);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082075, 32);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19135866, 33);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19102296, 34);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19018708, 35);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19135790, 36);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 45775489, 37);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 45775490, 38);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 45775491, 39);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 45775492, 40);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19111155, 41);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19126316, 42);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Oral', 19082285, 43);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082229, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082701, 2);
-- insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082224, 3); -- Topical cream
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082049, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082071, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082072, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082252, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Patch', 19082073, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082228, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082224, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095912, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 46234410, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082227, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082226, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082225, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095972, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095973, 9);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095912, 10);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082628, 11);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19135438, 12);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19135446, 13);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19135439, 14);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19135440, 15);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19129401, 16);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082287, 17);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19135925, 18);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082194, 19);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095975, 20);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082164, 21);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19110977, 22);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082161, 23);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082576, 24);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082169, 25);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082193, 26);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082197, 27);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19010878, 28);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19112544, 29);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082163, 30);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082166, 31);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095916, 32);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095917, 33);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095973, 34);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095974, 35);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19010880, 36);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19011932, 37);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 40228565, 38);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095900, 39);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19011167, 40);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095911, 41);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082281, 42);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082199, 43);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095899, 44);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19112649, 45);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082110, 46);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082165, 47);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082195, 48);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 45775488, 49);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19095977, 50);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082167, 51);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082196, 52);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19082102, 53);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Topical', 19010879, 54);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19095899, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19095911, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19011167, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19082199, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19082281, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19095912, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19112649, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Spray', 19095900, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19082104, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19126920, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19082103, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 46234469, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19011167, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19082191, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19001949, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Vaccine', 19082255, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Suppository', 19082200, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Suppository', 19093368, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Suppository', 19082575, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082573, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082103, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082168, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082170, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082079, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082224, 6);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082191, 7);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082227, 8);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082228, 9);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19135866, 10);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082077, 11);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095973, 12);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082225, 13);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19129634, 14);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19126920, 15);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082200, 16);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082253, 17);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095912, 18);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082104, 19);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19001949, 20);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082229, 21);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19008697, 22);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 46234469, 23);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095898, 24);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082076, 25);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19130307, 26);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082258, 27);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082255, 28);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082109, 29);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19135925, 30);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095916, 31);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082080, 32);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082285, 33);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082286, 34);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095972, 35);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19011167, 36);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19126590, 37);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19093368, 38);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082195, 39);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082165, 40);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19009068, 41);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082167, 42);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19016586, 43);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095976, 44);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082108, 45);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082226, 46);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19102295, 47);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19010878, 48);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082627, 49);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082259, 50);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082110, 51);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082651, 52);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 44817840, 53);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19126918, 54);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19124968, 55);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082251, 56);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19129139, 57);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095900, 58);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082197, 59);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19102296, 60);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082282, 61);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095911, 62);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 46234468, 63);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19010880, 64);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19126316, 65);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 46234466, 66);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19010962, 67);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082166, 68);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19126919, 69);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095918, 70);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19127579, 71);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 46234467, 72);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 40175589, 73);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082281, 74);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19059413, 75);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082196, 76);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082163, 77);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082169, 78);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19112648, 79);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095917, 80);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095971, 81);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082162, 82);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 40164192, 83);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082574, 84);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082105, 85);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082222, 86);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082575, 87);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082652, 88);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 45775489, 89);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 45775491, 90);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082164, 91);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 40167393, 92);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082287, 93);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082194, 94);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082576, 95);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095975, 96);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082628, 97);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 46275062, 98);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19010879, 99);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 46234410, 100);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19135439, 101);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095977, 102);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082199, 103);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082283, 104);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19095974, 105);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19135446, 106);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19130329, 107);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 45775490, 108);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 45775492, 109);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19082101, 110);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19135440, 111);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 19135438, 112);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 45775488, 113);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Unknown', 44784844, 114);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Instillation', 19016586, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Instillation', 46234410, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Instillation', 19082104, 3);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Instillation', 19082103, 4);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Instillation', 46234469, 5);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Implant', 19124968, 1);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Implant', 19082103, 2);
insert into relationship_to_concept (concept_code_1, concept_id_2, precedence) values ('Implant', 19082104, 3);
end;
commit;

