Cacher is the code snippet organizer for pro developers

select IT.category Category
	,IT.CUC
	,BL.StockItem Item
	,BL.STOCKITEMBINLOCOH
	,BW.BINLOC
	,BW.BINLOCID
	,BL.STOCKITEMBINLOCStatus 
	,SW.StockWarehouseCost Whse_Cost
FROM gxWizmo_24.dbo.STOCKITEMBINLOC BL
	JOIN gxWizmo_24.dbo.BINWHSE BW 
	  ON BL.BINLOCID = BW.BINLOCID  
	JOIN gxWizmo_24.dbo.STOCKWAREHOUSE SW
	  ON BL.StockItem = SW.StockItem
	   AND BW.Warehouseid = SW.Warehouseid
	JOIN product_10.dbo.lu_item IT
	  ON BL.StockItem = IT.item

where BL.STOCKITEMBINLOCOH > 0 
	AND BL.STOCKITEMBINLOCStatus = 1
	
	
	AND BW.Warehouseid = 111  --<-- Enter Whse Here