How to fetch MFR Parts

Hi, 

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. 

Thanks,

Surya

Agile Talent Asked on March 6, 2020 in Product Collaboration.
Add Comment
2 Answer(s)

Hi Surya,

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);

Regards,

Arif

Agile Angel Answered on March 10, 2020.
Add Comment

Hello Surya

I don’t think you can do thro’ SDK. You could get this list thro’ SQL

– Raj

Agile Angel Answered on March 10, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.