Find items restricted to a subinventory :

SELECT   isb.inventory_item_id,
           isb.organization_id,
           si.segment1 item,
           isb.secondary_inventory,
           isb.primary_subinventory_flag,
           isb.picking_order,
           isb.min_minmax_quantity,
           isb.max_minmax_quantity,
           isb.inventory_planning_code,
           isb.fixed_lot_multiple,
           isb.minimum_order_quantity,
           isb.maximum_order_quantity,
           isb.source_type,
           isb.source_organization_id,
           isb.source_subinventory
    FROM   mtl_item_sub_inventories isb, mtl_system_items si
   WHERE       isb.secondary_inventory = 'Stores'
           AND isb.inventory_item_id = si.inventory_item_id
           AND isb.organization_id = si.organization_id
ORDER BY   1