How to fetch MFR Parts
I want to fetch the MFR Parts, in where used of MFR Part, there should be no Item associated, how to fetch those MFR Parts using SDK.
There is no Iquery we can form for this condition as MFR Part and Item are donot associate in advance search.
Simple query as shown below should be helpful to find MPN without Where-Used-Items
Select distinct m.id,m.part_number from Manu_Parts m where delete_flag is null
and m.id not in (Select distinct manu_part from manu_by mb where mb.active=1);