QUERY TO FIND THE EBS ITEM TYPE DESCRIPTION & MEANING

       select inventory_item_id,
                   item_type,
                   flv.meaning item_type_meaning,
                   flv.description item_type_desc
         from mtl_system_items_b msib,
                   fnd_lookup_values flv
       where lookup_type ='ITEM_TYPE'
           and msib.item_type=flv.lookup_code
           and flv.language  ='US';