This is a patch to a recent checkout of Trunk from SVN.
After adding a service, attempt to view the service from search for
services (Goods and Services, Reports, Services) resulted in an error:
DBD::Pg::st execute failed: ERROR: column pv.entity_id does not exist
LINE 7: JOIN entity e ON (e.id = pv.entity_id)
^ at LedgerSMB/IC.pm
With recent changes to the partsvendor table, column entity_id no longer
With this change, the entity table is joined through the vendor view
rather than directly to the partsvendor table. The vendor view does have
a foreign key to the entity table and was already joined to partsvendor
in the query.