VIEW: IEC.IEC_G_RETURN_ENTRIES#

Source

View Text - Preformatted

select RETURNS_ID RETURNS_ID, LIST_ENTRY_ID LIST_ENTRY_ID, LIST_HEADER_ID LIST_HEADER_ID, SUBSET_ID SUBSET_ID, OUTCOME_ID OUTCOME_ID, RESULT_ID RESULT_ID, REASON_ID REASON_ID, CONTACT_POINT CONTACT_POINT, CONTACT_POINT_ID CONTACT_POINT_ID, CALL_START_TIME CALL_START_TIME, CALL_END_TIME CALL_END_TIME, NEXT_CALL_TIME NEXT_CALL_TIME, CALL_TYPE CALL_TYPE, DELIVER_IH_FLAG DELIVER_IH_FLAG, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID, LIST_VIEW_NAME LIST_VIEW_NAME, RECYCLE_FLAG RECYCLE_FLAG, ITM_CC_TZ_ID ITM_CC_TZ_ID, DO_NOT_USE_FLAG DO_NOT_USE_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, PULLED_SUBSET_ID PULLED_SUBSET_ID, CALLBACK_FLAG CALLBACK_FLAG, DO_NOT_USE_REASON DO_NOT_USE_REASON, RECORD_OUT_FLAG RECORD_OUT_FLAG, RECORD_RELEASE_TIME RECORD_RELEASE_TIME, CONTACT_POINT_INDEX CONTACT_POINT_INDEX, COUNTRY_CODE COUNTRY_CODE, AREA_CODE AREA_CODE, PHONE_NUMBER PHONE_NUMBER, RAW_PHONE_NUMBER RAW_PHONE_NUMBER, TIME_ZONE TIME_ZONE, CHECKIN_ACTION_ID CHECKIN_ACTION_ID, CHECKIN_ACTION_TYPE CHECKIN_ACTION_TYPE, CHECKIN_ACTION_TIME CHECKIN_ACTION_TIME, CHECKOUT_ACTION_ID CHECKOUT_ACTION_ID, CHECKOUT_ACTION_TYPE CHECKOUT_ACTION_TYPE, CAMPAIGN_ID CAMPAIGN_ID, PHONE_LINE_TYPE PHONE_LINE_TYPE, CONTACT_POINT_PURPOSE CONTACT_POINT_PURPOSE, AGENT_RECYCLE_ACTION AGENT_RECYCLE_ACTION from "IEC"."IEC_G_RETURN_ENTRIES"

View Text - HTML Formatted

SELECT RETURNS_ID RETURNS_ID
, LIST_ENTRY_ID LIST_ENTRY_ID
, LIST_HEADER_ID LIST_HEADER_ID
, SUBSET_ID SUBSET_ID
, OUTCOME_ID OUTCOME_ID
, RESULT_ID RESULT_ID
, REASON_ID REASON_ID
, CONTACT_POINT CONTACT_POINT
, CONTACT_POINT_ID CONTACT_POINT_ID
, CALL_START_TIME CALL_START_TIME
, CALL_END_TIME CALL_END_TIME
, NEXT_CALL_TIME NEXT_CALL_TIME
, CALL_TYPE CALL_TYPE
, DELIVER_IH_FLAG DELIVER_IH_FLAG
, CAMPAIGN_SCHEDULE_ID CAMPAIGN_SCHEDULE_ID
, LIST_VIEW_NAME LIST_VIEW_NAME
, RECYCLE_FLAG RECYCLE_FLAG
, ITM_CC_TZ_ID ITM_CC_TZ_ID
, DO_NOT_USE_FLAG DO_NOT_USE_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PULLED_SUBSET_ID PULLED_SUBSET_ID
, CALLBACK_FLAG CALLBACK_FLAG
, DO_NOT_USE_REASON DO_NOT_USE_REASON
, RECORD_OUT_FLAG RECORD_OUT_FLAG
, RECORD_RELEASE_TIME RECORD_RELEASE_TIME
, CONTACT_POINT_INDEX CONTACT_POINT_INDEX
, COUNTRY_CODE COUNTRY_CODE
, AREA_CODE AREA_CODE
, PHONE_NUMBER PHONE_NUMBER
, RAW_PHONE_NUMBER RAW_PHONE_NUMBER
, TIME_ZONE TIME_ZONE
, CHECKIN_ACTION_ID CHECKIN_ACTION_ID
, CHECKIN_ACTION_TYPE CHECKIN_ACTION_TYPE
, CHECKIN_ACTION_TIME CHECKIN_ACTION_TIME
, CHECKOUT_ACTION_ID CHECKOUT_ACTION_ID
, CHECKOUT_ACTION_TYPE CHECKOUT_ACTION_TYPE
, CAMPAIGN_ID CAMPAIGN_ID
, PHONE_LINE_TYPE PHONE_LINE_TYPE
, CONTACT_POINT_PURPOSE CONTACT_POINT_PURPOSE
, AGENT_RECYCLE_ACTION AGENT_RECYCLE_ACTION
FROM "IEC"."IEC_G_RETURN_ENTRIES"