Třídová akce

Kód:

18

Tělo:

SELECT
  A.ID, 
  A.LocalTAmount, 
  CASE 
    WHEN (A.FlowType IN ('24', '37')) THEN 
      A.ProvideRow_ID 
    ELSE 
      A.RDocumentRow_ID 
  END AS RDocumentRow_ID,
  A.Quantity, 
  A.Store_ID, 
  A.StoreCard_ID, 
  A.Parent_ID,
  A.CompletePrices, 
  PMS.SystemState AS PMSystemState,
  A.ProductionTask_ID,
  A.FlowType AS DocumentType,
  A.FlowSign,
  A.PriceTransformationCoefficient, 
  PP.Quantity as PPQuantity,
  PP.LocalAmount as PPLocalAmount,
  PP.PosIndex as PPPosIndex,
  A.Valuated,
  A.EtalonRate
FROM StoreDocuments2 A
JOIN PMStates PMS ON A.PMState_ID = PMS.ID
LEFT JOIN StoreDocumentPriceParts PP on PP.Parent_ID = A.ID
WHERE
  (
  (A.RDocumentRow_ID = :RDocumentRow_ID)
  OR 
  ((A.PROVIDEROW_ID = :RDocumentRow_ID) AND (A.FlowType IN ('24', '37')))
  )
   AND
  A.ClosingOrder > 0

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