The product type is associated to a software product via a resource association. Here's a query which returns the software products and their types in the database.
select p.Guid [_ItemGuid]
,p.Name [Software Product]
,t.Name [Software Type]
from dbo.vRM_Software_Product_Item p
left outer join ResourceAssociation ra
on p.Guid = ra.ParentResourceGuid and ra.ResourceAssociationTypeGuid='ae4dbdf7-457b-4828-a83e-b64b91ae0e87'
left outer join [RM_ResourceSoftware_Type] t
on t.Guid = ra.ChildResourceGuid
order by 2