Added outer joins so that records will not be dropped if there is no vendor on file for the item.