SF.net SVN: ledger-smb:[2241] trunk/sql/modules/Company.sql

[..hidden..]

Revision: 2241
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2241&view=rev
Author:   einhverfr
Date:     2008-08-07 23:06:25 +0000 (Thu, 07 Aug 2008)

Log Message:
-----------
Correcting get_billing_info function

Modified Paths:
--------------
    trunk/sql/modules/Company.sql

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2008-08-07 20:11:08 UTC (rev 2240)
+++ trunk/sql/modules/Company.sql	2008-08-07 23:06:25 UTC (rev 2241)
@@ -267,8 +267,8 @@
 		a.city, a.state, a.mail_code, cc.name
 	into out_var
 	FROM company c
-	JOIN company eca ON (eca.entity_id = c.entity_id)
-	JOIN company_to_location cl ON (eca.id = cl.credit_id)
+	JOIN entity_credit_account eca ON (eca.entity_id = c.entity_id)
+	JOIN eca_to_location cl ON (eca.id = cl.credit_id)
 	JOIN location a ON (a.id = cl.location_id)
 	JOIN country cc ON (cc.id = a.country_id)
 	WHERE eca.id = in_id AND location_class = 1;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.