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

We are happy to announce the new Windchill Customization board! Learn more.

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

DarshanT
1-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
BhushanNehe
14-Alexandrite
(To:DarshanT)

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

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

BhushanNehe
14-Alexandrite
(To:DarshanT)

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

DivyaB
4-Participant
(To:DarshanT)

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