DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JTF_IH_ACTIVITIES_VL3

Object Details
Object Name: JTF_IH_ACTIVITIES_VL3
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_IH_ACTIVITIES_VL3
Subobject Name:
Status: VALID

View Type

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


Interactio History Activities view


[View Source]

Columns
Name Datatype Length Mandatory Comments
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).
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
ACTIVE VARCHAR2 (1) Yes Used for Interaction History activity caching.
START_DATE_TIME DATE

The starting date and time for the activity
END_DATE_TIME DATE

The ending date and time for the activity
TASK_ID NUMBER

Task identifier
DOC_ID NUMBER

Doc identifier
DOC_REF VARCHAR2 (30)
Reference to JTF_OBJECTS column OBJECT_CODE.
DOC_SOURCE_OBJECT_NAME VARCHAR2 (80)
Application source document name or number.
DURATION NUMBER

The number of seconds between the start and end of the activity
DESCRIPTION VARCHAR2 (1000)
Activity description.
ROLE VARCHAR2 (240)
Legacy column for 3i Interaction Manager
OUTCOME_ID NUMBER

Outcome identifier
MEDIA_ID NUMBER

Media identifier
ACTIVITY_ID NUMBER (15) Yes Unique Activity identifier
INTERACTION_ID NUMBER (15) Yes Unique ID in GUID format.
RESULT_ID NUMBER

Results identifier
REASON_ID NUMBER

Reasons identifier
ACTION_ITEM_ID NUMBER

Action Items identifier
ACTION_ID NUMBER

Action identifier
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
INTERACTION_ACTION_TYPE VARCHAR2 (240)
Legacy column for 3i Interaction Manager
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number used for database locking control when using HTML as a user interface.
CUST_ACCOUNT_ID NUMBER

Customer Account Identifier.
OBJECT_ID NUMBER

The Primary Key for the Oracle Marketing table relating to the object type.
PARTY_NAME VARCHAR2 (360) Yes Party Name
RESOURCE_ID NUMBER
Yes Resource identifier
HANDLER_ID NUMBER
Yes Program identifier of last concurrent program to update this record
PARTY_ID NUMBER
Yes Parties identifier
RESOURCE_NAME VARCHAR2 (360)
Resource name
DIRECTION VARCHAR2 (240)
Direction
MEDIA_DATA VARCHAR2 (80)
Reference to Media data from media provider
MEDIA_ITEM_REF VARCHAR2 (240)
Media reference to JTF_OBJECTS column OJBECT_CODE
MEDIA_ITEM_TYPE VARCHAR2 (80)
Type of Media, such as telephone, email, or fax.
MEDIADIRTYPE VARCHAR2 (320)
Type of Media, such as telephone, email, or fax.
MEDIA_SOURCE_ITEM_ID NUMBER

Media item source object ID
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application Short Name
OUTCOME_CODE VARCHAR2 (80)
Outcome Code
OUT_DESC VARCHAR2 (240)
Outcome Description
RESULT_CODE VARCHAR2 (80)
Result Description
RSL_DESC VARCHAR2 (240)
Result Short Description
REASON_CODE VARCHAR2 (80)
Reason Code
REA_DESC VARCHAR2 (240)
Reasons Short Description
ACTION VARCHAR2 (80)
Action Code
ACTION_ITEM VARCHAR2 (80)
Action Item Code
ACTITM VARCHAR2 (160)
Action Code +Action Item Code
ACCOUNT_NUMBER VARCHAR2 (30)
Account Number
OBJECT_FUNCTION VARCHAR2 (30)
Oracle Applications internal function name of a form
OBJECT_PARAMETERS VARCHAR2 (2000)
Any optional parameters
SCRIPT_TRANS_ID NUMBER

Script Transaction identifier
APPLICATION_NAME VARCHAR2 (240) Yes
OUTCOME_SHORT_DESC VARCHAR2 (240)
RESULT_SHORT_DESC VARCHAR2 (240)
REASON_SHORT_DESC VARCHAR2 (240)
ACTION_ITEM_SHORT_DESC VARCHAR2 (240)
ACTION_SHORT_DESC VARCHAR2 (240)
BULK_WRITER_CODE VARCHAR2 (240)
BULK_BATCH_TYPE VARCHAR2 (240)
BULK_BATCH_ID NUMBER

