eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.HZ_CONTACT_POINTS

Object Details

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

The HZ_CONTACT_POINTS table stores information about how to communicate to parties or party sites using electronic media or methods such as Electronic Data Interchange (EDI), e-mail, telephone, telex, and the Internet. For example, telephone-related data can include the type of
telephone line, a touch tone indicator, a country code, the area code, the telephone number, and an extension number to a specific handset. NOTE: Each media or method should be stored as a separate record in this table. For example, the attributes of a complete telephone connection should be stored in a record, while EDI information should be stored in a different record.
.
The primary key for this table is CONTACT_POINT_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CONTACT_POINTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CONTACT_POINT_ID
HZ_CONTACT_POINTS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EDI_ECE_TP_LOCATION_CODE
HZ_CONTACT_POINTS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFT_SWIFT_CODE
HZ_CONTACT_POINTS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIMEZONE_ID
HZ_CONTACT_POINTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHONE_NUMBER
HZ_CONTACT_POINTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PHONE_AREA_CODE PHONE_NUMBER PHONE_EXTENSION
HZ_CONTACT_POINTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYSTEM_REFERENCE
HZ_CONTACT_POINTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_TABLE_ID OWNER_TABLE_NAME CONTACT_POINT_TYPE PRIMARY_FLAG
HZ_CONTACT_POINTS_N7	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	UPPER("EMAIL_ADDRESS")
HZ_CONTACT_POINTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSPOSED_PHONE_NUMBER
HZ_CONTACT_POINTS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EDI_ID_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CONTACT_POINT_ID	NUMBER	(15)	Yes	Unique identifier of this contact point
CONTACT_POINT_TYPE	VARCHAR2	(30)	Yes	Contact point type, such as phone or e-mail. Valid value from COMMUNICATION_TYPE lookup type.
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
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.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)		Identifier for this record from foreign or legacy system.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
WH_UPDATE_DATE	DATE			Date when the record was entered or changed in a data warehouse
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Not currently used
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Not currently used
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Not currently used
EDI_TRANSACTION_HANDLING	VARCHAR2	(25)		ANSI standard code for EDI transaction type
EDI_ID_NUMBER	VARCHAR2	(30)		EDI trading partner number for the supplier site
EDI_PAYMENT_METHOD	VARCHAR2	(30)		Indicates how a payment is to be made through EDI. Valid methods are ACH and BOP.
EDI_PAYMENT_FORMAT	VARCHAR2	(30)		Indicates type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CHZ, CTX, PPD, and PPP.
EDI_REMITTANCE_METHOD	VARCHAR2	(30)		Indicates how remittance advice are sent to the supplier.
EDI_REMITTANCE_INSTRUCTION	VARCHAR2	(30)		Indicates who will send the remittance advice. Valid values are Banks or Payables systems.
EDI_TP_HEADER_ID	NUMBER	(15)		EDI transaction header unique identifier
EDI_ECE_TP_LOCATION_CODE	VARCHAR2	(40)		Trading partner location code for EDI Gateway
EMAIL_FORMAT	VARCHAR2	(30)		Indicates the preferred format for e-mail addressed to this address. For example, HTML or ASCII.
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address of the contact point
BEST_TIME_TO_CONTACT_START	DATE			No Longer Used
BEST_TIME_TO_CONTACT_END	DATE			No Longer Used
PHONE_CALLING_CALENDAR	VARCHAR2	(30)		The name or code for a calling calendar used with this telephone number.
CONTACT_ATTEMPTS	NUMBER			No Longer Used
CONTACTS	NUMBER			No Longer Used
DECLARED_BUSINESS_PHONE_FLAG	VARCHAR2	(1)		No Longer Used
DO_NOT_USE_FLAG	VARCHAR2	(1)		No Longer Used
DO_NOT_USE_REASON	VARCHAR2	(60)		No Longer Used
LAST_CONTACT_DT_TIME	DATE			Date and time of last contact placed to this contact point.
PHONE_PREFERRED_ORDER	NUMBER			No Longer Used.
PRIORITY_OF_USE_CODE	VARCHAR2	(30)		No Longer Used.
TELEPHONE_TYPE	VARCHAR2	(30)		No Longer Used.
TIME_ZONE	NUMBER			Time zone expressed as the deviation or difference in hours from Greenwich Mean Time(GMT).
PHONE_TOUCH_TONE_TYPE_FLAG	VARCHAR2	(1)		No Longer Used
PHONE_AREA_CODE	VARCHAR2	(10)		The area code within a country code.
PHONE_COUNTRY_CODE	VARCHAR2	(10)		International country code for a telephone number. For example, 33 for France.
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.
PHONE_LINE_TYPE	VARCHAR2	(30)		Lookup code for the type of phone line. For example, general, fax, inbound, or outbound.
TELEX_NUMBER	VARCHAR2	(50)		Reference number (usually a telephone number) that TELEX messages are sent to.
WEB_TYPE	VARCHAR2	(60)		The prefix class to a web address. Typically this is either FTP or HTTP.
URL	VARCHAR2	(2000)		Uniform resource locator
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes	Source of data content
RAW_PHONE_NUMBER	VARCHAR2	(60)		Unformatted telephone number
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column
APPLICATION_ID	NUMBER			TCA Who column
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.
EFT_TRANSMISSION_PROGRAM_ID	NUMBER	(15)		Transmission program identifier
EFT_PRINTING_PROGRAM_ID	NUMBER	(15)		Printing program identifier
EFT_USER_NUMBER	VARCHAR2	(30)		The number that identifier you as a user of electronic funds transfer service to your bank or clearing organization.
EFT_SWIFT_CODE	VARCHAR2	(30)		EFT Swift Code
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)	Yes	Additional Content Source Type column for backward compatibility.

