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_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Used for generating reports for records in table JTF_IH_INTERACTIONS.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
INTERACTION_ID	NUMBER	(15)	Yes	Unique Interaction Identifier
OBJECT_VERSION_NUMBER	NUMBER	(9)		Sequential number used for database locking control when using HTML as a user interface.
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_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
INTERACTION_INTERS_ID	NUMBER			Links Interactions
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.
SOURCE_CODE	VARCHAR2	(100)		Source Code provided by the customer
SOURCE_CODE_ID	NUMBER			Unique identifier for Marketing Source Code
REFERENCE_FORM	VARCHAR2	(1000)		Legacy column for 3i Interaction Manager
DURATION	NUMBER			Legacy column for 3i Interaction Manager
END_DATE_TIME	DATE			The date and time the interaction ended
FOLLOW_UP_ACTION	VARCHAR2	(80)		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.
RESULT_ID	NUMBER			Result Identifier
REASON_ID	NUMBER			Reason Identifier
START_DATE_TIME	DATE			The date and time the interaction started
OUTCOME_ID	NUMBER			Outcome Identifier
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.
HANDLER_ID	NUMBER		Yes	Handler Identifier from FND_APPLICATION
INTER_INTERACTION_DURATION	NUMBER			The number of seconds between the end of the last interaction and the beginning of the current interaction
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.
SCRIPT_ID	NUMBER			Script Identifier
PARTY_ID	NUMBER		Yes	Party Identifier for Customer
RESOURCE_ID	NUMBER		Yes	Resource Identifier for Agent
METHOD_CODE	VARCHAR2	(30)		Legacy column for 3i Interaction Manager
ACTIVE	VARCHAR2	(1)	Yes	Used for Interaction History interaction caching.
CONTACT_PARTY_ID	NUMBER			Contact Party Identifier
CONTACT_REL_PARTY_ID	NUMBER			Contact Relationship Party Identifier
PRIMARY_PARTY_ID	NUMBER			Primary Party Identifier for the interaction.

Query Text

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


SELECT ROW_ID
,      INTERACTION_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      INTERACTION_INTERS_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      REFERENCE_FORM
,      DURATION
,      END_DATE_TIME
,      FOLLOW_UP_ACTION
,      NON_PRODUCTIVE_TIME_AMOUNT
,      RESULT_ID
,      REASON_ID
,      START_DATE_TIME
,      OUTCOME_ID
,      PREVIEW_TIME_AMOUNT
,      PRODUCTIVE_TIME_AMOUNT
,      HANDLER_ID
,      INTER_INTERACTION_DURATION
,      WRAP_UP_TIME_AMOUNT
,      SCRIPT_ID
,      PARTY_ID
,      RESOURCE_ID
,      METHOD_CODE
,      ACTIVE
,      CONTACT_PARTY_ID
,      CONTACT_REL_PARTY_ID
,      PRIMARY_PARTY_ID
FROM APPS.JTF_IH_INTERACTIONS_V;

Dependencies

[top of page]

APPS.JTF_IH_INTERACTIONS_V references the following:

APPS: JTF_IH_INTERACTIONS

APPS.JTF_IH_INTERACTIONS_V is referenced by following:

APPS: OKL_CS_IH_ACTIVITIES_UV