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

VIEW: APPS.CSC_INTERACTIONS_V

Object Details
Object Name: CSC_INTERACTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSC.CSC_INTERACTIONS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTERACTION_ID NUMBER (15) Yes Party Identifier for Customer
ROW_ID ROWID (10)
Standard Row ID column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
PARTY_ID NUMBER
Yes Party Identifier. FK to HZ_PARTIES.
PARTY_NAME VARCHAR2 (360) Yes Party Name
RESOURCE_ID NUMBER
Yes Resource_ID from JTF_IH_INTERACTIONS
RESOURCE_NAME VARCHAR2 (360)
Resource Name (Party Name form hz_parties)
PRIMARY_PARTY_ID NUMBER

Party Id from HZ_PARTIES
CONTACT_PARTY_ID NUMBER

Party Id from HZ_PARTIES
CONTACT_REL_PARTY_ID NUMBER

Party ID from HZ_PARTIES
CONTACT_NAME VARCHAR2 (360)
Party Name from HZ_PARTIES
START_DATE_TIME DATE

The date and time the interaction started
END_DATE_TIME DATE

The date and time the interaction ended
DURATION NUMBER

The number of seconds that the interaction was active
OUTCOME_ID NUMBER

Outcome Identifier
OUTCOME_CODE VARCHAR2 (80)
Outcome Code
OUT_DESC VARCHAR2 (240)
High level Textual Description
RESULT_ID NUMBER

Result Identifier
RESULT_CODE VARCHAR2 (80)
Reason Code
RSL_DESC VARCHAR2 (240)
High level Textual Description
REASON_ID NUMBER

Reason Identifier
REASON_CODE VARCHAR2 (80)
Reason Code
REA_DESC VARCHAR2 (240)
High level Textual Description
FOLLOW_UP_ACTION VARCHAR2 (80)
Legacy column for 3i Interaction Manager
INTER_INTERACTION_DURATION NUMBER

The number of seconds between the end of the last interaction and the beginning of the
INTERACTION_INTERS_ID NUMBER

Links Interactions
METHOD_CODE VARCHAR2 (30)
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.
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.
OBJECT_VERSION_NUMBER NUMBER (9)
Sequential number used for database locking control when using HTML as a user
PREVIEW_TIME_AMOUNT NUMBER

The number of seconds the agent previewed the interaction item before initiating the
PRODUCTIVE_TIME_AMOUNT NUMBER

The number of seconds the agent was considered productive since the end of the last
REFERENCE_FORM VARCHAR2 (1000)
Legacy column for 3i Interaction Manager
SCRIPT_ID NUMBER

Script Identifier
SOURCE_CODE VARCHAR2 (100)
Source Code provided by the customer
SOURCE_CODE_ID NUMBER

Unique identifier for Marketing Source Code
WRAP_UP_TIME_AMOUNT NUMBER

The number of seconds that agent spent on the interaction from the closing of the last
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment column
Query Text

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


SELECT INTERACTION_ID
,      ROW_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PARTY_ID
,      PARTY_NAME
,      RESOURCE_ID
,      RESOURCE_NAME
,      PRIMARY_PARTY_ID
,      CONTACT_PARTY_ID
,      CONTACT_REL_PARTY_ID
,      CONTACT_NAME
,      START_DATE_TIME
,      END_DATE_TIME
,      DURATION
,      OUTCOME_ID
,      OUTCOME_CODE
,      OUT_DESC
,      RESULT_ID
,      RESULT_CODE
,      RSL_DESC
,      REASON_ID
,      REASON_CODE
,      REA_DESC
,      FOLLOW_UP_ACTION
,      INTER_INTERACTION_DURATION
,      INTERACTION_INTERS_ID
,      METHOD_CODE
,      NON_PRODUCTIVE_TIME_AMOUNT
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_VERSION_NUMBER
,      PREVIEW_TIME_AMOUNT
,      PRODUCTIVE_TIME_AMOUNT
,      REFERENCE_FORM
,      SCRIPT_ID
,      SOURCE_CODE
,      SOURCE_CODE_ID
,      WRAP_UP_TIME_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.CSC_INTERACTIONS_V;

Dependencies

[top of page]

APPS.CSC_INTERACTIONS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymJTF_IH_INTERACTIONS
SynonymJTF_IH_OUTCOMES_TL
SynonymJTF_IH_REASONS_TL
SynonymJTF_IH_RESULTS_TL
ViewJTF_RS_RESOURCE_EXTNS_VL

APPS.CSC_INTERACTIONS_V is not referenced by any database object