select cast('PI' as Varchar(2)), a.id
FROM
PartialInvProtocols a
WHERE
a.MainProtocol_id = :OBJID
union all
select sd.documenttype, sd.id
FROM
storedocuments sd
WHERE
(sd.documenttype = '25' or
sd.documenttype = '26') and
sd.masterdocclsid = 'KGKSPD2IGUXOV3V2JN0IILOSRG' and
sd.masterdocument_id = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:10