select DQ.Code from ReceivedInvoices RI join DocQueues DQ on DQ.ID = RI.DocQueue_ID left join Periods DQP on DQP.ID = DQ.LastOpenPeriod_ID where RI.ID in (select RCN.Source_ID from ReceivedCreditNotes RCN where RCN.ID = :OID) and DQP.DateTo$Date > (select P.DateTo$Date from Periods P where P.ID = :PeriodOID)
Generated by ABRA Software a.s. 27.10.2021 16:34:08