EPMBUILDHISTORY
EPMBUILDRULE
select em.documentnumber, e.versionida2versioninfo||'.'||e.iterationida2iterationinfo as epmversion, pm.wtpartnumber, p.versionida2versioninfo||'.'||p.iterationida2iterationinfo as partversion, ebh.buildtype
from epmdocumentmaster em, epmdocument e, wtpartmaster pm, wtpart p, epmbuildhistory ebh
where e.ida3masterreference=em.ida2a2
and p.ida3masterreference=pm.ida2a2
and ebh.ida3a5=e.ida2a2
and ebh.ida3b5=p.ida2a2
EPMBUILDRULE
select em.documentnumber, e.versionida2versioninfo||'.'||e.iterationida2iterationinfo as epmversion, pm.wtpartnumber, p.versionida2versioninfo||'.'||p.iterationida2iterationinfo as partversion, ebr.buildtype
from epmdocumentmaster em, epmdocument e, wtpartmaster pm, wtpart p, epmbuildrule ebr
where e.ida3masterrefere