VIEW: SYS.KU$_MV_DEPTBL_OBJNUM_VIEW

Source

View Text - Preformatted

select tlo.obj_num
  from sys.ku$_schemaobj_view mo, sys.ku$_schemaobj_view tlo, sys.mlog$ ml
  where mo.owner_name = ml.mowner and
        mo.name = ml.master and
        mo.owner_num = tlo.owner_num and
        tlo.name = ml.temp_log and
        mo.obj_num in (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS)) and
        (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (mo.owner_num, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT TLO.OBJ_NUM
FROM SYS.KU$_SCHEMAOBJ_VIEW MO
, SYS.KU$_SCHEMAOBJ_VIEW TLO
, SYS.MLOG$ ML
WHERE MO.OWNER_NAME = ML.MOWNER AND MO.NAME = ML.MASTER AND MO.OWNER_NUM = TLO.OWNER_NUM AND TLO.NAME = ML.TEMP_LOG AND MO.OBJ_NUM IN (SELECT *
FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS)) AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (MO.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))