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]

VIEW: IEC.IEC_O_RCY_CALL_HISTORIES#

Object Details

Object Name:	IEC_O_RCY_CALL_HISTORIES#
Object Type:	VIEW
Owner:	IEC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CALL_HISTORY_ID	NUMBER	(15)	Yes
RETURNS_ID	NUMBER	(15)	Yes
CONTACT_POINT	VARCHAR2	(60)
CALL_ATTEMPT	NUMBER	(10)
OUTCOME_ID_0	NUMBER	(10)
OUTCOME_ID_1	NUMBER	(10)
OUTCOME_ID_2	NUMBER	(10)
OUTCOME_ID_3	NUMBER	(10)
OUTCOME_ID_4	NUMBER	(10)
OUTCOME_ID_5	NUMBER	(10)
OUTCOME_ID_6	NUMBER	(10)
OUTCOME_ID_7	NUMBER	(10)
OUTCOME_ID_8	NUMBER	(10)
OUTCOME_ID_9	NUMBER	(10)
OUTCOME_ID_10	NUMBER	(10)
OUTCOME_ID_11	NUMBER	(10)
OUTCOME_ID_12	NUMBER	(10)
OUTCOME_ID_13	NUMBER	(10)
OUTCOME_ID_14	NUMBER	(10)
OUTCOME_ID_15	NUMBER	(10)
OUTCOME_ID_16	NUMBER	(10)
OUTCOME_ID_17	NUMBER	(10)
OUTCOME_ID_18	NUMBER	(10)
OUTCOME_ID_19	NUMBER	(10)
OUTCOME_ID_20	NUMBER	(10)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SECURITY_GROUP_ID	NUMBER	(10)
TIME_0	DATE
TIME_1	DATE
TIME_2	DATE
TIME_3	DATE
TIME_4	DATE
TIME_5	DATE
TIME_6	DATE
TIME_7	DATE
TIME_8	DATE
TIME_9	DATE
TIME_10	DATE
TIME_11	DATE
TIME_12	DATE
TIME_13	DATE
TIME_14	DATE
TIME_15	DATE
TIME_16	DATE
TIME_17	DATE
TIME_18	DATE
TIME_19	DATE
TIME_20	DATE

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# references the following:

IEC: IEC_O_RCY_CALL_HISTORIES

IEC.IEC_O_RCY_CALL_HISTORIES# is referenced by following:

APPS: IEC_O_RCY_CALL_HISTORIES