Třídová akce

Popis:

Potenciální skladové karty polotovaru

Kód:

42

Tělo:

SELECT RN.STORECARD_ID FROM PLMWORKSCHEDULEITEMS WS
JOIN PLMREQROUTINES RR ON  WS.REQROUTINE_ID = RR.ID 
JOIN PLMREQOUTPUTITEMS RO ON RR.PARENT_ID = RO.ID
JOIN PLMREQNODES RN ON RO.OWNER_ID = RN.ID
WHERE WS.ID = :WSIOID AND RR.FINISHED = 'A'
UNION
SELECT JN.STORECARD_ID FROM PLMWORKSCHEDULEITEMS WS
JOIN PLMJOBORDERSROUTINES JR ON  WS.JOROUTINE_ID = JR.ID 
JOIN PLMJOOUTPUTITEMS JO ON JR.PARENT_ID = JO.ID
JOIN PLMJONODES JN ON JO.OWNER_ID = JN.ID
WHERE WS.ID = :WSIOID AND JR.FINISHED = 'A'

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