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: APPS.JTF_IH_INTERACTIONS_ONLY_VL

Object Details

Object Name:	JTF_IH_INTERACTIONS_ONLY_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_IH_INTERACTIONS_ONLY_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Allows to report on customer interactions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INTERACTION_ID	NUMBER	(15)	Yes	Interaction Identifier
ROW_ID	ROWID	(10)		Row Identifier
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ACTIVE	VARCHAR2	(1)	Yes	Used for Interaction History activity caching.
PARTY_ID	NUMBER		Yes	Party Identifier
PARTY_NAME	VARCHAR2	(360)	Yes	Party Name
RESOURCE_ID	NUMBER		Yes	Resource identifier
RESOURCE_NAME	VARCHAR2	(360)		Resource Name
HANDLER_ID	NUMBER		Yes	Program identifier of last concurrent program to update this record
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	Application Short Name
CUST_ACCOUNT_ID	NUMBER			Customer Account Identifier.
START_DATE_TIME	DATE			The starting date and time for the activity
END_DATE_TIME	DATE			The ending date and time for the activity
DURATION	NUMBER			The number of seconds between the start and end of the activity
OUTCOME_ID	NUMBER			Outcome identifier
OUTCOME_CODE	VARCHAR2	(80)		Outcome Code
OUT_DESC	VARCHAR2	(240)	Yes	Outcome Description
RESULT_ID	NUMBER			Result Identifier
RESULT_CODE	VARCHAR2	(80)		Result Code
RSL_DESC	VARCHAR2	(240)		Result Short Description
REASON_ID	NUMBER			Reason Identifier
REASON_CODE	VARCHAR2	(80)		Reason Code
REA_DESC	VARCHAR2	(240)		Reason Description
FOLLOW_UP_ACTION	VARCHAR2	(80)		Legacy column for 3i Interaction Manager
INTER_INTERACTION_DURATION	NUMBER			The number of seconds between the end of the last interaction and the beginning of the current interaction
INTERACTION_INTERS_ID	NUMBER			Links Interactions
METHOD_CODE	VARCHAR2	(30)		Legacy column for 3i Interaction Manager
NON_PRODUCTIVE_TIME_AMOUNT	NUMBER			The number of seconds the agent was considered non-productive since the end of the last interaction and end of the current interaction.
OBJECT_ID	NUMBER			The Primary Key for the Oracle Marketing table relating to the object type.
OBJECT_TYPE	VARCHAR2	(30)		Oracle Marketing type of source code.
OBJECT_VERSION_NUMBER	NUMBER	(9)		Sequential number used for database locking control when using HTML as a user interface.
PREVIEW_TIME_AMOUNT	NUMBER			The number of seconds the agent previewed the interaction item before initiating the interaction
PRODUCTIVE_TIME_AMOUNT	NUMBER			The number of seconds the agent was considered productive since the end of the last interaction and end of the current interaction.
REFERENCE_FORM	VARCHAR2	(1000)		Legacy column for 3i Interaction Manager
SCRIPT_ID	NUMBER			Script Identifier
SOURCE_CODE	VARCHAR2	(100)		Source Code provided by the customer
SOURCE_CODE_ID	NUMBER			Unique identifier for Marketing Source Code
WRAP_UP_TIME_AMOUNT	NUMBER			The number of seconds that agent spent on the interaction from the closing of the last media item to the conclusion of the interaction.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
APPLICATION_NAME	VARCHAR2	(240)	Yes
OUTCOME_SHORT_DESC	VARCHAR2	(240)	Yes
RESULT_SHORT_DESC	VARCHAR2	(240)
REASON_SHORT_DESC	VARCHAR2	(240)
BULK_WRITER_CODE	VARCHAR2	(240)
BULK_BATCH_TYPE	VARCHAR2	(240)
BULK_BATCH_ID	NUMBER
BULK_INTERACTION_ID	NUMBER

Query Text

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


SELECT INTERACTION_ID
,      ROW_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ACTIVE
,      PARTY_ID
,      PARTY_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      HANDLER_ID
,      APPLICATION_SHORT_NAME
,      CUST_ACCOUNT_ID
,      START_DATE_TIME
,      END_DATE_TIME
,      DURATION
,      OUTCOME_ID
,      OUTCOME_CODE
,      OUT_DESC
,      RESULT_ID
,      RESULT_CODE
,      RSL_DESC
,      REASON_ID
,      REASON_CODE
,      REA_DESC
,      FOLLOW_UP_ACTION
,      INTER_INTERACTION_DURATION
,      INTERACTION_INTERS_ID
,      METHOD_CODE
,      NON_PRODUCTIVE_TIME_AMOUNT
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_VERSION_NUMBER
,      PREVIEW_TIME_AMOUNT
,      PRODUCTIVE_TIME_AMOUNT
,      REFERENCE_FORM
,      SCRIPT_ID
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      WRAP_UP_TIME_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      APPLICATION_NAME
,      OUTCOME_SHORT_DESC
,      RESULT_SHORT_DESC
,      REASON_SHORT_DESC
,      BULK_WRITER_CODE
,      BULK_BATCH_TYPE
,      BULK_BATCH_ID
,      BULK_INTERACTION_ID
FROM APPS.JTF_IH_INTERACTIONS_ONLY_VL;

Dependencies

[top of page]

APPS.JTF_IH_INTERACTIONS_ONLY_VL references the following:

APPS: FND_APPLICATION_VL; HZ_CUST_ACCOUNTS; HZ_PARTIES; JTF_IH_ACTIVITIES; JTF_IH_INTERACTIONS; JTF_IH_OUTCOMES_TL; JTF_IH_REASONS_TL; JTF_IH_RESULTS_TL; JTF_RS_RESOURCE_EXTNS_VL

APPS.JTF_IH_INTERACTIONS_ONLY_VL is not referenced by any database object