How to extract details of Manufacturers tab attributes for a Part via SQL?
I’m writing SQL to extract the details of Manufactures tab attributes for a PART object. the name of the Mfr and Part Num are coming from different tables. However, I couldn’t find the link between the Part number and Mfr Name. Any guidance to resolve this will be helpful.
SELECT MP.PART_NUMBER, M.NAME
FROM AGILE.MANUFACTURERS M
INNER JOIN AGILE.MANU_PARTS MP ON M.ID = MP.MANU_ID
INNER JOIN AGILE.MANU_BY MB ON MP.ID = MB.MANU_PART
INNER JOIN AGILE.ITEM I ON MB.AGILE_PART = I.ID
WHERE MB.PREFER_STATUS = 1
AND MB.CHANGE_OUT = 0
AND I.ITEM_NUMBER = :ITEMNUMBER