The script below can be used to count how many bills are on each term code
select b.Term_Code,
count(c.Term_Id) as "Count of Vendor Bills by Term Code"
from AP_Vendor a, AR_Term b, AP_Invoice c
Where c.Term_Id = b.Term_Id
AND a.Vendor_Id = C.Vendor_Id
and a.Vendor_Id > 1
Group by b.Term_Code, c.Term_Id
Order by b.Term_Code
