VIEW: SYS.USER_AW_OBJ

Source

View Text - Preformatted

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

View Text - HTML Formatted

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