"In Review" means that an item has been Checked-In, but was marked as "For Review" during the Check-In process and has yet to be marked as Available or have a work order created. You can see all of your items that are "In Review" in the following places:
In the Yard View in the "Needs Review" Column and on the Maintenance Tab under "Needs Review"
Note: Items that are "In Review" will show up as a Yellow Available in the New Order search and warn you that they are "In Review"