To find sub inventories for any 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=''

order by subinventory;