eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.CS_SR_INTERACTIONS_V

Object Details

Object Name:	CS_SR_INTERACTIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_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
ROW_ID	ROWID	(10)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
PARTY_ID	NUMBER		Yes
PARTY_NAME	VARCHAR2	(360)	Yes
START_DATE_TIME	DATE
END_DATE_TIME	DATE
DURATION	NUMBER
OUTCOME_ID	NUMBER
OUTCOME_CODE	VARCHAR2	(80)
OUT_DESC	VARCHAR2	(240)
RESULT_ID	NUMBER
RESULT_CODE	VARCHAR2	(80)
RSL_DESC	VARCHAR2	(240)
REASON_ID	NUMBER
REASON_CODE	VARCHAR2	(80)
REA_DESC	VARCHAR2	(240)
FOLLOW_UP_ACTION	VARCHAR2	(80)
INTER_INTERACTION_DURATION	NUMBER
INTERACTION_INTERS_ID	NUMBER
METHOD_CODE	VARCHAR2	(30)
NON_PRODUCTIVE_TIME_AMOUNT	NUMBER
OBJECT_ID	NUMBER
OBJECT_TYPE	VARCHAR2	(30)
OBJECT_VERSION_NUMBER	NUMBER	(9)
PREVIEW_TIME_AMOUNT	NUMBER
PRODUCTIVE_TIME_AMOUNT	NUMBER
REFERENCE_FORM	VARCHAR2	(1000)
SCRIPT_ID	NUMBER
SOURCE_CODE	VARCHAR2	(100)
SOURCE_CODE_ID	NUMBER
WRAP_UP_TIME_AMOUNT	NUMBER
CONTACT_PARTY_ID	NUMBER			The Id of the contact Party
CONTACT_PARTY_NAME	VARCHAR2	(360)		The name of the contact Party
AGENT_NAME	VARCHAR2	(360)		The name of the agent who logged the interactions.
RESOURCE_ID	NUMBER		Yes	The Resource identifier.

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
,      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
,      CONTACT_PARTY_ID
,      CONTACT_PARTY_NAME
,      AGENT_NAME
,      RESOURCE_ID
FROM APPS.CS_SR_INTERACTIONS_V;

Dependencies

[top of page]

APPS.CS_SR_INTERACTIONS_V references the following:

APPS: HZ_PARTIES; JTF_IH_INTERACTIONS; JTF_IH_OUTCOMES_TL; JTF_IH_REASONS_TL; JTF_IH_RESULTS_TL; JTF_RS_RESOURCE_EXTNS_VL

APPS.CS_SR_INTERACTIONS_V is not referenced by any database object