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.CSL_HZ_CONTACT_POINTS_V

Object Details

Object Name:	CSL_HZ_CONTACT_POINTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mobile view on HZ_CONTACT_POINTS

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACCESS_ID	NUMBER			Indentifier to CSL_HZ_CONTACT_POINTS_ACC
CONTACT_POINT_ID	NUMBER	(15)	Yes	Unique identifier of this contact point
CONTACT_POINT_TYPE	VARCHAR2	(30)	Yes	Lookup: CONTACT_POINT_TYPE of phone, fax, e-mail, web, telex, or EDI.
PRIMARY_FLAG	VARCHAR2	(1)		Indicates if this is the primary contact point of this contact point type for referenced party, site, or location. Y for primary contact, N for all others.
PHONE_COUNTRY_CODE	VARCHAR2	(10)		International country code for a telephone number. For example, 33 for France.
PHONE_AREA_CODE	VARCHAR2	(10)		The area code within a country code.
PHONE_NUMBER	VARCHAR2	(40)		A telephone number formatted in the local format. The number should not include area code, country code, or extension.
PHONE_EXTENSION	VARCHAR2	(20)		Additional number addressed after initial connection to an internal telephone system.
STATUS	VARCHAR2	(30)	Yes	Lookup: contact_point_status. Typically, active, inactive, delete.
PHONE_LINE_TYPE	VARCHAR2	(30)		Lookup code for the type of phone line. For example, general, fax, inbound, or outbound.
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address of the contact point
OWNER_TABLE_ID	NUMBER	(15)	Yes	Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point
OWNER_TABLE_NAME	VARCHAR2	(30)	Yes	Table that stores the owner of the contact point

Query Text

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


SELECT ACCESS_ID
,      CONTACT_POINT_ID
,      CONTACT_POINT_TYPE
,      PRIMARY_FLAG
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      STATUS
,      PHONE_LINE_TYPE
,      EMAIL_ADDRESS
,      OWNER_TABLE_ID
,      OWNER_TABLE_NAME
FROM APPS.CSL_HZ_CONTACT_POINTS_V;

Dependencies

[top of page]

APPS.CSL_HZ_CONTACT_POINTS_V references the following:

APPS: ASG_BASE - show dependent code; CSL_HZ_CONTACT_POINTS_ACC; HZ_CONTACT_POINTS

APPS.CSL_HZ_CONTACT_POINTS_V is not referenced by any database object