Find EPMDescribeLink by EPMDocument and WTPart

Hi Vasiliy,

You can try using both these to find the epmdescribelink:

WTPart's ida2a2 = EPMDescribeLink's ida3a5

&
EPMDocument's ida2a2 = EPMDescribeLink's ida3b5

Thanks,
Jarrett

select

'CONTENTLINK' as LINKDESCR

, A.CREATESTAMPA2 as CREATEDATE

, A.IDA2A2 as BUILDIDA2A2

, D.DOCUMENTNUMBER as EPMDOCUMENTNUMBER

, D.EPM_REV

, D.EPM_ITER

, G.NAME AS PARTVIEW

, G.WTPARTNUMBER as PARTNUMBER

, G.PART_REV

, G.PART_ITER

from EPMDESCRIBELINK A

left outer join

( select C.IDA2A2 as EPMMASTERIDA2A2,C.DOCUMENTNUMBER, B.IDA2A2 as EPMIDA2A2, B.VERSIONIDA2VERSIONINFO as EPM_REV, B.ITERATIONIDA2ITERATIONINFO as EPM_ITER

from EPMDOCUMENT B

inner join EPMDOCUMENTMASTER C

on B.IDA3MASTERREFERENCE = C.IDA2A2 ) D

on D.EPMIDA2A2 = A.IDA3B5

left outer join

(select F.IDA2A2 as PARTMASTERIDA2A2, E2.NAME,F.WTPARTNUMBER,E.IDA2A2 as PARTIDA2A2, E.VERSIONIDA2VERSIONINFO as PART_REV, E.ITERATIONIDA2ITERATIONINFO as PART_ITER

from WTPART E

inner join WTPARTMASTER F

on F.IDA2A2 = E.IDA3MASTERREFERENCE

INNER JOIN WTVIEW E2

ON E2.IDA2A2=E.IDA3VIEW ) G

on G.PARTIDA2A2 = A.IDA3A5