[Home] [Help] [Dependency Information]
Object Name: | OKI_CONTACT_POINTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKI.OKI_CONTACT_POINTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows the contact points defined in TCA for contacts for contracts in OKI_SALES_K_HDRS. Contacts points might be email id, phone number, fax number, etc.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTACT_POINT_ID | NUMBER | (15) | Yes | The internal identifier for the contact point. |
CONTRACT_ID | NUMBER | Yes | The internal identifier of the contract for this contact and contact point. | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract number for this contract. | |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | Contract number modifier for this contract. | |
COMPLETE_CONTRACT_NUMBER | VARCHAR2 | (241) | Concatenated contract number and modifier. | |
CONTACT_POINT_TYPE | VARCHAR2 | (30) | Yes | The type of contact point, such as telephone or email. |
CONTACT_ID | NUMBER | (15) | Yes | The internal identifier for the contract contact. |
EMAIL_FORMAT | VARCHAR2 | (30) | The format in which the email address is stored. | |
EMAIL_ADDRESS | VARCHAR2 | (2000) | The contact's email address. | |
PHONE_TYPE | VARCHAR2 | (30) | The code indicating the type of the phone number. | |
PHONE_TYPE_MEANING | VARCHAR2 | (80) | Yes | The external description of the type of phone number. |
PHONE_COUNTRY_CODE | VARCHAR2 | (10) | The country code of the contact's phone. | |
PHONE_AREA_CODE | VARCHAR2 | (10) | The area code of the contact's phone. | |
PHONE_NUMBER | VARCHAR2 | (40) | The contact's phone number. | |
PHONE_EXTENSION | VARCHAR2 | (20) | The extension of the contact's phone. | |
PRIMARY_FLAG | VARCHAR2 | (1) | Indicates if this is the primary means for contacting the contact. | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. |
Cut, paste (and edit) the following text to query this object:
SELECT CONTACT_POINT_ID
, CONTRACT_ID
, CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER
, COMPLETE_CONTRACT_NUMBER
, CONTACT_POINT_TYPE
, CONTACT_ID
, EMAIL_FORMAT
, EMAIL_ADDRESS
, PHONE_TYPE
, PHONE_TYPE_MEANING
, PHONE_COUNTRY_CODE
, PHONE_AREA_CODE
, PHONE_NUMBER
, PHONE_EXTENSION
, PRIMARY_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
FROM APPS.OKI_CONTACT_POINTS_V;
APPS.OKI_CONTACT_POINTS_V is not referenced by any database object
|
|
|