Skip to main content
D
DarshanT1-Visitor
1-Visitor
February 16, 2016
Question

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

  • February 16, 2016
  • 2 replies
  • 3283 views

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

2 replies

B
BhushanNehe16-Pearl
16-Pearl
February 16, 2016

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

D
DarshanT1-VisitorAuthor
1-Visitor
February 16, 2016

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

B
BhushanNehe16-Pearl
16-Pearl
February 16, 2016

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

D
DivyaB1-Visitor
1-Visitor
August 31, 2019
Hi Sir
Did u get any solution for this ???
Terms & ConditionsAccessibility statement