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

TABLE: IEC.IEC_O_RCY_CALL_HISTORIES

Object Details
Object Name: IEC_O_RCY_CALL_HISTORIES
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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEC_O_RCY_CALL_HISTORIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALL_HISTORY_ID
IEC_O_RCY_CALL_HISTORIES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRETURNS_ID
Columns
Name Datatype Length Mandatory Comments
CALL_HISTORY_ID NUMBER (15) Yes Unique Identify.
RETURNS_ID NUMBER (15) Yes Foreign Key of Return Entries.
CONTACT_POINT VARCHAR2 (60)
Raw Phone Number of Record.
CALL_ATTEMPT NUMBER (10)
The Number of Call Attempt.
OUTCOME_ID_0 NUMBER (10)
Outcome of Previous Calls in Order 0.
OUTCOME_ID_1 NUMBER (10)
Outcome of Previous Calls in Order 1.
OUTCOME_ID_2 NUMBER (10)
Outcome of Previous Calls in Order 2.
OUTCOME_ID_3 NUMBER (10)
Outcome of Previous Calls in Order 3.
OUTCOME_ID_4 NUMBER (10)
Outcome of Previous Calls in Order 4.
OUTCOME_ID_5 NUMBER (10)
Outcome of Previous Calls in Order 5.
OUTCOME_ID_6 NUMBER (10)
Outcome of Previous Calls in Order 6.
OUTCOME_ID_7 NUMBER (10)
Outcome of Previous Calls in Order 7.
OUTCOME_ID_8 NUMBER (10)
Outcome of Previous Calls in Order 8.
OUTCOME_ID_9 NUMBER (10)
Outcome of Previous Calls in Order 9.
OUTCOME_ID_10 NUMBER (10)
Outcome of Previous Calls in Order 10.
OUTCOME_ID_11 NUMBER (10)
Outcome of Previous Calls in Order 11.
OUTCOME_ID_12 NUMBER (10)
Outcome of Previous Calls in Order 12.
OUTCOME_ID_13 NUMBER (10)
Outcome of Previous Calls in Order 13.
OUTCOME_ID_14 NUMBER (10)
Outcome of Previous Calls in Order 14.
OUTCOME_ID_15 NUMBER (10)
Outcome of Previous Calls in Order 15.
OUTCOME_ID_16 NUMBER (10)
Outcome of Previous Calls in Order 16.
OUTCOME_ID_17 NUMBER (10)
Outcome of Previous Calls in Order 17.
OUTCOME_ID_18 NUMBER (10)
Outcome of Previous Calls in Order 18.
OUTCOME_ID_19 NUMBER (10)
Outcome of Previous Calls in Order 19.
OUTCOME_ID_20 NUMBER (10)
Outcome of Previous Calls in Order 20.
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 (10)
Used in Hosted Environments.
TIME_0 DATE

Time of Previous Calls in Order 0.
TIME_1 DATE

Time of Previous Calls in Order 1.
TIME_2 DATE

Time of Previous Calls in Order 2.
TIME_3 DATE

Time of Previous Calls in Order 3.
TIME_4 DATE

Time of Previous Calls in Order 4.
TIME_5 DATE

Time of Previous Calls in Order 5.
TIME_6 DATE

Time of Previous Calls in Order 6.
TIME_7 DATE

Time of Previous Calls in Order 7.
TIME_8 DATE

Time of Previous Calls in Order 8.
TIME_9 DATE

Time of Previous Calls in Order 9.
TIME_10 DATE

Time of Previous Calls in Order 10.
TIME_11 DATE

Time of Previous Calls in Order 11.
TIME_12 DATE

Time of Previous Calls in Order 12.
TIME_13 DATE

Time of Previous Calls in Order 13.
TIME_14 DATE

Time of Previous Calls in Order 14.
TIME_15 DATE

Time of Previous Calls in Order 15.
TIME_16 DATE

Time of Previous Calls in Order 16.
TIME_17 DATE

Time of Previous Calls in Order 17.
TIME_18 DATE

Time of Previous Calls in Order 18.
TIME_19 DATE

Time of Previous Calls in Order 19.
TIME_20 DATE

Time of Previous Calls in Order 20.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CALL_HISTORY_ID
,      RETURNS_ID
,      CONTACT_POINT
,      CALL_ATTEMPT
,      OUTCOME_ID_0
,      OUTCOME_ID_1
,      OUTCOME_ID_2
,      OUTCOME_ID_3
,      OUTCOME_ID_4
,      OUTCOME_ID_5
,      OUTCOME_ID_6
,      OUTCOME_ID_7
,      OUTCOME_ID_8
,      OUTCOME_ID_9
,      OUTCOME_ID_10
,      OUTCOME_ID_11
,      OUTCOME_ID_12
,      OUTCOME_ID_13
,      OUTCOME_ID_14
,      OUTCOME_ID_15
,      OUTCOME_ID_16
,      OUTCOME_ID_17
,      OUTCOME_ID_18
,      OUTCOME_ID_19
,      OUTCOME_ID_20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      TIME_0
,      TIME_1
,      TIME_2
,      TIME_3
,      TIME_4
,      TIME_5
,      TIME_6
,      TIME_7
,      TIME_8
,      TIME_9
,      TIME_10
,      TIME_11
,      TIME_12
,      TIME_13
,      TIME_14
,      TIME_15
,      TIME_16
,      TIME_17
,      TIME_18
,      TIME_19
,      TIME_20
FROM IEC.IEC_O_RCY_CALL_HISTORIES;

Dependencies

[top of page]

IEC.IEC_O_RCY_CALL_HISTORIES does not reference any database object

IEC.IEC_O_RCY_CALL_HISTORIES is referenced by following:

SchemaAPPS
SynonymIEC_O_RCY_CALL_HISTORIES