[Home] [Help] [Dependency Information]
Object Name: | IEC_O_RCY_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_RCY_CALL_HISTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CALL_HISTORY_ID |
IEC_O_RCY_CALL_HISTORIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RETURNS_ID |
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. |
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;
IEC.IEC_O_RCY_CALL_HISTORIES does not reference any database object
IEC.IEC_O_RCY_CALL_HISTORIES is referenced by following:
|
|
|