Query to find items base on OE categories

SELECT   distinct                                                -- mc.category_id,
           mc .description,
           mc.attribute_category,
           ood.OPERATING_UNIT,
           hou.name OU_NAME,
           ood.ORGANIZATION_CODE,
           ood.ORGANIZATION_NAME,
           msi.segment1,
           msi.DESCRIPTION "ITEM_DESCRIPTION"
    FROM   MTL_CATEGORIES mc,
           MTL_ITEM_CATEGORIES mic,
           mtl_system_items_b msi,
           org_organization_definitions ood,
           hr_operating_units hou
   WHERE       mc.category_id = mic.category_id
           AND mic.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID
           AND mic.ORGANIZATION_ID = msi.ORGANIZATION_ID
           AND mic.ORGANIZATION_ID = ood.ORGANIZATION_ID
           AND msi.ORGANIZATION_ID = ood.ORGANIZATION_ID
           and ood.OPERATING_UNIT =  hou.ORGANIZATION_ID
           AND mc.attribute_category = 'ENVS OE Categories'
           AND mc.description IN
                    ('Mem Filt Sep.Membrane Film.Polymer Treated.Super Critical CO2.Oleophobic Grade 8.All',
                     'ESP Electrical.AVC''s.All.All.All.All')