Třídová akce

Kód:

20

Tělo:

SELECT JOSN.Parent_ID as newMI, JOSN.ID, SB.Name, SC.Code, SC.Name
FROM PLMJobOrdersComponents JOComp
JOIN PLMJobOrdersSN JOSN ON JOComp.Component_ID = JOSN.StoreBatch_ID
JOIN StoreBatches SB ON JOComp.Component_ID = SB.ID
JOIN PLMJOInputItems MIPL ON JOComp.InputItem_ID = MIPL.ID
JOIN PLMJONodes N ON N.ID = MIPL.Owner_ID
JOIN StoreCards SC ON N.StoreCard_ID = SC.ID
WHERE
  JOComp.Parent_ID = :JOSN_ID

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