Objektová akce

Kód:

1

Tělo:

select a.OrdNumber, b.Code, c.Code, lsp.code
    from MainInvProtocols a
    join DocQueues b on a.DocQueue_ID=b.id
    join Periods c on a.Period_ID=c.id
    join MAININVPROTOCOLPOSITIONS p on p.PARENT_ID = a.ID
    join LOGSTOREPOSITIONS lsp on lsp.id = p.STOREPOSITION_ID
    where  p.id=:OBJID

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