SELECT DISTINCT
PSD.documenttype, PSD.document_id
FROM
possummareddocuments5 PSD
WHERE
Psd.parent_id = :OBJID
union
select distinct
cast('PD' as varchar(2)), pd.id
from
posdocuments pd
where
pd.possummareddocument_id = :OBJID
union
select DISTINCT
'PH', POSShift_ID
FROM
POSSummaredDocuments
WHERE
POSShift_ID is NOT NULL
AND ID = :OBJID Generated by ABRA Software a.s. 27.10.2021 16:34:30