Part Parent

bradberkobien · September 30, 2019, 4:08pm

I have a part’s revision checked out through the engineering workbench. I have a PartNum and a RevisionNum of the checked out part. I need to grab the parent part and it’s site. Can’t seem to find an endpoint to do such. Any help would be appreciated!

Banderson · September 30, 2019, 4:10pm

You’re going to need more detail about what you are trying to do. BAQ? REST? Something else?

bradberkobien · September 30, 2019, 4:11pm

I would love to do REST but I don’t think we have it configured?

josecgomez · September 30, 2019, 4:12pm

You don’t have REST setup according to @hkeric.wci. But you should get it working cause it is awesome.

bradberkobien · September 30, 2019, 4:13pm

Where’s the API located? and I’d like to set it up. What’s the appx amount of time to set it up?

josecgomez · September 30, 2019, 4:14pm

Epicor SaaS MT is what your Profile says but that’s not true right?
@hkeric.wci they MT? No way!

If you are MT you are SOL Epicor has to do it for you

Banderson · September 30, 2019, 4:16pm

How about you just start with a BAQ. No matter what you do, you’re going to need to understand the schema.

bradberkobien · September 30, 2019, 4:30pm

Here’s the SQL query I ran to figure out the solution to my problem…

select pr.PartNum, pr.plant, pr.RevisionNum from ERp.Part p
inner join Erp.PartRev pr on p.PartNum = pr.PartNum
where p.PartNum = 'PART-NAME'

I was checking out a Revision for the part and just needed it’s site so that I can pass it down to mtl parts.

hkeric.wci · September 30, 2019, 4:45pm

Yeah they are on-prem not MT SaaS.

bradberkobien · September 30, 2019, 4:50pm

I copied Haso’s intro. That’d explain it

bradberkobien · September 30, 2019, 4:52pm

select p.Company, p.PartNum, pp.plant as PartRevPlant from ERp.Part p
inner join Erp.PartPlant pp on p.PartNum = pp.PartNum
where p.PartNum = 'wagonwheel' and p.Company = '01800000'

Why is this pulling back all available Part Plants and not just ones assigned?

Banderson · September 30, 2019, 4:57pm

If you go to part entry for that part number, which sites do you see there?

bradberkobien · September 30, 2019, 4:59pm

hkeric.wci · September 30, 2019, 5:03pm

Its pulling in more because in your join you are not joining on the Company.

However, I don’t think that is what you want… You might be more interested in your scenario with the Site: drop-down on the Revision Tab (which is different than PartPlant).


-- Also Check if you need to use pr.AltMethod
SELECT pr.Company, pr.PartNum, pr.RevisionNum, pr.Plant, * FROM Erp.PartRev pr WHERE pr.Company = '01800000' and pr.PartNum = 'wagonwheel' and pr.RevisionNum = 'A'

bradberkobien · September 30, 2019, 5:45pm

Hmmmmmm I’m going to have to figure out how to grab it from the screen in Epicor. Where can I find a list of options for EpiDataView’s

anon75023439 · September 30, 2019, 5:49pm

Check the object explorer.

bradberkobien · September 30, 2019, 5:50pm

I found them

bradberkobien · September 30, 2019, 5:50pm

thank you!

bradberkobien · September 30, 2019, 6:46pm

I need to grab these two plants somehow based on the partnum

bradberkobien · September 30, 2019, 6:48pm

@josecgomez I was trying to extract and get the data through an EpiDataView (ECORev)