Query to find subinventories for an inv organization :

SELECT   secondary_inventory_name subinventory,
           description,
           subinventory_type,
           organization_id,
           asset_inventory,
           quantity_tracked,
           inventory_atp_code,
           availability_type,
           reservable_type,
           locator_type,
           picking_order,
           dropping_order,
           location_id,
           status_id
    FROM   mtl_secondary_inventories
   WHERE   organization_id = 207
ORDER BY   subinventory
/