Objektová akce

Kód:

11

Tělo:

SELECT DISTINCT
  '20', SD2.Parent_ID
FROM ReceivedOrders2 RO2
JOIN StoreDocuments2 SD2 ON SD2.ProvideRow_ID = RO2.ID AND SD2.ProvideRowType = 'RO'
JOIN StoreDocuments SD ON SD.ID = SD2.Parent_ID AND SD.DocumentType = '20'
WHERE
  RO2.Parent_ID = :OBJID  

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