Objektová akce

Popis:

Vrátí data výroby agregované za operaci.

Kód:

8

Tělo:

SELECT O.JOBORDERSROUTINES_ID,JR.TITLE, SUM(O.QUANTITY),MIN(O.STARTEDAT$DATE),MAX(O.FINISHEDAT$DATE),SUM(O.TOTALTIME),JR.BATCH FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOO ON JOO.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJOBORDERSROUTINES JR ON JR.PARENT_ID = JOO.ID 
JOIN PLMOPERATIONS O ON O.JOBORDERSROUTINES_ID = JR.ID
WHERE FP2.GENESIS_ID = :OBJID AND ((o.JOBORDERSSN_ID = FP2.JOBORDERSSN_ID) OR (JR.BATCH = 'A'))
GROUP BY O.JOBORDERSROUTINES_ID, JR.POSINDEX, JR.TITLE, JR.BATCH
ORDER BY JR.POSINDEX ASC

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