[Home] [Help] [Dependency Information]
Object Name: | AMS_ORG_PHONE6_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_ORG_PHONE6_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 |
---|---|---|---|---|
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_NAME | VARCHAR2 | (30) | Yes | Table that stores the owner of the contact point |
OWNER_TABLE_ID | NUMBER | (15) | Yes | Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Yes | Source of data content |
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_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. | |
CONTACT_PREFERENCE_ID | NUMBER | (15) | Identifier for the contact preference | |
PREFERENCE_CODE | VARCHAR2 | (30) | Permission to use or not to use a particular contact method. Uses the PREFERENCE_CODE lookup. | |
PREFERENCE_TOPIC_TYPE | VARCHAR2 | (30) | Appropriate subjects to send or not to send to the party that the preference is created for. Uses the PREFERENCE_TOPIC_TYPE lookup. | |
PREFERENCE_TOPIC_TYPE_ID | NUMBER | (15) | Reduced LOV depending on the preference topic table selected. The PREFERENCE_TOPIC_TYPE_ID column and PREFERENCE_TOPIC_TYPE_CODE column are mutually exclusive. | |
PREFERENCE_TOPIC_TYPE_CODE | VARCHAR2 | (30) | Reduced LOV depending on the preference topic table selected. The PREFERENCE_TOPIC_TYPE_ID column and PREFERENCE_TOPIC_TYPE_CODE column are mutually exclusive. | |
PREFERENCE_START_DATE | DATE | STarting date of the period during which a party should or should not be contacted. | ||
PREFERENCE_START_TIME_HR | NUMBER | Starting hour of the time range during which a party should or should not be contacted. 0-23 hour format. | ||
PREFERENCE_START_TIME_MI | NUMBER | Starting minute of the time range during which a party should or should not be contacted. 0-59 minute format. | ||
PREFERENCE_END_DATE | DATE | Ending date of the period during which a party should or should not be contacted. | ||
PREFERENCE_END_TIME_HR | NUMBER | Ending hour of the time range during which a party should or should not be contacted. 0-23 hour format. | ||
PREFERENCE_END_TIME_MI | NUMBER | Ending minute of the time range during which a party should or should not be contacted. 0-59 minute format. | ||
MAX_NO_OF_INTERACTIONS | NUMBER | The number of times you can use this contact point. The period of time that this number applies is stored in the MAX_NO_OF_INTERACT_UOM_CODE column. | ||
MAX_NO_OF_INTERACT_UOM_CODE | VARCHAR2 | (30) | The period of time during which the maximum number of interactions applies. Uses the MAX_NO_OF_INTERACT_UOM_CODE lookup. | |
REASON_CODE | VARCHAR2 | (30) | Appropriate subjects to send or not to send to the party that the preference is created for. Uses the PREFERENCE_TOPIC_TYPE lookup. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_POINT_ID
, CONTACT_POINT_TYPE
, STATUS
, OWNER_TABLE_NAME
, OWNER_TABLE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CONTENT_SOURCE_TYPE
, PRIMARY_FLAG
, 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
, CONTACT_PREFERENCE_ID
, PREFERENCE_CODE
, PREFERENCE_TOPIC_TYPE
, PREFERENCE_TOPIC_TYPE_ID
, PREFERENCE_TOPIC_TYPE_CODE
, PREFERENCE_START_DATE
, PREFERENCE_START_TIME_HR
, PREFERENCE_START_TIME_MI
, PREFERENCE_END_DATE
, PREFERENCE_END_TIME_HR
, PREFERENCE_END_TIME_MI
, MAX_NO_OF_INTERACTIONS
, MAX_NO_OF_INTERACT_UOM_CODE
, REASON_CODE
FROM APPS.AMS_ORG_PHONE6_V;
APPS.AMS_ORG_PHONE6_V is not referenced by any database object
|
|
|