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

VIEW: APPS.CSC_CC_CONTACT_POINTS_V

Object Details
Object Name: CSC_CC_CONTACT_POINTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Standard row id column
CONTACT_POINT_ID NUMBER (15) Yes Unique identifier of this contact point
PARTY_ID NUMBER (15) Yes Party Identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
CONTACT_POINT_PURPOSE VARCHAR2 (30)
Contact Point Purpose
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
PHONE_NUMBER VARCHAR2 (40)
A telephone number formatted in the local format. The number should not include area code, country code, or extension.
STATUS VARCHAR2 (30) Yes Lookup: contact_point_status. Typically, active, inactive,
TELEPHONE_TYPE VARCHAR2 (30)
Indicates whether this is a fixed or mobile phone.
CONTACT_POINT_TYPE VARCHAR2 (30) Yes Lookup: contact_point_type phone, fax, e-mail, web, telex, edi
CONTACT_POINT_TYPE_MEANING VARCHAR2 (80)
Contact Type Meaning from Ar_Lookups
PHONE_LINE_TYPE VARCHAR2 (30)
Lookup code for the type of phone line. For example, general, fax, inbound, outbound.
PHONE_LINE_TYPE_MEANING VARCHAR2 (80)
Phone Type Meaning from Ar_Lookups
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
COUNTRY_CODE VARCHAR2 (10)
Country code for international phone numbers.
AREA_CODE VARCHAR2 (10)
The area code within a country code.
EXTENSION VARCHAR2 (20)
The additional number handled by an internal telephone system that is addressed after contacting the individual's internal telephone system.
PRIMARY_FLAG VARCHAR2 (1)
Y indicates this is the primary contact point of this contact point type for referenced party, site, or location
EMAIL_FORMAT VARCHAR2 (30)
Indicates the preferred format for email addressed to this address. For example, 'html' or 'ascii'.
EMAIL_ADDRESS VARCHAR2 (2000)
Email address
TIME_ZONE NUMBER

Time zone (the number of hours from Greenwhich mean).
EDI_ID_NUMBER VARCHAR2 (30)
EDI trading partner number for the supplier site
URL VARCHAR2 (2000)
Uniform resource locator.
WEB_TYPE VARCHAR2 (60)
The prefix class to a web address. Typically this is 'ftp' or 'http'.
TIMEZONE_ID NUMBER

Timezone_Id
GLOBAL_TIMEZONE_NAME VARCHAR2 (80)
Timezone Name
VALUE1 VARCHAR2 (10)
Country Code displayed in Contact Center
VALUE2 VARCHAR2 (10)
Area Code displayed in Contact Points tab of Contact Center
VALUE3 VARCHAR2 (2000)
Contact Point Value displayed in Contact Points tab of Contact Center
OWNER_TABLE_NAME VARCHAR2 (30) Yes Owner Table Name
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
Query Text

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


SELECT ROW_ID
,      CONTACT_POINT_ID
,      PARTY_ID
,      LAST_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      CONTACT_POINT_PURPOSE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PHONE_NUMBER
,      STATUS
,      TELEPHONE_TYPE
,      CONTACT_POINT_TYPE
,      CONTACT_POINT_TYPE_MEANING
,      PHONE_LINE_TYPE
,      PHONE_LINE_TYPE_MEANING
,      LAST_UPDATE_LOGIN
,      COUNTRY_CODE
,      AREA_CODE
,      EXTENSION
,      PRIMARY_FLAG
,      EMAIL_FORMAT
,      EMAIL_ADDRESS
,      TIME_ZONE
,      EDI_ID_NUMBER
,      URL
,      WEB_TYPE
,      TIMEZONE_ID
,      GLOBAL_TIMEZONE_NAME
,      VALUE1
,      VALUE2
,      VALUE3
,      OWNER_TABLE_NAME
,      ATTRIBUTE1
FROM APPS.CSC_CC_CONTACT_POINTS_V;

Dependencies

[top of page]

APPS.CSC_CC_CONTACT_POINTS_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
ViewFND_TIMEZONES_VL
SynonymHZ_CONTACT_POINTS

APPS.CSC_CC_CONTACT_POINTS_V is not referenced by any database object