[Home] [Help] [Dependency Information]

TABLE: AR.RA_CONTACT_PHONES_INT_ALL

Object Details

Object Name:	RA_CONTACT_PHONES_INT_ALL
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.RA_CONTACT_PHONES_INT_ALL
Subobject Name:
Status:	VALID

The RA_CONTACT_PHONES_INT_ALL table is one of the Customer Interface tables that Oracle Receivables uses to import contact and telephone information for your customers' addresses and business purposes. Receivables uses this customer information to create records in the RA_CONTACTS and RA_PHONES tables.
Enter one row for each contact or telephone number. All information is deleted from this table after your data conversion is successfully complete. For more information about customer conversion, see the Oracle Trading Community Architecture Reference Guide. The INSERT_UPDATE_FLAG column stores the these values:
{{"bul:1"}}I - To insert a new record
{{"bul:1"}}U - To update an existing record
{{"bodytext"}}The VALIDATED_FLAG column stores Y or N to indicate if this record has been validated.
Please refer to the Oracle Trading Community Architecture Reference Guide for more detailed information on Open Interface table columns, including import validation and destination columns.
Scope: public
Product: HZ
Lifecycle: active
Display Name: Contact Phone
Category: BUSINESS_ENTITY HZ_ACCOUNT_CONTACT
Category: BUSINESS_ENTITY HZ_CONTACT_POINT

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RA_CONTACT_PHONES_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_CUSTOMER_REF
RA_CONTACT_PHONES_INT_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_ADDRESS_REF
RA_CONTACT_PHONES_INT_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_TELEPHONE_REF
RA_CONTACT_PHONES_INT_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_SYSTEM_CONTACT_REF

Columns

Query Text

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;

Dependencies

[top of page]

AR.RA_CONTACT_PHONES_INT_ALL does not reference any database object

AR.RA_CONTACT_PHONES_INT_ALL is referenced by following:

APPS

RA_CONTACT_PHONES_INTERFACE

RA_CONTACT_PHONES_INT_ALL