Find items RESTRICTED TO a sub-inventory :

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