reorder item lookup with warehouse, catalog group

SELECT
*
FROM
MM_REORDER_SUMMARY_V
WHERE
WAREHOUSE_CD = 'P22'
AND
CATALOG_GROUP_CD = '31'