VIEW: SYS.DBA_AW_OBJ

Source

View Text - Preformatted

SELECT u.name, a.awseq#, a.awname, o.oid, o.objname, o.objtype, o.partname
FROM aw$ a, aw_obj$ o, user$ u,
     (select max(rowid) keep (dense_rank last order by gen#) rid
      from aw_obj$ group by awseq#, oid)
WHERE   a.owner#=u.user# and a.awseq#=o.awseq#
        and o.rowid = rid and o.objtype IS NOT NULL

View Text - HTML Formatted

SELECT U.NAME
, A.AWSEQ#
, A.AWNAME
, O.OID
, O.OBJNAME
, O.OBJTYPE
, O.PARTNAME FROM AW$ A
, AW_OBJ$ O
, USER$ U
, (SELECT MAX(ROWID) KEEP (DENSE_RANK LAST ORDER BY GEN#) RID
FROM AW_OBJ$ GROUP BY AWSEQ#
, OID) WHERE A.OWNER#=U.USER#
AND A.AWSEQ#=O.AWSEQ#
AND O.ROWID = RID
AND O.OBJTYPE IS NOT NULL