SELECT S.ID FROM PLMProduceServices S JOIn PLMJOInputItems II ON (S.JOInputItem_ID = II.ID) JOIN PLMJONodes N ON (II.Owner_Id = N.Id) WHERE N.Parent_ID = :JobOrder_ID AND (S.SN_ID = :JobOrdersSN_ID OR S.SN_ID IS NULL)
Generated by ABRA Software a.s. 27.10.2021 16:34:49