Objektová akce

Kód:

1

Tělo:

select (b.Code || '-' || CAST(d.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code || '-' || AC.Code)
 from AssetInvLists A
 join AssetInv D on D.ID = A.Parent_ID
 join DocQueues B on B.ID = D.DocQueue_ID
 join Periods C on C.ID = D.Period_ID
 join AssetInvCommittees AC on AC.ID = A.Committee_ID
 where 
 A.ID = :OBJID

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