Třídová akce

Kód:

8

Tělo:

select DISTINCT
  (DQ.Code || '-' || CAST(RO.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  RO.Description as Description,
  RO.DocDate$Date as Date$Date,
  RO.ID as ID,
  RO.Firm_ID as FirmID
from
  ReceivedOrders RO
  join ReceivedOrders2 RO2 on RO2.Parent_ID = RO.ID
  join DocQueues DQ on DQ.ID = RO.DocQueue_ID
  join Periods P on P.ID=RO.Period_ID
where 
  (RO.DocDate$DATE >= :DateFrom) and (RO.DocDate$DATE < :DateTo + 1)
  and RO2.Division_ID=:ID
  and RO.Revided_ID IS NULL

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