Objektová akce

Kód:

4

Tělo:

/* Nabidky vydane */
SELECT 
  DISTINCT 'IF', B.Parent_ID
FROM
  PLMProduceRequests A
  JOIN IssuedOffers2 B ON A.ID = B.CostSourceDoc_ID
WHERE
  A.ID = :OBJID AND
  B.CostSourceDocType = 'PQ' AND 
  B.Revided_ID is null 
 
 UNION ALL
 
 /* Vyrobni prikazy */
SELECT 
  'JO', A.JobOrder_ID
FROM
  PLMProduceRequests A
WHERE
  A.ID = :OBJID AND 
  A.JOBORDER_ID IS NOT NULL

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