Třídová akce

Kód:

16

Tělo:

SELECT
  FLOOR(OP.FinishedAt$Date),
  OP.Division_ID,
  OP.BusOrder_ID,
  OP.BusTransaction_ID,
  OP.BusProject_ID,
  JO.ID, 
  JO.DocQueueForAWT_ID,
  JO.AccPresetDef_ID
FROM PLMOperations OP
JOIN PLMJobOrdersRoutines JOR  ON JOR.ID = OP.JobordersRoutines_ID
JOIN PLMJOOutputItems MI ON MI.ID = JOR.Parent_ID
JOIN PLMJONodes N ON N.ID = MI.Owner_ID
JOIN PLMJobOrders JO ON JO.ID = N.Parent_ID
WHERE
  OP.AggregateWorkTicket_ID IS NULL AND
  (Op.FinishedAt$Date<>0) AND
  (Op.Cooperation <> 'A') AND
  (Op.FinishedAt$Date < :InDate)
GROUP BY
  FLOOR(op.FinishedAt$Date), OP.Division_ID, OP.BusOrder_ID, OP.BusTransaction_ID,
  OP.BusProject_ID, JO.ID, JO.DocQueueForAWT_ID, JO.AccPresetDef_ID

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