Třídová akce

Kód:

6

Tělo:

SELECT 
  sd.ID, sd2.ID,
  sd2.Quantity * sd2.flowsign * -1,
  (SELECT SUM(DRB.Quantity ) * sd2.flowsign * -1 
     FROM DocRowBatches DRB
     LEFT JOIN StoreBatches SB on (DRB.StoreBatch_ID = SB.ID)
     WHERE DRB.parent_id = sd2.ID
       AND SB.name = :SERNO
  ),
  (SELECT SUM(DRB.Quantity ) * sd2.flowsign * -1
     FROM DocRowBatches DRB
     LEFT JOIN StoreBatches SB on (DRB.StoreBatch_ID = SB.ID)
     WHERE DRB.parent_id = sd2.ID
       AND SB.name <> :SERNO
  ),
  sd2.RDocumentRow_ID
FROM
  PLMJobOrders JO
  JOIN StoreDocuments2 sd2 on sd2.ProductionTask_ID = JO.ProductionTask_ID
  JOIN StoreDocuments sd on sd.ID = sd2.Parent_ID
  LEFT JOIN DocRowBatches DRB on (DRB.parent_id = sd2.ID)
  LEFT JOIN StoreBatches SB on (DRB.StoreBatch_ID = SB.ID)
WHERE JO.ID = :JOID
  AND sd2.flowType IN ('27', '29')
  AND sd2.StoreCard_ID = :SCID
GROUP BY sd.ID, sd2.ID, sd2.Quantity, sd2.flowsign, sd2.RDocumentRow_ID

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