cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

how to know if WTMasterPart is used as Alternate or Substitute part

Highlighted
Newbie

how to know if WTMasterPart is used as Alternate or Substitute part

Hello,

In my requirement I want to clean up certain type of parts from Windchill but before we clean up I want to know if the WTPartMasterPart is used as Alternate part or Substitute part for some other part.

Any API's or Query report would help me.

Thanks,

Manjunath Reddy

4 REPLIES 4

Re: how to know if WTMasterPart is used as Alternate or Substitute part

Hi Manjunath,

For Substitute link you can query  WTPARTSUBSTITUTELINK - IDA3B5 which has information related to all WTPartMasters. Similarly for alternate link you can query WTPARTALTERNATELINK.

Regards,

Bhushan

Re: how to know if WTMasterPart is used as Alternate or Substitute part

Hi Bhushan,

Does this give where the part is used as substitute and alternative right?

Just for confirmation: IF I have part number# 123456

I want to know where the part 123456 is used as alternate, substitute part. Like as substitute/alternative of another part say 165423.


Thanks,

Manjunath Reddy

Re: how to know if WTMasterPart is used as Alternate or Substitute part

I haven't  tried, but a quick look at the database schema suggests there is a link from WTPARTSUBSTITUTELINK to WTPartUsageLink and you should be able to find the required relation . Also i guess with WTPARTALTERNATELINK the information is available directly in the same table.

Regards,

Bhushan

Re: how to know if WTMasterPart is used as Alternate or Substitute part

Hi Sir
Did u get any solution for this ???