SELECT JO.ID AS ID1,MI.ID AS ID2 FROM PLMJobOrders JO JOIN PLMJONodes N ON JO.ID = N.Parent_ID JOIN PLMJOOutputItems MI ON N.ID = MI.Owner_ID JOIN PLMJobOrdersSN SN ON MI.ID = SN.Parent_ID JOIN StoreBatches SB ON SB.ID = SN.StoreBatch_ID WHERE SB.Name = :SerialNumber
Generated by ABRA Software a.s. 27.10.2021 16:34:49