DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on DBA_OBJECTS

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

3478: OR name like 'ECX%');
3479:
3480: CURSOR c_queue IS
3481: SELECT aq.enqueue_enabled, aq.dequeue_enabled, db1.status queue_status, db2.status table_status
3482: FROM all_queues aq, dba_objects db1, dba_objects db2
3483: WHERE db1.object_name = l_queue_name
3484: AND db1.owner = l_owner
3485: AND db1.object_type = 'QUEUE'
3486: AND aq.name = l_queue_name