eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_INT_DEQUEUE_QUEUES

Object Details

Object Name:	ALL_INT_DEQUEUE_QUEUES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All queues accessible to the user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the queue
NAME	VARCHAR2	(128)	Yes	Name of the queue
QID	NUMBER		Yes	Object number of the queue

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      QID
FROM SYS.ALL_INT_DEQUEUE_QUEUES;

Dependencies

[top of page]

SYS.ALL_INT_DEQUEUE_QUEUES references the following:

SYS: OBJ$; OBJAUTH$
SYSTEM: AQ$_QUEUES; AQ$_QUEUE_TABLES

SYS.ALL_INT_DEQUEUE_QUEUES is referenced by following:

AMV: AQ$_AMV_MATCHING_QUEUE_TBL_F
APPLSYS: AQ$_ECX_INQUEUE_F; AQ$_ECX_IN_OAG_Q_TABLE_F; AQ$_ECX_OUTQUEUE_F; AQ$_FND_CP_GSM_IPC_AQTBL_F; AQ$_FND_CP_GSM_OPP_AQTBL_F; AQ$_FND_CP_TM_AQTBL_F; AQ$_FND_CP_TM_RET_AQTBL_F; AQ$_FND_SOA_JMS_IN_F; AQ$_FND_SOA_JMS_OUT_F; AQ$_WF_CONTROL_F; AQ$_WF_DEFERRED_F; AQ$_WF_DEFERRED_TABLE_M_F; AQ$_WF_ERROR_F; AQ$_WF_INBOUND_TABLE_F; AQ$_WF_IN_F; AQ$_WF_JAVA_DEFERRED_F; AQ$_WF_JAVA_ERROR_F; AQ$_WF_JMS_IN_F; AQ$_WF_JMS_JMS_OUT_F; AQ$_WF_JMS_OUT_F; AQ$_WF_NOTIFICATION_IN_F; AQ$_WF_NOTIFICATION_OUT_F; AQ$_WF_OUTBOUND_TABLE_F; AQ$_WF_OUT_F; AQ$_WF_REPLAY_IN_F; AQ$_WF_REPLAY_OUT_F; AQ$_WF_SMTP_O_1_TABLE_F; AQ$_WF_WS_JMS_IN_F; AQ$_WF_WS_JMS_OUT_F; AQ$_WF_WS_SAMPLE_F
APPS: AQ$_CZ_MESSAGE_QENTRIES_F; AQ$_JTF_FM_RAPID_BP_QTBL_F; AQ$_JTF_FM_RAPID_B_QTBL_F; AQ$_JTF_FM_RAPID_ER_QTBL_F; AQ$_JTF_FM_RAPID_MP_QTBL_F; AQ$_JTF_FM_RAPID_M_QTBL_F; AQ$_JTF_FM_RAPID_Q1_QTBL_F; AQ$_JTF_FM_RAPID_Q2_QTBL_F; AQ$_JTF_IH_BULK_QTBL_F; AQ$_JTF_PF_LOGGING_TABLE_F; AQ$_WF_BPEL_QTAB_F
AR: AQ$_AR_REV_REC_QT_F; AQ$_HZ_JMS_OUT_F
ASO: AQ$_ASO_ORDER_FEEDBACK_T_F
CCT: AQ$_CCT_IBME_QUEUE_TBL_F; AQ$_CCT_QDE_RESP_Q_TBL_F
GSMADMIN_INTERNAL: AQ$_CHANGE_LOG_QUEUE_TABLE_F
IBU: AQ$_IBU_SUBS_TABLE_F
IEM: AQ$_IEMPP_QUEUE_TBL_F; AQ$_IEMP_QUEUE_TBL_F
IEO: AQ$_IEO_ICSM_QUEUE_TBL_1_F; AQ$_IEO_ICSM_QUEUE_TBL_2_F
JTF: AQ$_JTF_DEF_QUEUE_TABLE_F; AQ$_JTF_EXCEP_QUEUE_TABLE_F; AQ$_JTF_STAGING_QUEUE_TABLE_F
ODM: AQ$_DMS_QUEUE_TABLE_F
OKC: AQ$_OKC_AQ_EV_TAB_F
PO: AQ$_PO_OTM_OUT_F
PUBLIC: ALL_INT_DEQUEUE_QUEUES
SYS: AQ$_ALERT_QT_F; AQ$_AQ$_MEM_MC_F; AQ$_AQ_EVENT_TABLE_F; AQ$_AQ_PROP_TABLE_F; AQ$_AQ_SRVNTFN_TABLE_1_F; AQ$_AQ_SRVNTFN_TABLE_2_F; AQ$_KUPC$DATAPUMP_QUETAB_F; AQ$_SCHEDULER$_EVENT_QTAB_F; AQ$_SCHEDULER$_REMDB_JOBQTAB_F; AQ$_SCHEDULER_FILEWATCHER_QT_F; AQ$_SYS$SERVICE_METRICS_TAB_F
SYSTEM: AQ$_DEF$_AQCALL_F; AQ$_DEF$_AQERROR_F; AQ$_TBLMIG_MSG_QTAB_F
XDP: AQ$_XDP_FA_QTAB_F; AQ$_XDP_ORDER_PROCESSOR_QTAB_F; AQ$_XDP_PENDING_ORDER_QTAB_F; AQ$_XDP_WF_CHANNEL_QTAB_F; AQ$_XDP_WORKITEM_QTAB_F
XLA: AQ$_XLA_ACCOUNTING_QTAB_F
XNP: AQ$_XNP_IN_EVT_QTAB_F; AQ$_XNP_IN_MSG_QTAB_F; AQ$_XNP_IN_TMR_QTAB_F; AQ$_XNP_OUT_MSG_QTAB_F