[Home] [Help] [Dependency Information]
Object Name: | AMS_DLG_INTERACTIONS |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_DLG_INTERACTIONS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_DLG_INTERACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_ARCHIVE | INTERACTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERACTION_ID | NUMBER | Yes | Unique identifier of dialog interaction | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
OBJECT_TYPE | VARCHAR2 | (30) | Yes | The marketing object type, cause of this interaction. |
OBJECT_ID | NUMBER | Yes | Identifier of the particular marketing object , cause of this interaction | |
START_DATE_TIME | DATE | Yes | The date and time the interaction started | |
SOURCE_CODE | VARCHAR2 | (30) | Source code of the marketing object caused this interaction | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
OBJECT_VERSION_NUMBER | NUMBER | Used for locking purpose | ||
SOURCE_CODE_ID | NUMBER | Unique Identifier for marketing source code | ||
END_DATE_TIME | DATE | The date and time when the interaction ends | ||
RESULT_ID | NUMBER | Result of the interaction. This refers to Result in Interaction History | ||
REASON_ID | NUMBER | Reason of the interaction. This refers to Reason in Interaction History | ||
OUTCOME_ID | NUMBER | Yes | Outcome Identifier represents outcome of the interaction. This also refers to Outcome in Interaction History | |
PARTY_ID | NUMBER | Yes | Party identifier who is part of this interaction | |
RESOURCE_ID | NUMBER | Yes | For a non-self-service interaction, the resource who is helping the customer in this interaction. | |
ACTIVE_FLAG | VARCHAR2 | (1) | This flag indicates if this interaction is active or completed | |
SYNCHRONIZED_FLAG | VARCHAR2 | (1) | This flag indicates if the interaction is synchronized with interaction history or not | |
RELATED_SOURCE_CODE | VARCHAR2 | (30) | Source code of any other marketing object that's part of this intercation | |
TOUCH_POINT_TYPE | VARCHAR2 | (30) | Interaction touch point type | |
SECURITY_GROUP_ID | NUMBER | Used for Hosting Purposes |
Cut, paste (and edit) the following text to query this object:
SELECT INTERACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, OBJECT_TYPE
, OBJECT_ID
, START_DATE_TIME
, SOURCE_CODE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SOURCE_CODE_ID
, END_DATE_TIME
, RESULT_ID
, REASON_ID
, OUTCOME_ID
, PARTY_ID
, RESOURCE_ID
, ACTIVE_FLAG
, SYNCHRONIZED_FLAG
, RELATED_SOURCE_CODE
, TOUCH_POINT_TYPE
, SECURITY_GROUP_ID
FROM AMS.AMS_DLG_INTERACTIONS;
AMS.AMS_DLG_INTERACTIONS does not reference any database object
AMS.AMS_DLG_INTERACTIONS is referenced by following:
|
|
|