You'll do a sum of locationquantityavailable for each item and filter to the right inventorylocation ids.