[Home] [Help] [Dependency Information]
Object Name: | AMS_LT_HZ_PHONE_1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_LT_HZ_PHONE_1 |
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 |
---|---|---|---|---|
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. |
STATUS | VARCHAR2 | (30) | Yes | Lookup: contact_point_status. Typically, active, inactive, delete. |
OWNER_TABLE_ID | NUMBER | (15) | Yes | Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point |
CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Source of data content |
PHONE_TOUCH_TONE_TYPE_FLAG | VARCHAR2 | (1) | Indicates if this telephone number generates touch tones. Y for phone numbers that generate touch tones, N for phone numbers that do not generate touch tones. Default is Y. | |
PHONE_LINE_TYPE | VARCHAR2 | (30) | Lookup code for the type of phone line. For example, general, fax, inbound, or outbound. | |
TIME_ZONE | NUMBER | Time zone expressed as the deviation or difference in hours from Greenwich Mean Time(GMT). | ||
RAW_PHONE_NUMBER | VARCHAR2 | (60) | Unformatted telephone number | |
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. | |
TELEX_NUMBER | VARCHAR2 | (50) | Reference number (usually a telephone number) that TELEX messages are sent to. | |
TIMEZONE_ID | NUMBER | Time zone identifier. Foreign key to HZ_TIMEZONES | ||
CONTACT_POINT_PURPOSE | VARCHAR2 | (30) | Contact point type, such as business or personal. Uses the CONTACT_POINT_PURPOSE lookup. | |
PRIMARY_BY_PURPOSE | VARCHAR2 | (30) | Y indicates that this is the primary contact point of the contact point purpose for the party or site. A party or site can have only one contact point with a value of Y. | |
TRANSPOSED_PHONE_NUMBER | VARCHAR2 | (60) | This column stores the concatenation of PHONE_COUNTRY_CODE, PHONE_AREA_CODE, and PHONE_NUMBER in reverse. e.g. If PHONE_COUNTRY_CODE=1, PHONE_AREA_CODE=650 and PHONE_NUMBER=5065747, this column stores 74756050561. This column is used in building an index to search on any combination of the above three columns. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, STATUS
, OWNER_TABLE_ID
, CONTENT_SOURCE_TYPE
, PHONE_TOUCH_TONE_TYPE_FLAG
, PHONE_LINE_TYPE
, TIME_ZONE
, RAW_PHONE_NUMBER
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, TELEX_NUMBER
, TIMEZONE_ID
, CONTACT_POINT_PURPOSE
, PRIMARY_BY_PURPOSE
, TRANSPOSED_PHONE_NUMBER
FROM APPS.AMS_LT_HZ_PHONE_1;
APPS.AMS_LT_HZ_PHONE_1 is not referenced by any database object
|
|
|