select OWNER, NAME, TYPE, GROUP_ID, STATUS, ERROR_NUMBER,
ERROR_MESSAGE, LAST_MODIFIED_TIME
from dba_sr_obj_status_all
where current_run = 'Y' and current_group = 'Y'
View Text - HTML Formatted
SELECT OWNER , NAME , TYPE , GROUP_ID , STATUS , ERROR_NUMBER ,
ERROR_MESSAGE , LAST_MODIFIED_TIME
FROM DBA_SR_OBJ_STATUS_ALL
WHERE CURRENT_RUN = 'Y' AND CURRENT_GROUP = 'Y'