Třídová akce

Kód:

8

Tělo:

SELECT
#ORA
  /*+ index(A ISSUEDORDERS2_SCARD) */
#ALL
  SUM(A.Quantity - A.DeliveredQuantity)
FROM IssuedOrders2 A
#MS
  WITH (INDEX(IssuedOrders2_SCard))
#ALL
JOIN IssuedOrders B ON B.ID = A.Parent_ID
where
  A.StoreCard_ID = :StoreCard_ID AND
  A.Store_ID IN {SelSQLStoreIDs} AND
  A.Quantity > A.DeliveredQuantity AND
  B.Confirmed = 'A' AND
  B.Closed = 'N' AND
  B.Revided_ID IS NULL

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