Objektová akce

Kód:

17

Tělo:

SELECT A.ID
FROM StoreDocuments2 A
WHERE A.Parent_ID = :OBJID
  AND (
    A.RowType IN (0, 1)
    OR (
      A.RowType IN (2, 3)
      AND (
/* podle TNxBillOfDeliveryRow.GetIsAvailableForDelivery a TNxBillOfDeliveryRow.InternalUnattachedRefundedQuantity */
        A.Quantity > A.DeliveredQuantity + (SELECT COALESCE(SUM(SD2.Quantity), 0) FROM StoreDocuments2 SD2 WHERE SD2.RDocumentRow_ID = A.ID AND SD2.DeliveredQuantity = 0)
        )
      )
    )

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