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

[DarshanT]

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

[BhushanNehe]

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

[DarshanT]

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]

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]

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