Třídová akce

Popis:

Vrátí všechny vazby mezi úkony z daného požadavku na výrobu

Kód:

5

Tělo:

SELECT R.PARENT_ID,R.PREVIOUSWSI_ID FROM PLMWSIRELATIONS R
JOIN PLMWORKSCHEDULEITEMS W ON W.ID = R.PARENT_ID
JOIN PLMREQROUTINES RR ON RR.ID = W.REQROUTINE_ID
JOIN PLMREQOUTPUTITEMS RO ON RO.ID = RR.PARENT_ID
JOIN PLMREQNODES RN ON RN.ID = RO.OWNER_ID
WHERE RN.PARENT_ID = (SELECT RN1.PARENT_ID FROM PLMWORKSCHEDULEITEMS W1
  JOIN PLMREQROUTINES RR1 ON RR1.ID = W1.REQROUTINE_ID
  JOIN PLMREQOUTPUTITEMS RO1 ON RO1.ID = RR1.PARENT_ID
  JOIN PLMREQNODES RN1 ON RN1.ID = RO1.OWNER_ID
  WHERE W1.ID = :WSI_ID) 
ORDER BY 
 (CASE
    WHEN :COLUMNNUMBER = 1 THEN R.PARENT_ID
    ELSE R.PREVIOUSWSI_ID
  END) 

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