Cacher is the code snippet organizer for pro developers

SELECT ip.Whse
	,ip.PricingPlan
	,it.category
	,ip.CUC
	,ip.Item
	,sw.StockWarehouseCost [Original Cost]
	,ip.Price [Override Price]
	,ISNULL(sw.StockWarehouseOnHand,0) OnHand
	,inv.REGrk1yr
	,ip.CreatedDate
FROM product_10..rp_item_price ip
	JOIN product_10.dbo.lu_item it
	  ON ip.Item = it.item
	LEFT JOIN gxWizmo_24.dbo.STOCKWAREHOUSE sw
	  ON ip.Item = sw.StockItem
	  AND ip.Whse = sw.Warehouseid
	LEFT JOIN ROH.dbo.inv_CUC_WH inv
	  ON ip.CUC = inv.finalcuc
	  AND ip.Whse = inv.rte_wh
WHERE ip.Whse in  ( 60 )   --- Change Whse Number
	and pricingplan <> 'dw'
	and it.category in (SELECT category from product_10.dbo.CategoryGroup where GroupName In('fuel') )  --- Select a category group here.
ORDER BY ISNULL(inv.REGrk1yr, 3000)