SELECT COALESCE(SUM(FP2.QUANTITY),0) AS PRODUCEDQUANTITY FROM PLMFINISHEDPRODUCTS2 FP2 JOIN PLMJOBORDERSSN SN ON SN.ID = FP2.JOBORDERSSN_ID WHERE SN.STOREBATCH_ID = :BATCH_ID
Generated by ABRA Software a.s. 27.10.2021 16:34:49