SF.net SVN: ledger-smb:[2947] addons/1.3/assets/trunk/sql/modules/Assets. sql

[..hidden..]

Revision: 2947
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2947&view=rev
Author:   einhverfr
Date:     2010-03-03 19:35:04 +0000 (Wed, 03 Mar 2010)

Log Message:
-----------
Correcting one error in disposal approval functions

Modified Paths:
--------------
    addons/1.3/assets/trunk/sql/modules/Assets.sql

Modified: addons/1.3/assets/trunk/sql/modules/Assets.sql
===================================================================
--- addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-03-03 19:31:25 UTC (rev 2946)
+++ addons/1.3/assets/trunk/sql/modules/Assets.sql	2010-03-03 19:35:04 UTC (rev 2947)
@@ -572,7 +572,7 @@
   SELECT a.dep_account_id, currval('id')::int, sum(r.accum_depreciation),
          TRUE, r.disposed_on
     FROM get_disposal_report($1) r
-    JOIN asset_item ai ON (r.id = ai.id)
+    JOIN asset_item a ON (r.id = a.id)
 GROUP BY a.dep_account_id, r.disposed_on;
 
   INSERT
@@ -589,7 +589,7 @@
   SELECT a.asset_account_id, currval('id')::int, sum(r.purchase_value),
          TRUE, r.disposed_on
     FROM get_disposal_report($1) r
-    JOIN asset_item ai ON (r.id = ai.id)
+    JOIN asset_item a ON (r.id = a.id)
 GROUP BY a.asset_account_id, r.disposed_on;
 
   SELECT TRUE;


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