Objektová akce

Popis:

Poptávkový list - název

Kód:

2

Tělo:

 SELECT DQ.code||'-'||CAST(C.ordnumber AS VARCHAR(10))||'/'||P.code
 FROM IssuedDemands2 A
 LEFT OUTER JOIN DemandAnswers DA ON (DA.IssuedDemand2_id = A.ID)
 LEFT OUTER JOIN DemandSheets2 DS2 ON (DS2.ID = DA.Parent_ID)
 LEFT OUTER JOIN DemandSheets  C ON (C.ID = DS2.Parent_ID)
 LEFT OUTER JOIN DocQueues DQ ON (C.DocQueue_ID = DQ.ID)
 LEFT OUTER JOIN Periods P ON (C.Period_ID = P.ID)
WHERE A.ID =:OBJID

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