Query to find Default Shipping WareHouse in OM

SELECT msib.segment1,
       (SELECT ood.organization_code
          FROM org_organization_definitions ood
         WHERE ood.organization_id = msib.default_shipping_org)
          Default_Shipping_Org,
          msib.inventory_item_status_code,
       (SELECT   mis.description
             FROM MTL_ITEM_STATUS_TL mis
                where  mis.inventory_item_status_code = msib.inventory_item_status_code
                and mis.language='US') inventory_item_status        
  FROM mtl_system_items_b msib
 WHERE     1 = 1
       AND msib.organization_id = 121
       AND segment1 NOT LIKE '9%'
       AND msib.default_shipping_org IS NOT NULL
ORDER BY 3,1;