Objektová akce

Kód:

24

Tělo:

SELECT mipb.STOREBATCH_ID, sum(mipb.DOCUMENTEDQUANTITY), sum(mipb.REALQUANTITY)
FROM MAININVPROTOCOLROWS mipr
JOIN MAININVPROTOCOLBATCHES mipb on mipb.PARENT_ID = mipr.ID
WHERE mipr.PARENT_ID = :OBJID AND mipr.STORECARD_ID = :AStoreCard_ID
GROUP BY mipb.STOREBATCH_ID

Generated by ABRA Software a.s. 27.10.2021 16:34:10