Třídová akce

Kód:

50

Tělo:

SELECT PREVIOUSWSI_ID, COALESCE(sc.PRIORITY, SCR.Priority, 0) AS StoreCardPriority FROM PLMWSIRELATIONS REL
JOIN PLMWorkScheduleItems WSI ON WSI.ID = REL.PREVIOUSWSI_ID
LEFT JOIN PLMJOBORDERSROUTINES jor ON jor.id = wsi.JOROUTINE_ID
LEFT JOIN PLMJOOUTPUTITEMS jooi ON jooi.id = jor.PARENT_ID
LEFT JOIN PLMJONODES JON ON JON.ID = jooi.OWNER_ID
LEFT JOIN storecards sc ON sc.id = JON.STORECARD_ID
LEFT JOIN PLMREQROUTINES RR ON RR.id = wsi.REQROUTINE_ID AND WSI.JOROUTINE_ID IS NULL 
LEFT JOIN PLMREQOUTPUTITEMS ROI ON ROI.id = RR.PARENT_ID
LEFT JOIN PLMREQNODES RN ON RN.ID = ROI.OWNER_ID
LEFT JOIN storecards SCR ON SCR.id =  RN.STORECARD_ID   
WHERE REL.PARENT_ID = :PARENT_ID
ORDER BY COALESCE(sc.PRIORITY, SCR.Priority, 0)

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