Objektová akce

Kód:

1

Tělo:

SELECT FIRST 1 
  A.ID, A.DeletedFromPriceList 
FROM StorePrices A 
LEFT JOIN PriceListValidities PLV on PLV.ID = A.PriceListValidity_ID
WHERE 
  A.PriceList_ID =:OBJID AND 
  A.StoreCard_ID = :StoreCard_ID AND
  COALESCE(PLV.ValidFromDate$DATE, 0.0) <= :OnTheDate
ORDER BY PLV.ValidFromDate$DATE DESC NULLS LAST

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