select coalesce(sum(sd2.quantity), 0) from plmjoborders jo join storedocuments2 sd2 on sd2.productiontask_id = jo.productiontask_id JOIN storedocuments sd on sd.id = sd2.parent_id where jo.id = :OBJID and sd.documenttype = '28' and sd2.completeprices = 'N'
Generated by ABRA Software a.s. 27.10.2021 16:34:49