       JOIN ds_stage ds
           ON jmdc_drug_code = drug_concept_code
       WHERE who_atc_code ~ 'R01|R03'
-        AND formulation_large_classification_name ~ 'Inhal'
-        AND formulation_large_classification_name !~ 'Sol|Aeros'
+        AND formulation_small_classification_name ~ 'Inhal'
+        AND formulation_small_classification_name !~ 'Sol|Aeros'
         AND amount_unit = 'ug'
       );
 

        PERFORM VOCABULARY_PACK.SetLatestUpdate(
                        pVocabularyName => 'JMDC',
                        pVocabularyDate => CURRENT_DATE,
                        pVocabularyVersion => 'JMDC ' || CURRENT_DATE,
                        pVocabularyDevSchema => 'DEV_JMDC'
                    );
        PERFORM VOCABULARY_PACK.SetLatestUpdate(

      JOIN ds_stage ds
          ON jmdc_drug_code = drug_concept_code
      WHERE who_atc_code ~ 'R01|R03'
        AND formulation_small_classification_name ~ 'Inhal'
        AND formulation_small_classification_name !~ 'Sol|Aeros'
        AND brand_name = 'Meptin'
      );

