Třídová akce

Kód:

3

Tělo:

SELECT 
  C.ID as ID,
  (DQ.Code || '-' || CAST(C.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  B.Quantity as Quantity,
  B.QUnit as QUnit,
  B.UnitRate as UnitRate,
  B.RequestedDeliveryDate$Date as RequestedDeliveryDate
FROM 
  DemandAnswers A, DemandSheets2 B, DemandSheets C,
  DocQueues DQ, Periods P
WHERE   
  A.IssuedDemand2_ID = :IssuedDemand2_ID and
  A.IssuedDemand2_ID IS NOT NULL and
  B.ID = A.Parent_ID and
  C.ID = B.Parent_ID and
  C.DocQueue_ID = DQ.ID and 
  C.Period_ID = P.ID

Generated by ABRA Software a.s. 27.10.2021 16:35:50