[Home] [Help]
[Dependency Information]
Object Name: | XDP_DQ_CONFIGURATION |
---|---|
Object Type: | TABLE |
Owner: | XDP |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
XDP_DQ_CONFIGURATION is a configuration table for application queues and is populated during the installation process. Number of dequeue processes per queue is user configurable and should only be modified using application user interface - Queue Console.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XDP_DQ_CONFIGURATION_U1 | NORMAL | UNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERNAL_Q_NAME | VARCHAR2 | (40) | Yes | Name of queue used for application processing |
Q_ALIAS | VARCHAR2 | (40) | Yes | Alias for 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 |
STATE | VARCHAR2 | (10) | Yes | State of the queue. Possible state values are ENABLED, DISABLED, SHUTDOWN and SUSPENDED |
DISPLAY_SEQUENCE | NUMBER | Display sequence of the queue in Queue Console | ||
EXCEPTION_QUEUE_NAME | VARCHAR2 | (40) | Name of the exception queue used for 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 |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT INTERNAL_Q_NAME
, Q_ALIAS
, QUEUE_TABLE_NAME
, PAYLOAD_TYPE
, NUM_OF_DQER
, DQ_PROC_NAME
, MODULE_NAME
, IS_AQ_FLAG
, STATE
, DISPLAY_SEQUENCE
, EXCEPTION_QUEUE_NAME
, MAX_RETRIES
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM XDP.XDP_DQ_CONFIGURATION;
XDP.XDP_DQ_CONFIGURATION does not reference any database object
XDP.XDP_DQ_CONFIGURATION is referenced by following:
|
|
|