Objektová akce

Kód:

21

Tělo:

/* veškeré skladové doklady VMV, PHV, VRM */
SELECT 
  DISTINCT sd.DocumentType, sd.ID
FROM
  PLMJobOrders A
  JOIN StoreDocuments2 sd2 on sd2.ProductionTask_ID = a.ProductionTask_ID
  JOIN StoreDocuments sd on sd.ID = sd2.Parent_ID
WHERE
  A.ID = :OBJID and ( sd.DocDate$DATE > :FinishedDATE ) 

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