Index: openacs-4/packages/invoices/tcl/offer-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/tcl/offer-procs.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/invoices/tcl/offer-procs.xql 14 Dec 2005 22:06:38 -0000 1.7 +++ openacs-4/packages/invoices/tcl/offer-procs.xql 27 Dec 2005 16:39:35 -0000 1.8 @@ -71,7 +71,7 @@ to_char(t.accepted_date, 'YYYY-MM-DD HH24:MI:SS') as accepted_date, t.amount_sum, t.payment_days, t.date_comment, t.currency, t.organization_id, pr.title as project_title, ci.item_id as offer_id, - pp.project_code, pi.item_id as project_id + pp.project_code, pi.item_id as project_id, pp.contact_id from iv_offers t, cr_revisions cr, cr_items ci, acs_objects o, persons p, acs_data_links r, cr_items pi, cr_revisions pr, pm_projects pp where cr.revision_id = t.offer_id