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

VIEW: APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V

Object Details
Object Name: CS_SR_HZ_CONT_PTS_P_PHONES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_HZ_CONT_PTS_P_PHONES_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
PHONE VARCHAR2 (62)
The Concatenated phone number of the contact.
PHONE_COUNTRY_CODE VARCHAR2 (10)
The country code.
PHONE_AREA_CODE VARCHAR2 (10)
The area code
PHONE_NUMBER VARCHAR2 (40)
The phone number.
PHONE_EXTENSION VARCHAR2 (20)
CONT_POINT_TYPE_MEANING VARCHAR2 (80) Yes Contact point type meaning.
PHONE_LINE_TYPE_MEANING VARCHAR2 (80) Yes The phone line type.
OWNER_TABLE_ID NUMBER (15) Yes Owner table identifier.
CONTACT_POINT_ID NUMBER (15) Yes Contact Point identifier.
TIMEZONE_ID NUMBER

Timezone identifier.
CONTACT_POINT_TYPE VARCHAR2 (30) Yes The contact point type code.
PRIMARY_FLAG VARCHAR2 (1)
Flag for primary phone contact point.
STATUS VARCHAR2 (30) Yes Status of phone contact point.
TRANSPOSED_PHONE_NUMBER VARCHAR2 (60)
The phone number in the transposed format.
Query Text

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


SELECT PHONE
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      CONT_POINT_TYPE_MEANING
,      PHONE_LINE_TYPE_MEANING
,      OWNER_TABLE_ID
,      CONTACT_POINT_ID
,      TIMEZONE_ID
,      CONTACT_POINT_TYPE
,      PRIMARY_FLAG
,      STATUS
,      TRANSPOSED_PHONE_NUMBER
FROM APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V;

Dependencies

[top of page]

APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymHZ_CONTACT_POINTS
APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V is referenced by following:

SchemaAPPS
Package BodySR_UWQ_INTEG - show dependent code