"Where Used" from Part Tracker - Can I recreate this View with Query?

Epicor ERP 10
1

Hello all,

I would like to create a query that delivers the same results as the “Where Used” function in Part Tracker. I assume this is a SQL view? Can anybody tell me what tables I might use to query the larger assemblies that a component part is used in?

1
1.png1251×742 43.6 KB

Any insight would be awesome.

Thanks,

Alice

2

It’s a simple query - you can just do it in a BAQ.

select *
from erp.PartMtl
where MtlPartNum = ‘your part number’

1 Like
3

Search in BAQ’s for zPartWhereUsed . You’ll find (4) BAQ’s that you can play with.
You have to make a copy to edit them.

1 Like