BULK_INTERACTION_ID NUMBER

CONTACT_PARTY_ID NUMBER

Contact Party Identifier
CONTACT_REL_PARTY_ID NUMBER

Contact Relationship Party Identifier
PRIMARY_PARTY_ID NUMBER

Primary Party Identifier
CUSTOMER_NAME VARCHAR2 (360)
Contact Name, based on Primary Party Identifier
CONTACT_NAME VARCHAR2 (360)
Customer Name, based on Contact Party Identifier
LAUNCH_METHOD VARCHAR2 (30)
DIRECTION_DESC VARCHAR2 (80)
Translatable Direction Description
MEDIA_ITEM_DESC VARCHAR2 (240)
Translatable media item description
Query Text

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


SELECT ROW_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ACTIVE
,      START_DATE_TIME
,      END_DATE_TIME
,      TASK_ID
,      DOC_ID
,      DOC_REF
,      DOC_SOURCE_OBJECT_NAME
,      DURATION
,      DESCRIPTION
,      ROLE
,      OUTCOME_ID
,      MEDIA_ID
,      ACTIVITY_ID
,      INTERACTION_ID
,      RESULT_ID
,      REASON_ID
,      ACTION_ITEM_ID
,      ACTION_ID
,      OBJECT_TYPE
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      INTERACTION_ACTION_TYPE
,      OBJECT_VERSION_NUMBER
,      CUST_ACCOUNT_ID
,      OBJECT_ID
,      PARTY_NAME
,      RESOURCE_ID
,      HANDLER_ID
,      PARTY_ID
,      RESOURCE_NAME
,      DIRECTION
,      MEDIA_DATA
,      MEDIA_ITEM_REF
,      MEDIA_ITEM_TYPE
,      MEDIADIRTYPE
,      MEDIA_SOURCE_ITEM_ID
,      APPLICATION_SHORT_NAME
,      OUTCOME_CODE
,      OUT_DESC
,      RESULT_CODE
,      RSL_DESC
,      REASON_CODE
,      REA_DESC
,      ACTION
,      ACTION_ITEM
,      ACTITM
,      ACCOUNT_NUMBER
,      OBJECT_FUNCTION
,      OBJECT_PARAMETERS
,      SCRIPT_TRANS_ID
,      APPLICATION_NAME
,      OUTCOME_SHORT_DESC
,      RESULT_SHORT_DESC
,      REASON_SHORT_DESC
,      ACTION_ITEM_SHORT_DESC
,      ACTION_SHORT_DESC
,      BULK_WRITER_CODE
,      BULK_BATCH_TYPE
,      BULK_BATCH_ID
,      BULK_INTERACTION_ID
,      CONTACT_PARTY_ID
,      CONTACT_REL_PARTY_ID
,      PRIMARY_PARTY_ID
,      CUSTOMER_NAME
,      CONTACT_NAME
,      LAUNCH_METHOD
,      DIRECTION_DESC
,      MEDIA_ITEM_DESC
FROM APPS.JTF_IH_ACTIVITIES_VL3;

Dependencies

[top of page]

APPS.JTF_IH_ACTIVITIES_VL3 references the following:

SchemaAPPS
ViewFND_APPLICATION_VL
SynonymFND_LOOKUP_VALUES
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymJTF_IH_ACTIONS_TL
SynonymJTF_IH_ACTION_ITEMS_TL
SynonymJTF_IH_ACTIVITIES
SynonymJTF_IH_INTERACTIONS
SynonymJTF_IH_MEDIA_ITEMS
SynonymJTF_IH_OUTCOMES_TL
SynonymJTF_IH_REASONS_TL
SynonymJTF_IH_RESULTS_TL
SynonymJTF_OBJECTS_B
ViewJTF_RS_RESOURCE_EXTNS_VL
SynonymJTF_TASKS_B

APPS.JTF_IH_ACTIVITIES_VL3 is not referenced by any database object