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

VIEW: IEM.IEM_RT_INTERACTIONS#

Object Details
Object Name: IEM_RT_INTERACTIONS#
Object Type: VIEW
Owner: IEM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RT_INTERACTION_ID NUMBER (15) Yes
CUSTOMER_ID NUMBER (15)
INTERACTION_ID NUMBER (15)
RESOURCE_ID NUMBER (15)
STATUS VARCHAR2 (2)
TYPE VARCHAR2 (2)
EXPIRE VARCHAR2 (1)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

SECURITY_GROUP_ID NUMBER

SERVICE_REQUEST_ID NUMBER (15)
SERVICE_REQUEST_ACTION VARCHAR2 (8)
CONTACT_ID NUMBER (15)
MC_PARAMETER_ID NUMBER (15)
IH_CREATOR VARCHAR2 (1)
INB_TAG_ID VARCHAR2 (30)
PARENT_INTERACTION_ID NUMBER (15)
ACTION_ID NUMBER (15)
ACTION_ITEM_ID NUMBER (15)
REASON_ID NUMBER (15)
RESULT_ID NUMBER (15)
OUTCOME_ID NUMBER (15)
TO_RESOURCE_ID NUMBER (15)
APPLICATION_ID NUMBER (15)
RESPONSIBILITY_ID NUMBER (15)
LEAD_ID NUMBER (15)
LEAD_ACTION VARCHAR2 (8)
SPV_RESOURCE_ID NUMBER

RELATIONSHIP_ID NUMBER (15)
Query Text

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


SELECT RT_INTERACTION_ID
,      CUSTOMER_ID
,      INTERACTION_ID
,      RESOURCE_ID
,      STATUS
,      TYPE
,      EXPIRE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      SERVICE_REQUEST_ID
,      SERVICE_REQUEST_ACTION
,      CONTACT_ID
,      MC_PARAMETER_ID
,      IH_CREATOR
,      INB_TAG_ID
,      PARENT_INTERACTION_ID
,      ACTION_ID
,      ACTION_ITEM_ID
,      REASON_ID
,      RESULT_ID
,      OUTCOME_ID
,      TO_RESOURCE_ID
,      APPLICATION_ID
,      RESPONSIBILITY_ID
,      LEAD_ID
,      LEAD_ACTION
,      SPV_RESOURCE_ID
,      RELATIONSHIP_ID
FROM IEM.IEM_RT_INTERACTIONS#;

Dependencies

[top of page]

IEM.IEM_RT_INTERACTIONS# references the following:

SchemaIEM
TableIEM_RT_INTERACTIONS
IEM.IEM_RT_INTERACTIONS# is referenced by following:

SchemaAPPS
SynonymIEM_RT_INTERACTIONS