VIEW: APPS.OKC_QUE_OBJECTS_V

Source

View Text - Preformatted

SELECT object_id, object_name , OBJECT_TYPE, created, last_ddl_time, OWNER, STATUS FROM all_objects WHERE object_name like '%OKC_AQ_%' AND ( OWNER = 'OKC' OR OWNER = 'SYSTEM') AND object_name NOT IN ('OKC_AQERRORS','OKC_AQERRORS_U1','OKC_AQMSGSTACKS','OKC_AQMSGSTACKS_U1')

View Text - HTML Formatted

SELECT OBJECT_ID
, OBJECT_NAME
, OBJECT_TYPE
, CREATED
, LAST_DDL_TIME
, OWNER
, STATUS
FROM ALL_OBJECTS
WHERE OBJECT_NAME LIKE '%OKC_AQ_%'
AND ( OWNER = 'OKC' OR OWNER = 'SYSTEM')
AND OBJECT_NAME NOT IN ('OKC_AQERRORS'
, 'OKC_AQERRORS_U1'
, 'OKC_AQMSGSTACKS'
, 'OKC_AQMSGSTACKS_U1')