Objektová akce

Kód:

2

Tělo:

 /* Vyrobni prikazy */
SELECT
  'JO', N.Parent_ID
FROM
  PLMOperations A
  JOIN PLMJobOrdersRoutines R ON (A.JobOrdersRoutines_ID = R.ID)
  JOIN PLMJOOutputItems O ON (R.Parent_ID = O.ID)
  JOIN PLMJONodes N ON (O.Owner_ID = N.ID)
WHERE
  A.AGGREGATEWORKTICKET_ID = :OBJID
GROUP BY
  N.Parent_ID

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