Objektová akce

Kód:

8

Tělo:

SELECT {FIELDS}
FROM PartialInvProtocolPositions A
JOIN MAININVPROTOCOLPOSITIONS mp on mp.ID = a.MIPPOSITION_ID
JOIN LOGSTOREPOSITIONS lsp on lsp.id = mp.STOREPOSITION_ID
WHERE A.Parent_ID =:OBJID and a.id in
(select pipr.PIPPOSITION_ID
   from PARTIALINVPROTOCOLROWS pipr
   where pipr.REALQUANTITY = 0 and pipr.PIPPOSITION_ID is not NULL)
ORDER BY lsp.code

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