SELECT
	_VPW.location AS shelf,
	_VPW.MFG_SKU AS location,
	MAX(pins.Name) AS description,
	MIN(_VPW.OH) AS expected_count,
	'' AS scanned,
	'' AS actual_count,
        MAX(pins.Cost) AS Cost
FROM
	products._VPW
JOIN products.pins
	ON _VPW.MFG_SKU = pins.PIN
WHERE
	_VPW.OH != 0
GROUP BY
	_VPW.MFG_SKU, _VPW.Location
ORDER BY
	_VPW.MFG_SKU, _VPW.Location