Get inventory transactions related to given production order [SQL]

SELECT o.REFERENCEID, o.INVENTTRANSID, i.RECID, i.ITEMID, i.QTY, i.STATUSISSUE, i.TRANSCHILDREFID, i.TRANSCHILDTYPE
FROM dbo.INVENTTRANS AS i
JOIN dbo.INVENTTRANSORIGIN AS o ON o.PARTITION = i.PARTITION AND o.DATAAREAID = i.DATAAREAID AND o.recid = i.INVENTTRANSORIGIN
WHERE i.TRANSCHILDTYPE = 2 -- Picking list journal line
AND i.TRANSCHILDREFID != ''
AND NOT EXISTS (SELECT * FROM dbo.PRODJOURNALBOM AS b
      WHERE b.PARTITION  = i.PARTITION
        AND b.DATAAREAID = i.DATAAREAID
        AND b.INVENTTRANSCHILDREFID = i.TRANSCHILDREFID)