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: APPS.XDP_DQ_CONFIGURATION_VL

Object Details

Object Name:	XDP_DQ_CONFIGURATION_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XDP.XDP_DQ_CONFIGURATION_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

This is a language specific view which is defined on multi-lingual compliant queue configuration tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Internal database row id of the Queue record
INTERNAL_Q_NAME	VARCHAR2	(40)	Yes	Name of queue used for application processing
Q_ALIAS	VARCHAR2	(40)	Yes	Alias for the queue
DISPLAY_SEQUENCE	NUMBER			Display sequence of the queue in Queue Console
STATE	VARCHAR2	(10)	Yes	State of the queue
QUEUE_TABLE_NAME	VARCHAR2	(40)	Yes	Name of table which implements the queue
PAYLOAD_TYPE	VARCHAR2	(40)	Yes	Payload type of the queue
NUM_OF_DQER	NUMBER		Yes	User configurable number of dequeue processes for the queue
DQ_PROC_NAME	VARCHAR2	(80)	Yes	Name of the procedure which implements dequeue routine for the queue
MODULE_NAME	VARCHAR2	(240)	Yes	Not used. For future use
IS_AQ_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether the queue is implemented using Oracle's AQ
EXCEPTION_QUEUE_NAME	VARCHAR2	(40)		Name of the exception queue associated with the queue
MAX_RETRIES	NUMBER			Implementation specific retry count after which the message is moved from the queue to the exception queue
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column - with the user id from FND_USER
CREATED_BY	NUMBER	(15)	Yes	Standard Who column - with the user id from FND_USER
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
DISPLAY_NAME	VARCHAR2	(80)	Yes	Language dependent name of the queue
DESCRIPTION	VARCHAR2	(2000)		Language dependent description of the queue

Query Text

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


SELECT ROW_ID
,      INTERNAL_Q_NAME
,      Q_ALIAS
,      DISPLAY_SEQUENCE
,      STATE
,      QUEUE_TABLE_NAME
,      PAYLOAD_TYPE
,      NUM_OF_DQER
,      DQ_PROC_NAME
,      MODULE_NAME
,      IS_AQ_FLAG
,      EXCEPTION_QUEUE_NAME
,      MAX_RETRIES
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DISPLAY_NAME
,      DESCRIPTION
FROM APPS.XDP_DQ_CONFIGURATION_VL;

Dependencies

[top of page]

APPS.XDP_DQ_CONFIGURATION_VL references the following:

APPS: XDP_DQ_CONFIGURATION; XDP_DQ_CONFIGURATION_TL

APPS.XDP_DQ_CONFIGURATION_VL is referenced by following:

APPS: XDP_SUMMARY_QUEUES_V