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
