FIND NAME of WTDocument SubType in SQL Windchill

[phsimard]

I am using Windchill PDMLink Release 11.1 and Datecode with CPS M020-CPS23

I cannot find the table that holds the SUB object types in Oracle SQL

Example: WTDocument:

I believe WTDocument.BRANCHIDA2TYPEDEFINTIONREFERENCE and
WTDOCUEMENT.IDA2TYPEDEFINITION REFERENCE hold the ID of the SUB TYPE of WTDocument.

However, I cannot find the table with which to join to get the UI NAME for those ID's.

[Fadel · Accepted solution]

try something  like below 

select wtm.name,wtm.wtpartnumber,wtd.logicalidentifier from wtpart wt,wtpartmaster wtm,wttypedefinition wtd
where wt.ida2typedefinitionreference =wtd.ida2a2 and wtm.ida2a2=wt.ida3masterreference and wtm.wtpartnumber like '0000001821'

[phsimard]

Nice thank you!