[Home] [Help] [Dependency Information]
Object Name: | IEC_G_RETURN_ENTRIES# |
---|---|
Object Type: | VIEW |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RETURNS_ID | NUMBER | (15) | Yes | |
LIST_ENTRY_ID | NUMBER | (15) | Yes | |
LIST_HEADER_ID | NUMBER | (15) | Yes | |
SUBSET_ID | NUMBER | (15) | ||
OUTCOME_ID | NUMBER | (10) | ||
RESULT_ID | NUMBER | (10) | ||
REASON_ID | NUMBER | (10) | ||
CONTACT_POINT | VARCHAR2 | (60) | ||
CONTACT_POINT_ID | NUMBER | (15) | ||
CALL_START_TIME | DATE | |||
CALL_END_TIME | DATE | |||
NEXT_CALL_TIME | DATE | |||
CALL_TYPE | VARCHAR2 | (4) | ||
DELIVER_IH_FLAG | VARCHAR2 | (1) | Yes | |
CAMPAIGN_SCHEDULE_ID | NUMBER | Yes | ||
LIST_VIEW_NAME | VARCHAR2 | (240) | ||
RECYCLE_FLAG | VARCHAR2 | (1) | ||
ITM_CC_TZ_ID | NUMBER | |||
DO_NOT_USE_FLAG | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SECURITY_GROUP_ID | NUMBER | (15) | ||
PULLED_SUBSET_ID | NUMBER | (15) | ||
CALLBACK_FLAG | VARCHAR2 | (240) | ||
DO_NOT_USE_REASON | VARCHAR2 | (240) | ||
RECORD_OUT_FLAG | VARCHAR2 | (240) | ||
RECORD_RELEASE_TIME | DATE | |||
CONTACT_POINT_INDEX | NUMBER | |||
COUNTRY_CODE | VARCHAR2 | (240) | ||
AREA_CODE | NUMBER | |||
PHONE_NUMBER | VARCHAR2 | (240) | ||
RAW_PHONE_NUMBER | VARCHAR2 | (240) | ||
TIME_ZONE | NUMBER | |||
CHECKIN_ACTION_ID | NUMBER | |||
CHECKIN_ACTION_TYPE | NUMBER | |||
CHECKIN_ACTION_TIME | DATE | |||
CHECKOUT_ACTION_ID | NUMBER | |||
CHECKOUT_ACTION_TYPE | NUMBER | |||
CAMPAIGN_ID | NUMBER | |||
PHONE_LINE_TYPE | VARCHAR2 | (30) | ||
CONTACT_POINT_PURPOSE | VARCHAR2 | (30) | ||
AGENT_RECYCLE_ACTION | VARCHAR2 | (250) |
Cut, paste (and edit) the following text to query this object:
SELECT RETURNS_ID
, LIST_ENTRY_ID
, LIST_HEADER_ID
, SUBSET_ID
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, CONTACT_POINT
, CONTACT_POINT_ID
, CALL_START_TIME
, CALL_END_TIME
, NEXT_CALL_TIME
, CALL_TYPE
, DELIVER_IH_FLAG
, CAMPAIGN_SCHEDULE_ID
, LIST_VIEW_NAME
, RECYCLE_FLAG
, ITM_CC_TZ_ID
, DO_NOT_USE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, PULLED_SUBSET_ID
, CALLBACK_FLAG
, DO_NOT_USE_REASON
, RECORD_OUT_FLAG
, RECORD_RELEASE_TIME
, CONTACT_POINT_INDEX
, COUNTRY_CODE
, AREA_CODE
, PHONE_NUMBER
, RAW_PHONE_NUMBER
, TIME_ZONE
, CHECKIN_ACTION_ID
, CHECKIN_ACTION_TYPE
, CHECKIN_ACTION_TIME
, CHECKOUT_ACTION_ID
, CHECKOUT_ACTION_TYPE
, CAMPAIGN_ID
, PHONE_LINE_TYPE
, CONTACT_POINT_PURPOSE
, AGENT_RECYCLE_ACTION
FROM IEC.IEC_G_RETURN_ENTRIES#;
|
|
|