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]

VIEW: APPS.HZ_ORG_CONTACTS_CPUI_V

Object Details

Object Name:	HZ_ORG_CONTACTS_CPUI_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AR.HZ_ORG_CONTACTS_CPUI_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_CONTACT_ID	NUMBER	(15)	Yes	Identifier of the organization contact
PARTY_RELATIONSHIP_ID	NUMBER	(15)	Yes	Party relationship identifier. Foreign key to the HZ_PARTY_RELATIONSHIPS table
SUBJECT_TYPE	VARCHAR2	(30)	Yes	Subject type of the relationship
SUBJECT_TABLE_NAME	VARCHAR2	(30)	Yes	Source table name for the subject
SUBJECT_ID	NUMBER	(15)	Yes	The identifier of the subject in this relationship
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object type of the relationship
OBJECT_TABLE_NAME	VARCHAR2	(30)	Yes	Source table name for the object
OBJECT_ID	NUMBER	(15)	Yes	The identifier of the object in this relationship
RELATIONSHIP_PARTY_ID	NUMBER	(15)		Identifier for the party. Foreign key to the HZ_PARTIES table.
RELATIONSHIP_CODE	VARCHAR2	(30)	Yes	Either a forward or a backward relationship code
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The relationship type name. For example, CUSTOMER_SUPPLIER
DIRECTIONAL_FLAG	VARCHAR2	(1)	Yes	Indicates if this is a directional relationship, such as parent-to-child or headquarters-to-branch. F for a forward relationship and B for a backward relationship.
STATUS	VARCHAR2	(1)	Yes	Indicates if this is an active or inactive relationship. A for active, I for inactive.
START_DATE	DATE		Yes	Date relationship begins
END_DATE	DATE			Date relationship ends
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
JOB_TITLE	VARCHAR2	(100)		Free form text for job title
CONTACT_KEY	VARCHAR2	(50)		Populated by Oracle CRM fuzzy match API
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
PARTY_SITE_ID	NUMBER	(15)		Unique party indentifier. Foreign key to the HZ_PARTIES 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
CONTACT_OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
REL_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
,      SUBJECT_TYPE
,      SUBJECT_TABLE_NAME
,      SUBJECT_ID
,      OBJECT_TYPE
,      OBJECT_TABLE_NAME
,      OBJECT_ID
,      RELATIONSHIP_PARTY_ID
,      RELATIONSHIP_CODE
,      RELATIONSHIP_TYPE
,      DIRECTIONAL_FLAG
,      STATUS
,      START_DATE
,      END_DATE
,      COMMENTS
,      CONTACT_NUMBER
,      DEPARTMENT_CODE
,      DEPARTMENT
,      JOB_TITLE
,      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
,      PARTY_SITE_ID
,      ORIG_SYSTEM_REFERENCE
,      NATIVE_LANGUAGE
,      OTHER_LANGUAGE_1
,      OTHER_LANGUAGE_2
,      MAILING_ADDRESS_ID
,      MATCH_GROUP_ID
,      CONTACT_OBJECT_VERSION_NUMBER
,      REL_OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM APPS.HZ_ORG_CONTACTS_CPUI_V;

Dependencies

[top of page]

APPS.HZ_ORG_CONTACTS_CPUI_V references the following:

APPS: HZ_ORG_CONTACTS; HZ_RELATIONSHIPS

APPS.HZ_ORG_CONTACTS_CPUI_V is not referenced by any database object