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]

TABLE: JTF.JTF_IH_ACTIVITIES

Object Details

Object Name:	JTF_IH_ACTIVITIES
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_IH_ACTIVITIES
Subobject Name:
Status:	VALID

An act performed by a human or automated agent as part of an Interaction. An Interaction Activity can be related to the handling of the Media Items related to the Interaction (example: answering a call, transferring a call, etc.) . An Interaction Activity can be related to the business functions performed during an Interaction (Example: performing a balance inquiry, providing product information, providing pricing on a product, Up-selling a product). Interaction Activities can be related directly to a Media Item that caused the activity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_IH_ACTIVITIES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_ID
JTF_IH_ACTIVITIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_ITEM_ID
JTF_IH_ACTIVITIES_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_ID
JTF_IH_ACTIVITIES_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE_TIME
JTF_IH_ACTIVITIES_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE_TIME
JTF_IH_ACTIVITIES_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
JTF_IH_ACTIVITIES_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
JTF_IH_ACTIVITIES_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_REF
JTF_IH_ACTIVITIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_ID
JTF_IH_ACTIVITIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID
JTF_IH_ACTIVITIES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTERACTION_ID
JTF_IH_ACTIVITIES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEDIA_ID
JTF_IH_ACTIVITIES_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OUTCOME_ID
JTF_IH_ACTIVITIES_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REASON_ID
JTF_IH_ACTIVITIES_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESULT_ID
JTF_IH_ACTIVITIES_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_CODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_ID	NUMBER	(15)	Yes	Unique Activity 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_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated 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).
DOC_SOURCE_OBJECT_NAME	VARCHAR2	(80)		Application source document name or number.
CUST_ACCOUNT_ID	NUMBER			Customer Account Identifier.
CUST_ORG_ID	NUMBER			Operating Unit Identifier
INTERACTION_ID	NUMBER	(15)	Yes	Unique ID in GUID format.
ACTION_ITEM_ID	NUMBER			Unique Action Item Identifier
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_ID	NUMBER			Unique identifier for Marketing Source Code
SOURCE_CODE	VARCHAR2	(100)		Source Code provided by the customer
DOC_ID	NUMBER			Application document reference.
DOC_REF	VARCHAR2	(30)		Reference to JTF_OBJECTS column OBJECT_CODE.
RESULT_ID	NUMBER			Results Identifier
REASON_ID	NUMBER			Reason identifier
MEDIA_ID	NUMBER			Media identifier
OUTCOME_ID	NUMBER			Outcome identifier
TASK_ID	NUMBER			Task identifier
ACTION_ID	NUMBER			Action identifier
DURATION	NUMBER			The number of seconds between the start and end of the activity
DESCRIPTION	VARCHAR2	(1000)		Activity description.
END_DATE_TIME	DATE			The ending date and time for the activity
ROLE	VARCHAR2	(240)		Legacy column for 3i Interaction Manager
START_DATE_TIME	DATE			The starting date and time for the activity
INTERACTION_ACTION_TYPE	VARCHAR2	(240)		Legacy column for 3i Interaction Manager
ACTIVE	VARCHAR2	(1)	Yes	Used for Interaction History caching.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	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
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
DOC_SOURCE_STATUS	VARCHAR2	(80)		Doc Source Status
ORIG_SYSTEM_REFERENCE	VARCHAR2	(60)		Orig System Reference
ORIG_SYSTEM_REFERENCE_ID	NUMBER			Orig System Reference Id
UPGRADED_STATUS_FLAG	VARCHAR2	(1)		Upgrade Status Flag
UPG_ORIG_SYSTEM_REF	VARCHAR2	(60)		Upg Orig System Ref
UPG_ORIG_SYSTEM_REF_ID	NUMBER			Upg Orig System Ref Id
SCRIPT_TRANS_ID	NUMBER			Script Trans identifier
CUST_ACCOUNT_PARTY_ID	NUMBER	(15)		This column is obsolete/unused
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
AVT_SCRIPT_ID	NUMBER	(15)		Avt Script Id
BULK_WRITER_CODE	VARCHAR2	(240)		Builk Writer Code
BULK_BATCH_TYPE	VARCHAR2	(240)		Subtype used by the calling Writer to categorize types of Interaction request
BULK_BATCH_ID	NUMBER			Builk Batch Identifier
BULK_INTERACTION_ID	NUMBER			Interaction identifier

Query Text

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


SELECT ACTIVITY_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DOC_SOURCE_OBJECT_NAME
,      CUST_ACCOUNT_ID
,      CUST_ORG_ID
,      INTERACTION_ID
,      ACTION_ITEM_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      SOURCE_CODE_ID
,      SOURCE_CODE
,      DOC_ID
,      DOC_REF
,      RESULT_ID
,      REASON_ID
,      MEDIA_ID
,      OUTCOME_ID
,      TASK_ID
,      ACTION_ID
,      DURATION
,      DESCRIPTION
,      END_DATE_TIME
,      ROLE
,      START_DATE_TIME
,      INTERACTION_ACTION_TYPE
,      ACTIVE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOC_SOURCE_STATUS
,      ORIG_SYSTEM_REFERENCE
,      ORIG_SYSTEM_REFERENCE_ID
,      UPGRADED_STATUS_FLAG
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      SCRIPT_TRANS_ID
,      CUST_ACCOUNT_PARTY_ID
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      AVT_SCRIPT_ID
,      BULK_WRITER_CODE
,      BULK_BATCH_TYPE
,      BULK_BATCH_ID
,      BULK_INTERACTION_ID
FROM JTF.JTF_IH_ACTIVITIES;

Dependencies

[top of page]

JTF.JTF_IH_ACTIVITIES does not reference any database object

JTF.JTF_IH_ACTIVITIES is referenced by following:

JTF: JTF_IH_ACTIVITIES#