[Home] [Help] [Dependency Information]
Object Name: | IEM_AGENT_SESSIONS# |
---|---|
Object Type: | VIEW |
Owner: | IEM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGENT_ID | VARCHAR2 | (15) | Yes | |
WORK_MODE | VARCHAR2 | (10) | ||
EDIT_MODE | VARCHAR2 | (10) | ||
MSG_KEY | VARCHAR2 | (32) | ||
ACCOUNT_ID | VARCHAR2 | (15) | ||
CUSTOMER_ID | VARCHAR2 | (15) | ||
CLASSIFICATION_ID | VARCHAR2 | (15) | ||
CLASSIFICATION | VARCHAR2 | (50) | ||
IM_MSG_ID | VARCHAR2 | (15) | ||
LAST_UPDATE_DATE | DATE | |||
SECURITY_GROUP_ID | NUMBER | |||
CONTACT_ID | VARCHAR2 | (15) | ||
CUSTOMER_EMAIL | VARCHAR2 | (2000) | ||
REF_KEY | VARCHAR2 | (32) | ||
SERVICE_REQUEST | VARCHAR2 | (15) | ||
MCP_ID | VARCHAR2 | (15) | ||
INBOUND_MSG_KEY | VARCHAR2 | (32) | ||
LEAD_ID | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT AGENT_ID
, WORK_MODE
, EDIT_MODE
, MSG_KEY
, ACCOUNT_ID
, CUSTOMER_ID
, CLASSIFICATION_ID
, CLASSIFICATION
, IM_MSG_ID
, LAST_UPDATE_DATE
, SECURITY_GROUP_ID
, CONTACT_ID
, CUSTOMER_EMAIL
, REF_KEY
, SERVICE_REQUEST
, MCP_ID
, INBOUND_MSG_KEY
, LEAD_ID
FROM IEM.IEM_AGENT_SESSIONS#;
|
|
|