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_CONTACT_POINTS_V

Object Details

Object Name:	CS_SR_CONTACT_POINTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_CONTACT_POINTS_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	Comments
PRIMARY_FLAG	VARCHAR2	(1)	Indicates whether the contact point is the primary contact point or not for the contact.
MEANING	VARCHAR2	(80)	This column stores the communication channel description.
CONTACT_TYPE	VARCHAR2	(30)	Indicates whether the contact is an employee or customer contact.
SUB_TITLE	VARCHAR2	(80)	Sub Title for the contact name.
SUB_FIRST_NAME	VARCHAR2	(150)	Contact First Name.
SUB_LAST_NAME	VARCHAR2	(150)	Contact LastName.
CONTACT	VARCHAR2	(382)	This column stores the concatenated contact name.
CONTACT_POINT_TYPE	VARCHAR2	(30)	Indicates the type of the contact point eg. phone, fax, email etc.
CONTACT_PHONE	VARCHAR2	(2000)	Concatenated phone number.
EXTENSION	VARCHAR2	(20)	Contact phone number extension.
ADDRESS	VARCHAR2	(963)	Address of the contact.
SR_CONTACT_POINT_ID	NUMBER		Foreign key to CS_HZ_SR_CONTACT_POINTS.
INCIDENT_ID	NUMBER		Unique Identifier of a Service Request
PARTY_ID	NUMBER		Contact identifier.
CONTACT_POINT_ID	NUMBER		Contact Point Identifier.
OBJECT_ID	NUMBER		The Object party identifier.
END_DATE_ACTIVE	DATE
JOB_TITLE_CODE	VARCHAR2	(80)
JOB_TITLE	VARCHAR2	(100)
DEPARTMENT_CODE	VARCHAR2	(80)
DEPARTMENT	VARCHAR2	(60)

Query Text

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


SELECT PRIMARY_FLAG
,      MEANING
,      CONTACT_TYPE
,      SUB_TITLE
,      SUB_FIRST_NAME
,      SUB_LAST_NAME
,      CONTACT
,      CONTACT_POINT_TYPE
,      CONTACT_PHONE
,      EXTENSION
,      ADDRESS
,      SR_CONTACT_POINT_ID
,      INCIDENT_ID
,      PARTY_ID
,      CONTACT_POINT_ID
,      OBJECT_ID
,      END_DATE_ACTIVE
,      JOB_TITLE_CODE
,      JOB_TITLE
,      DEPARTMENT_CODE
,      DEPARTMENT
FROM APPS.CS_SR_CONTACT_POINTS_V;

Dependencies

[top of page]

APPS.CS_SR_CONTACT_POINTS_V references the following:

APPS: AR_LOOKUPS; CS_HZ_SR_CONTACT_POINTS; HZ_CONTACT_POINTS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.CS_SR_CONTACT_POINTS_V is referenced by following:

APPS: AHL_UMP_NONROUTINES_PVT - show dependent code; CSF_TASKS_PUB - show dependent code