[Home] [Help] [Dependency Information]
Object Name: | IEB_SVC_VIRTUAL_QUEUES |
---|---|
Object Type: | TABLE |
Owner: | IEB |
FND Design Data: | IEB.IEB_SVC_VIRTUAL_QUEUES |
Subobject Name: | |
Status: | VALID |
Summary information of virtal queues, i.e., dynamic agent groups, for IEB server internal use.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEB_SVC_VIRTUAL_QUEUES_PK_U | NORMAL | UNIQUE | APPS_TS_TX_IDX | SVCVQ_ID |
IEB_SVC_VIRTUAL_QUEUES_FK_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WBSC_WBSC_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SVCVQ_ID | NUMBER | (15) | Yes | Service Virtual Queue ID |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
SEQUENCE_NUMBER | NUMBER | (15) | Yes | Internal ID generated by IEB server for the virtual queue. |
EXPIRATION_DATE | DATE | Yes | Time when this category expired | |
WBSC_WBSC_ID | NUMBER | (15) | Yes | Service Category ID |
SECURITY_GROUP_ID | NUMBER | (15) | Subscriber?s unique ID for Application Hosting Support |
Cut, paste (and edit) the following text to query this object:
SELECT SVCVQ_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SEQUENCE_NUMBER
, EXPIRATION_DATE
, WBSC_WBSC_ID
, SECURITY_GROUP_ID
FROM IEB.IEB_SVC_VIRTUAL_QUEUES;
IEB.IEB_SVC_VIRTUAL_QUEUES does not reference any database object
IEB.IEB_SVC_VIRTUAL_QUEUES is referenced by following:
|
|
|