Finding stock objects

sql query and service method to retrieve a stock item based on the item
id.