Query to find locators in a subinventory:

SELECT   il.inventory_location_id,
         il.organization_id,
         il.subinventory_code,
         il.description,
         il.physical_location_id,
         il.pick_uom_code,
         il.dimension_uom_code,
         il.LENGTH,
         il.width,
         il.height,
         il.locator_status,
         il.status_id,
         l.meaning
  FROM   mfg_lookups l, mtl_item_locations il
 WHERE       organization_id = 207
         AND subinventory_code = 'Stores'
         AND il.inventory_location_type = l.lookup_code(+)
         AND l.lookup_type(+) = 'MTL_LOCATOR_TYPES'