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

VIEW: APPS.JTF_IH_ACTIVITIES_V

Object Details
Object Name: JTF_IH_ACTIVITIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_IH_ACTIVITIES_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_ACTIVITIES.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
DOC_SOURCE_OBJECT_NAME VARCHAR2 (80)
Application source document name or number.
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).
CUST_ACCOUNT_ID NUMBER

Customer Account Identifier.
CUST_ORG_ID NUMBER

Operating Unit Identifier
INTERACTION_ID NUMBER (15) Yes Unique Interaction Identifier
ACTION_ITEM_ID NUMBER

Unique Action Item Identifier
ACTION_ITEM VARCHAR2 (80)
Action Item Code
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 activity caching.
SCRIPT_TRANS_ID NUMBER

Script TransID idenfier
Query Text

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


SELECT ROW_ID
,      DOC_SOURCE_OBJECT_NAME
,      ACTIVITY_ID
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CUST_ACCOUNT_ID
,      CUST_ORG_ID
,      INTERACTION_ID
,      ACTION_ITEM_ID
,      ACTION_ITEM
,      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
,      SCRIPT_TRANS_ID
FROM APPS.JTF_IH_ACTIVITIES_V;

Dependencies

[top of page]

APPS.JTF_IH_ACTIVITIES_V references the following:

SchemaAPPS
SynonymJTF_IH_ACTION_ITEMS_TL
SynonymJTF_IH_ACTIVITIES
APPS.JTF_IH_ACTIVITIES_V is referenced by following:

SchemaAPPS
ViewCS_SR_FULFIL_STATUS_V