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_STG_LOG

Object Details

Object Name:	JTF_IH_ACTIVITIES_STG_LOG
Object Type:	TABLE
Owner:	JTF
FND Design Data:	JTF.JTF_IH_ACTIVITIES_STG_LOG
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_INTERFACE
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JTF_IH_ACTIVITIES_STG_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CUST_ACCOUNT_PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_ID	NUMBER	(15)	Yes	Unique Activity Identifier
SESSION_NO	NUMBER		Yes	Session Number for JTF_IH_IMPORT
ERROR_MESSAGE	VARCHAR2	(2000)		Error Message
SESSION_DATE	DATE			Session Date for JTF_IH_IMPORT
SCRIPT_TRANS_ID	NUMBER			Script Trans 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_ACCOUNT_PARTY_ID	NUMBER	(15)		This column is obsolete/unused
CUST_ORG_ID	NUMBER			Operating Unit Identifier
INTERACTION_ID	NUMBER	(15)	Yes	Unique ID in GUID format.
ACTION_ITEM_ID	NUMBER		Yes	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
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

Query Text

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


SELECT ACTIVITY_ID
,      SESSION_NO
,      ERROR_MESSAGE
,      SESSION_DATE
,      SCRIPT_TRANS_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_ACCOUNT_PARTY_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
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      AVT_SCRIPT_ID
FROM JTF.JTF_IH_ACTIVITIES_STG_LOG;

Dependencies

[top of page]

JTF.JTF_IH_ACTIVITIES_STG_LOG does not reference any database object

JTF.JTF_IH_ACTIVITIES_STG_LOG is referenced by following:

JTF: JTF_IH_ACTIVITIES_STG_LOG#