[Home] [Help] [Dependency Information]
Object Name: | IEC_O_CALL_HISTORIES |
---|---|
Object Type: | TABLE |
Owner: | IEC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEC_O_CALL_HISTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CALL_HISTORY_ID |
IEC_O_CALL_HISTORIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LIST_ENTRY_ID
LIST_HEADER_ID |
IEC_O_CALL_HISTORIES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CONTACT_POINT_ID |
IEC_O_CALL_HISTORIES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUBSET_ID |
IEC_O_CALL_HISTORIES_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CALL_START_TIME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALL_HISTORY_ID | NUMBER | (15) | Yes | Unique Identifier. |
LIST_ENTRY_ID | NUMBER | (10) | Yes | Foreign key to the AMS_LIST_ENTRIES table. |
LIST_HEADER_ID | NUMBER | (15) | Yes | List Header Unique Identifier. |
SUBSET_ID | NUMBER | (15) | Yes | Subset Unique Identifier. |
CALL_TYPE | VARCHAR2 | (4) | Yes | used to store the call type. |
OUTCOME_ID | NUMBER | (10) | Yes | 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. | |
CALL_START_TIME | DATE | Yes | The date and time the last call was placed to this customer. | |
CALL_END_TIME | DATE | The date and time the last call to this customer ended. | ||
CONTACT_POINT | VARCHAR2 | (60) | Yes | The phone number used to place the call. |
CONTACT_POINT_ID | NUMBER | (15) | The Identifier of the contact point used. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT CALL_HISTORY_ID
, LIST_ENTRY_ID
, LIST_HEADER_ID
, SUBSET_ID
, CALL_TYPE
, OUTCOME_ID
, RESULT_ID
, REASON_ID
, CALL_START_TIME
, CALL_END_TIME
, CONTACT_POINT
, CONTACT_POINT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM IEC.IEC_O_CALL_HISTORIES;
IEC.IEC_O_CALL_HISTORIES does not reference any database object
IEC.IEC_O_CALL_HISTORIES is referenced by following:
|
|
|