Třídová akce

Kód:

9

Tělo:

SELECT
#ORA
  /*+ index(A RECEIVEDORDERS2_SCARD) */
#ALL
  SUM(A.Quantity - A.DeliveredQuantity)
FROM ReceivedOrders2 A
#MS
  WITH (INDEX(ReceivedOrders2_SCard))
#ALL
JOIN ReceivedOrders 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:11