select (b.Code || '-' || CAST(d.OrdNumber AS VARCHAR(10)) || '/' || c.Code || '-' || AC.Code || ' (' || A.Name || ')' )
from AssetInvListResults A
join AssetInvLists AL on AL.ID = A.Parent_ID
join AssetInv D on D.ID = A.AssetInv_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 = AL.Committee_ID
where
A.ID = :OBJID
Generated by ABRA Software a.s. 27.10.2021 16:34:24