Třídová akce

Kód:

8

Tělo:

SELECT O.ID, FLOOR(O.FinishedAt$Date)
FROM PLMOperations O 
JOIN PLMJobOrdersRoutines JOR ON JOR.ID=O.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 (O.FinishedAt$Date<>0) AND (O.FinishedAt$Date < :InDate) AND (O.AggregateWorkTicket_ID IS NULL) AND (O.Cooperation <> 'A')
ORDER BY 2, JO.ID, O.Division_ID, O.BusOrder_ID, O.BusTransaction_ID, O.BusProject_ID

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