Objektová akce

Kód:

7

Tělo:

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