From 7eae8facf962ddf359ab295b0e402c142be31548 Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Wed, 9 May 2007 08:34:26 +0000 Subject: [PATCH] Kosmetik. --- SL/IS.pm | 15 +++++---------- 1 file changed, 5 insertions(+), 10 deletions(-) diff --git a/SL/IS.pm b/SL/IS.pm index e703fcc7b..c37b1aa82 100644 --- a/SL/IS.pm +++ b/SL/IS.pm @@ -1370,16 +1370,11 @@ sub retrieve_invoice { $query = qq|SELECT - (SELECT c.accno FROM chart c - WHERE d.inventory_accno_id = c.id) AS inventory_accno, - (SELECT c.accno FROM chart c - WHERE d.income_accno_id = c.id) AS income_accno, - (SELECT c.accno FROM chart c - WHERE d.expense_accno_id = c.id) AS expense_accno, - (SELECT c.accno FROM chart c - WHERE d.fxgain_accno_id = c.id) AS fxgain_accno, - (SELECT c.accno FROM chart c - WHERE d.fxloss_accno_id = c.id) AS fxloss_accno, + (SELECT c.accno FROM chart c WHERE d.inventory_accno_id = c.id) AS inventory_accno, + (SELECT c.accno FROM chart c WHERE d.income_accno_id = c.id) AS income_accno, + (SELECT c.accno FROM chart c WHERE d.expense_accno_id = c.id) AS expense_accno, + (SELECT c.accno FROM chart c WHERE d.fxgain_accno_id = c.id) AS fxgain_accno, + (SELECT c.accno FROM chart c WHERE d.fxloss_accno_id = c.id) AS fxloss_accno, d.curr AS currencies ${query_transdate} FROM defaults d|; -- 2.20.1