SELECT CoopSN.ID FROM PLMCooperations Coop JOIN (PLMCoopOutputItems CoopMI JOIN (PLMCoopSN CoopSN JOIN (PLMJobOrdersSN SN JOIN StoreBatches SB ON SB.ID = SN.StoreBatch_ID) ON SN.ID = CoopSN.SN_ID) ON CoopMI.ID = CoopSN.Parent_ID) ON Coop.ID = CoopMI.Parent_ID WHERE SB.Name = :SerialNumber AND Coop.ID = :Coop_ID AND CoopMI.ID = :MI_ID
Generated by ABRA Software a.s. 27.10.2021 16:34:49