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_ORG_CONTACTS

Object Details

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

The HZ_ORG_CONTACTS table stores information about the position of the contact for a party or party site. The records in this table provide information about a contact position such as JOB_TITLE, RANK, and general contact information. This table is not used to store information about a specific person or organization, such as name and identification codes. That information is stored in the HZ_PARTIES table. For example, this table may include a record for the position of vice president of manufacturing that indicates that the contact is a senior executive, but it would not include the name of the person in that position.
.
The primary key for this table is ORG_CONTACT_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HZ_ORG_CONTACTS_PK

ORG_CONTACT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_ORG_CONTACTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_CONTACT_ID
HZ_ORG_CONTACTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_KEY
HZ_ORG_CONTACTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_NUMBER
HZ_ORG_CONTACTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_RELATIONSHIP_ID
HZ_ORG_CONTACTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MANAGED_BY
HZ_ORG_CONTACTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIG_SYSTEM_REFERENCE
HZ_ORG_CONTACTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_SITE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_CONTACT_ID	NUMBER	(15)	Yes	Identifier of the organization contact
PARTY_RELATIONSHIP_ID	NUMBER	(15)	Yes	Identifies relationship that contact person has with an organization or person. Foreign key to the HZ_RELATIONSHIPS table.
COMMENTS	VARCHAR2	(240)		User comments
CONTACT_NUMBER	VARCHAR2	(30)		User-defined identification number for this contact
DEPARTMENT_CODE	VARCHAR2	(30)		List of values for possible department codes
DEPARTMENT	VARCHAR2	(60)		Free form text used to name the department
TITLE	VARCHAR2	(30)		No Longer Used.
JOB_TITLE	VARCHAR2	(100)		Free form text for job title
MAIL_STOP	VARCHAR2	(60)		No longer used
CONTACT_KEY	VARCHAR2	(50)		No longer used
DECISION_MAKER_FLAG	VARCHAR2	(1)		Indicates if this contact is a decision maker. Y for a decision maker, N for someone who is not the decision maker.
JOB_TITLE_CODE	VARCHAR2	(30)		Code given to the job title
MANAGED_BY	NUMBER	(15)		No longer used
REFERENCE_USE_FLAG	VARCHAR2	(1)		Indicates if this contact can be used as a reference. Y for a contact who will act as a reference, N for a contact who cannot act as a reference.
RANK	VARCHAR2	(30)		Importance of the contact relative to other contacts
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			No longer used
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
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE24	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
PARTY_SITE_ID	NUMBER	(15)		Indicates if contact is for a particular party site. Foreign key to the HZ_PARTY_SITES table.
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes	Unique contact identifier from foreign system
NATIVE_LANGUAGE	VARCHAR2	(30)		No longer used
OTHER_LANGUAGE_1	VARCHAR2	(30)		No longer used
OTHER_LANGUAGE_2	VARCHAR2	(30)		No longer used
MAILING_ADDRESS_ID	NUMBER	(15)		No longer used
MATCH_GROUP_ID	NUMBER	(15)		No longer used
STATUS	VARCHAR2	(1)		No longer used
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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_CONTACT_ID
,      PARTY_RELATIONSHIP_ID
,      COMMENTS
,      CONTACT_NUMBER
,      DEPARTMENT_CODE
,      DEPARTMENT
,      TITLE
,      JOB_TITLE
,      MAIL_STOP
,      CONTACT_KEY
,      DECISION_MAKER_FLAG
,      JOB_TITLE_CODE
,      MANAGED_BY
,      REFERENCE_USE_FLAG
,      RANK
,      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
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      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
,      PARTY_SITE_ID
,      ORIG_SYSTEM_REFERENCE
,      NATIVE_LANGUAGE
,      OTHER_LANGUAGE_1
,      OTHER_LANGUAGE_2
,      MAILING_ADDRESS_ID
,      MATCH_GROUP_ID
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM AR.HZ_ORG_CONTACTS;

Dependencies

[top of page]

AR.HZ_ORG_CONTACTS does not reference any database object

AR.HZ_ORG_CONTACTS is referenced by following:

AR: HZ_ORG_CONTACTS#