[Home] [Help] [Dependency Information]
Object Name: | RA_CONTACT_PHONES_INT_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORIG_SYSTEM_CONTACT_REF | VARCHAR2 | (240) | ||
ORIG_SYSTEM_TELEPHONE_REF | VARCHAR2 | (240) | ||
ORIG_SYSTEM_CUSTOMER_REF | VARCHAR2 | (240) | Yes | |
ORIG_SYSTEM_ADDRESS_REF | VARCHAR2 | (240) | ||
INSERT_UPDATE_FLAG | VARCHAR2 | (1) | Yes | |
CONTACT_FIRST_NAME | VARCHAR2 | (40) | ||
CONTACT_LAST_NAME | VARCHAR2 | (50) | ||
CONTACT_TITLE | VARCHAR2 | (30) | ||
CONTACT_JOB_TITLE | VARCHAR2 | (100) | ||
TELEPHONE | VARCHAR2 | (25) | ||
TELEPHONE_EXTENSION | VARCHAR2 | (20) | ||
TELEPHONE_TYPE | VARCHAR2 | (30) | ||
INTERFACE_STATUS | VARCHAR2 | (240) | ||
REQUEST_ID | NUMBER | (15) | ||
TELEPHONE_AREA_CODE | VARCHAR2 | (10) | ||
VALIDATED_FLAG | VARCHAR2 | (1) | ||
CONTACT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
PHONE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
CONTACT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
PHONE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CONTACT_ATTRIBUTE16 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE17 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE18 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE19 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE20 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE21 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE22 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE23 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE24 | VARCHAR2 | (150) | ||
CONTACT_ATTRIBUTE25 | VARCHAR2 | (150) | ||
SEX_CODE | VARCHAR2 | (30) | ||
SALUTATION | VARCHAR2 | (60) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
MAIL_STOP | VARCHAR2 | (60) | ||
CONTACT_KEY | VARCHAR2 | (50) | ||
ORG_ID | NUMBER | (15) | ||
PHONE_COUNTRY_CODE | VARCHAR2 | (10) | ||
CONTACT_JOB_TITLE_CODE | VARCHAR2 | (30) | ||
CONTACT_POINT_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ORIG_SYSTEM_CONTACT_REF
, ORIG_SYSTEM_TELEPHONE_REF
, ORIG_SYSTEM_CUSTOMER_REF
, ORIG_SYSTEM_ADDRESS_REF
, INSERT_UPDATE_FLAG
, CONTACT_FIRST_NAME
, CONTACT_LAST_NAME
, CONTACT_TITLE
, CONTACT_JOB_TITLE
, TELEPHONE
, TELEPHONE_EXTENSION
, TELEPHONE_TYPE
, INTERFACE_STATUS
, REQUEST_ID
, TELEPHONE_AREA_CODE
, VALIDATED_FLAG
, CONTACT_ATTRIBUTE1
, CONTACT_ATTRIBUTE10
, CONTACT_ATTRIBUTE2
, CONTACT_ATTRIBUTE3
, CONTACT_ATTRIBUTE4
, CONTACT_ATTRIBUTE5
, CONTACT_ATTRIBUTE6
, CONTACT_ATTRIBUTE7
, CONTACT_ATTRIBUTE8
, CONTACT_ATTRIBUTE9
, CONTACT_ATTRIBUTE_CATEGORY
, PHONE_ATTRIBUTE1
, PHONE_ATTRIBUTE10
, PHONE_ATTRIBUTE2
, PHONE_ATTRIBUTE3
, PHONE_ATTRIBUTE4
, PHONE_ATTRIBUTE5
, PHONE_ATTRIBUTE6
, PHONE_ATTRIBUTE7
, PHONE_ATTRIBUTE8
, PHONE_ATTRIBUTE9
, PHONE_ATTRIBUTE_CATEGORY
, CONTACT_ATTRIBUTE11
, CONTACT_ATTRIBUTE12
, CONTACT_ATTRIBUTE13
, CONTACT_ATTRIBUTE14
, CONTACT_ATTRIBUTE15
, PHONE_ATTRIBUTE11
, PHONE_ATTRIBUTE12
, PHONE_ATTRIBUTE13
, PHONE_ATTRIBUTE14
, PHONE_ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CONTACT_ATTRIBUTE16
, CONTACT_ATTRIBUTE17
, CONTACT_ATTRIBUTE18
, CONTACT_ATTRIBUTE19
, CONTACT_ATTRIBUTE20
, CONTACT_ATTRIBUTE21
, CONTACT_ATTRIBUTE22
, CONTACT_ATTRIBUTE23
, CONTACT_ATTRIBUTE24
, CONTACT_ATTRIBUTE25
, SEX_CODE
, SALUTATION
, EMAIL_ADDRESS
, MAIL_STOP
, CONTACT_KEY
, ORG_ID
, PHONE_COUNTRY_CODE
, CONTACT_JOB_TITLE_CODE
, CONTACT_POINT_TYPE
FROM AR.RA_CONTACT_PHONES_INT_ALL#;
|
|
|