Třídová akce

Popis:

Výkon OK

Kód:

62

Tělo:

select
  sys.ID
from
  sys$posdocumentsopened sys
  join posdocuments pd on pd.id=sys.id
  left join periods pe on pe.id=pd.period_id
  join docqueues dq on dq.id=pd.docqueue_id
where
  ((sys.Opened = 'A') or
   (sys.IsPayChange = 'A')) and
  PD.sellingstand_id || '' is null and
  PD.ID like :SiteMask
order by
  dq.code,  pd.OrdNumber,  pe.code

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