Třídová akce

Kód:

15

Tělo:

select
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName,
  a.DocDate$Date as Date$Date,
  a.ID as ID
from IssuedOrders a,DocQueues b, Periods c 
where
  a.DocQueue_ID=b.id and a.Period_ID=c.id and
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code)=:DocNumber and
  (a.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:Firm_ID or Firm_ID=:Firm_ID)) and 
  a.Revided_ID IS NULL

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