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.
For Substitute link you can query WTPARTSUBSTITUTELINK - IDA3B5 which has information related to all WTPartMasters. Similarly for alternate link you can query WTPARTALTERNATELINK.
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.
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.