Objektová akce

Kód:

23

Tělo:

SELECT MIPR.StoreCard_ID, SC.Category, SUM(MIPR.DocumentedQuantity), SUM(MIPR.RealQuantity), MIN(MIPP.OrderFlow)
FROM MainInvProtocolRows MIPR
JOIN StoreCards SC on SC.ID = MIPR.StoreCard_ID
JOIN MainInvProtocolPositions MIPP ON MIPP.ID = MIPR.MIPPosition_ID
WHERE MIPR.Parent_ID = :OBJID
GROUP BY SC.Code, MIPR.StoreCard_ID, SC.Category
ORDER BY SC.Code

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