[Home] [Help]
[Dependency Information]
| Object Name: | CCT_QDE_AGENT |
|---|---|
| Object Type: | TABLE |
| Owner: | CCT |
| Subobject Name: | |
| Status: | VALID |
QDE Agent Table
| Tablespace: | APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AGENT_ID | NUMBER | Yes | Agent ID | |
| AGENT_INDEX | NUMBER | Yes | Agent Index | |
| RAW_AGENT_INDEX | RAW | (2000) | RaW Agent Index | |
| IS_GET_WORK | NUMBER | (1) | Is Get Work? | |
| ITEM_TYPE | NUMBER | (15) | Item type | |
| CLASSIFICATION | VARCHAR2 | (1024) | Classification | |
| GW_REQ_TIME | DATE | GW Request time | ||
| CREATED_BY | NUMBER | (15) | Who Column | |
| CREATION_DATE | DATE | Who Column | ||
| LAST_UPDATE_DATE | DATE | Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Who Column | |
| SECURITY_GROUP_ID | NUMBER | Security Group ID |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_ID
, AGENT_INDEX
, RAW_AGENT_INDEX
, IS_GET_WORK
, ITEM_TYPE
, CLASSIFICATION
, GW_REQ_TIME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM CCT.CCT_QDE_AGENT;
CCT.CCT_QDE_AGENT does not reference any database object
CCT.CCT_QDE_AGENT is referenced by following:
APPS
CCT_QDE_AGENT
|
|
|
|