VIEW: SYS.USER_SR_OBJ_STATUS

Source

View Text - Preformatted

select NAME, TYPE, GROUP_ID, STATUS, ERROR_NUMBER, ERROR_MESSAGE, LAST_MODIFIED_TIME
from dba_sr_obj_status
where owner = SYS_CONTEXT ('USERENV', 'SESSION_USER')

View Text - HTML Formatted

SELECT NAME
, TYPE
, GROUP_ID
, STATUS
, ERROR_NUMBER
, ERROR_MESSAGE
, LAST_MODIFIED_TIME FROM DBA_SR_OBJ_STATUS WHERE OWNER = SYS_CONTEXT ('USERENV'
, 'SESSION_USER')