Find Lifecycles assign to an object

[BenLoosli]

Version: Windchill 13.0

Use Case: Determine the lifecycle associated with an object in Windchill.

Description:

We have multiple Lifecycles from the original administrator and I'm trying to find which ones have been used by objects so I can reduce the number of old lifecycles.

Is there a method to do a search in Windchill by Lifecycle to return which objects it is associated with?

My second possible search would be in the Oracle tables but I don't really have any idea where to start with them in SQLDeveloper. I do have a test system that I can play with so all my production data is safe.

[Shreyas_Atre]

try with below SQL 
SELECT
pm.WTPARTNUMBER AS "Part Number",
ltm.name AS "Lifecycle Name",
lt.ITERATIONIDA2ITERATIONINFO AS "Lifecycle Version"
FROM
WTPart p
JOIN wtpartMaster pm ON pm.ida2a2 = p.IDA3MASTERREFERENCE
JOIN LifeCycleTemplate lt ON lt.ida2a2 = p.ida3a2state
JOIN LifeCycleTemplateMaster ltm ON ltm.ida2a2 = lt.IDA3MASTERREFERENCE;

also you can create QML report to get the details of lifecycle assigned to object. attached is sample report for WTPART. 

Hope this helps.

Thanks

[joe_morton]

You can also do this using query builder. It's just a join from the Life Cycle Template, to the object: