[Home] [Help] [Dependency Information]
Object Name: | CS_SR_HZ_CONT_PTS_P_PHONES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CS.CS_SR_HZ_CONT_PTS_P_PHONES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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. |
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;
|
|
|