Query Text

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
,      PRIMARY_FLAG
,      ORIG_SYSTEM_REFERENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WH_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      EDI_TRANSACTION_HANDLING
,      EDI_ID_NUMBER
,      EDI_PAYMENT_METHOD
,      EDI_PAYMENT_FORMAT
,      EDI_REMITTANCE_METHOD
,      EDI_REMITTANCE_INSTRUCTION
,      EDI_TP_HEADER_ID
,      EDI_ECE_TP_LOCATION_CODE
,      EMAIL_FORMAT
,      EMAIL_ADDRESS
,      BEST_TIME_TO_CONTACT_START
,      BEST_TIME_TO_CONTACT_END
,      PHONE_CALLING_CALENDAR
,      CONTACT_ATTEMPTS
,      CONTACTS
,      DECLARED_BUSINESS_PHONE_FLAG
,      DO_NOT_USE_FLAG
,      DO_NOT_USE_REASON
,      LAST_CONTACT_DT_TIME
,      PHONE_PREFERRED_ORDER
,      PRIORITY_OF_USE_CODE
,      TELEPHONE_TYPE
,      TIME_ZONE
,      PHONE_TOUCH_TONE_TYPE_FLAG
,      PHONE_AREA_CODE
,      PHONE_COUNTRY_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      PHONE_LINE_TYPE
,      TELEX_NUMBER
,      WEB_TYPE
,      URL
,      CONTENT_SOURCE_TYPE
,      RAW_PHONE_NUMBER
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      TIMEZONE_ID
,      CONTACT_POINT_PURPOSE
,      PRIMARY_BY_PURPOSE
,      TRANSPOSED_PHONE_NUMBER
,      EFT_TRANSMISSION_PROGRAM_ID
,      EFT_PRINTING_PROGRAM_ID
,      EFT_USER_NUMBER
,      EFT_SWIFT_CODE
,      ACTUAL_CONTENT_SOURCE
FROM AR.HZ_CONTACT_POINTS;

Dependencies

[top of page]

AR.HZ_CONTACT_POINTS does not reference any database object

AR.HZ_CONTACT_POINTS is referenced by following:

APPS: HZ_CONTACT_POINTS; LNS_LOAN_DTLS_ALL_MV