X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FOE.pm;fp=SL%2FOE.pm;h=0492ef37d837a2c42c081af98384fd5c52bfdb7a;hb=99382a645d0cfbc0ded9c48564700f80e9a6f932;hp=5665b04bd2e12fa1def32521cbef17b2efb28f56;hpb=ad4a0fc9c11ed0246a659950e1c8bbdd5ef5f396;p=kivitendo-erp.git diff --git a/SL/OE.pm b/SL/OE.pm index 5665b04bd..0492ef37d 100644 --- a/SL/OE.pm +++ b/SL/OE.pm @@ -105,7 +105,7 @@ sub transactions { FROM record_links rl1 JOIN record_links rl2 ON (rl1.to_table = rl2.from_table AND rl1.to_id = rl2.from_id) JOIN record_links rl3 ON (rl2.to_table = rl3.from_table AND rl2.to_id = rl3.from_id) - WHERE (rl1.from_table = 'oe') AND rl2.to_table = 'ar' + WHERE rl1.from_table = 'oe' AND rl2.to_table = 'ar' AND rl3.to_table = 'ar' ) rl LEFT JOIN ar ON ar.id = rl.to_id