DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on DBA_OBJECTS

Line 3833: FROM all_queues aq, dba_objects db1, dba_objects db2

3829: OR name like 'ECX%');
3830:
3831: CURSOR c_queue IS
3832: SELECT aq.enqueue_enabled, aq.dequeue_enabled, db1.status queue_status, db2.status table_status
3833: FROM all_queues aq, dba_objects db1, dba_objects db2
3834: WHERE db1.object_name = l_queue_name
3835: AND db1.owner = l_owner
3836: AND db1.object_type = 'QUEUE'
3837: AND aq.name = l_queue_name