Třídová akce

Kód:

10

Tělo:

SELECT
  (DQ.Code || '-' || CAST(PO.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName
FROM PaymentOrders PO
JOIN Docqueues DQ on DQ.ID = PO.Docqueue_ID
JOIN Periods P on P.ID = PO.Period_Id
WHERE PO.ID IN (SELECT PO2.Parent_ID FROM PaymentOrders2 PO2
WHERE PO2.ID IN (SELECT PO3.Parent_ID FROM PaymentOrders3 PO3 WHERE PO3.PDocumentType=
'04' AND PO3.PDocument_ID=:PDocument_ID))

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