[Home] [Help] [Dependency Information]
Object Name: | CCT_IVR_MAPS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View used to retrieve IVR data for HTML Adminisitration
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
IVR_MAP_ID | NUMBER | Yes | IVR Map ID | |
IVR_NAME | VARCHAR2 | (32) | Yes | IVR Name |
INTERACTION_KEY_ID | NUMBER | Yes | Interaction Key ID | |
INTERACTION_KEY_CODE | VARCHAR2 | (32) | Interaction Key Code | |
INTERACTION_KEY | VARCHAR2 | (80) | Yes | Interaction Key |
DATATYPE_CODE | VARCHAR2 | (32) | Yes | Datatype Code |
DATATYPE | VARCHAR2 | (80) | Yes | Datatype |
SERVER_GROUP_ID | NUMBER | Yes | Server Group ID | |
ROUTE_POINT_ID | NUMBER | (15) | Route Point ID | |
ROUTE_POINT_NUMBER | VARCHAR2 | (32) | Route Point Number | |
MIDDLEWARE_ID | NUMBER | Middleware ID | ||
MIDDLEWARE | VARCHAR2 | (128) | Middleware Name | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER for AOM web access | |
F_DELETEDFLAG | VARCHAR2 | (1) | F_DELETEDFLAG for AOM web access |
Cut, paste (and edit) the following text to query this object:
SELECT IVR_MAP_ID
, IVR_NAME
, INTERACTION_KEY_ID
, INTERACTION_KEY_CODE
, INTERACTION_KEY
, DATATYPE_CODE
, DATATYPE
, SERVER_GROUP_ID
, ROUTE_POINT_ID
, ROUTE_POINT_NUMBER
, MIDDLEWARE_ID
, MIDDLEWARE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, F_DELETEDFLAG
FROM APPS.CCT_IVR_MAPS_VL;
APPS.CCT_IVR_MAPS_VL is not referenced by any database object
|
|
|