X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIC.pm;h=aaae3491fff2a6f96e32ba74b15dbea842403f27;hb=5b2980ad49f1937786d25f10fa9dac43cf255eb0;hp=8c2242d484ab8f1c9986d33ad39b1ec34cef9aea;hpb=594f0e999af123b4aea75f70b19a03585838a748;p=kivitendo-erp.git diff --git a/SL/IC.pm b/SL/IC.pm index 8c2242d48..aaae3491f 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -70,9 +70,6 @@ sub get_part { $form->{onhand} *= 1; - my %oid = ('Pg' => 'a.oid', - 'Oracle' => 'a.rowid'); - # part or service item $form->{item} = ($form->{inventory_accno}) ? 'part' : 'service'; if ($form->{assembly}) { @@ -88,7 +85,7 @@ sub get_part { LEFT JOIN partsgroup pg ON (p.partsgroup_id = pg.id) LEFT JOIN price_factors pfac ON pfac.id = p.price_factor_id WHERE (a.id = ?) - ORDER BY $oid{$myconfig->{dbdriver}}|; + ORDER BY a.oid|; $sth = prepare_execute_query($form, $dbh, $query, conv_i($form->{id})); $form->{assembly_rows} = 0;