eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IEC.IEC_G_RETURN_ENTRIES

Object Details

Object Name:	IEC_G_RETURN_ENTRIES
Object Type:	TABLE
Owner:	IEC
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEC_G_RETURN_ENTRIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RETURNS_ID
IEC_G_RETURN_ENTRIES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID LIST_ENTRY_ID RETURNS_ID
IEC_G_RETURN_ENTIRES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_HEADER_ID SUBSET_ID
IEC_G_RETURN_ENTRIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_ENTRY_ID
IEC_G_RETURN_ENTRIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OUTCOME_ID
IEC_G_RETURN_ENTRIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESULT_ID
IEC_G_RETURN_ENTRIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECYCLE_FLAG
IEC_G_RETURN_ENTRIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUBSET_ID
IEC_G_RETURN_ENTRIES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITM_CC_TZ_ID CALLBACK_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
RETURNS_ID	NUMBER	(15)	Yes	Unique Identifier
LIST_ENTRY_ID	NUMBER	(15)	Yes	List Entry Unique Identifier.
LIST_HEADER_ID	NUMBER	(15)	Yes	Foreign key to AMS_LIST_HEADERS_ALL.
SUBSET_ID	NUMBER	(15)		Subset Unique Identifier.
OUTCOME_ID	NUMBER	(10)		Foreign key to the JTF_IH_OUTCOMES tables.
RESULT_ID	NUMBER	(10)		Foreign key to the JTF_IH_RESULTS tables.
REASON_ID	NUMBER	(10)		Foreign key to the JTF_IH_REASONS tables.
CONTACT_POINT	VARCHAR2	(60)		The phone number used.
CONTACT_POINT_ID	NUMBER	(15)		The Identifier of the contact point used.
CALL_START_TIME	DATE			the time that the call starts.
CALL_END_TIME	DATE			the time that the call ends.
NEXT_CALL_TIME	DATE			the customer preferred next call time.
CALL_TYPE	VARCHAR2	(4)		used to store the call type.
DELIVER_IH_FLAG	VARCHAR2	(1)	Yes	indicates whether this contact pass to Interation History or not.
CAMPAIGN_SCHEDULE_ID	NUMBER		Yes	Foreign key to AMS_CAMPAIGN_SCHEDULES_B.
LIST_VIEW_NAME	VARCHAR2	(240)		stores the view name.
RECYCLE_FLAG	VARCHAR2	(1)		indicates whether it's recycled or not.
ITM_CC_TZ_ID	NUMBER			Represents the current time zone and country code combination.
DO_NOT_USE_FLAG	VARCHAR2	(1)		Indicates whether or not a record can be called.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
SECURITY_GROUP_ID	NUMBER	(15)		Used in hosted environments.
PULLED_SUBSET_ID	NUMBER	(15)		Pulled Subset Unique Identifier.
CALLBACK_FLAG	VARCHAR2	(240)		Advanced outbound purposes
DO_NOT_USE_REASON	VARCHAR2	(240)		Advanced outbound purposes
RECORD_OUT_FLAG	VARCHAR2	(240)		Advanced outbound purposes
RECORD_RELEASE_TIME	DATE			Advanced outbound purposes
CONTACT_POINT_INDEX	NUMBER			Advanced outbound purposes
COUNTRY_CODE	VARCHAR2	(240)		Advanced outbound purposes
AREA_CODE	NUMBER			Advanced outbound purposes
PHONE_NUMBER	VARCHAR2	(240)		Advanced outbound purposes
RAW_PHONE_NUMBER	VARCHAR2	(240)		Advanced outbound purposes
TIME_ZONE	NUMBER			Advanced outbound purposes
CHECKIN_ACTION_ID	NUMBER			Sequence generated by last checkin action.
CHECKIN_ACTION_TYPE	NUMBER			Type of last checkin action.
CHECKIN_ACTION_TIME	DATE			Time of last checkin action.
CHECKOUT_ACTION_ID	NUMBER			Sequence generated by last checkout action.
CHECKOUT_ACTION_TYPE	NUMBER			Type of last checkout action.
CAMPAIGN_ID	NUMBER			campaign Id
PHONE_LINE_TYPE	VARCHAR2	(30)		The phone line type of the current contact point.
CONTACT_POINT_PURPOSE	VARCHAR2	(30)		The purpose of the current contact point.
AGENT_RECYCLE_ACTION	VARCHAR2	(250)		used to store agent specified action.

Query Text

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;

Dependencies

[top of page]

IEC.IEC_G_RETURN_ENTRIES does not reference any database object

IEC.IEC_G_RETURN_ENTRIES is referenced by following:

APPS: IEC_G_RETURN_ENTRIES