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.JTF_PARTY_ALL_CONTACTS_V

Object Details

Object Name:	JTF_PARTY_ALL_CONTACTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JTF.JTF_PARTY_ALL_CONTACTS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View all contacts, using hz_relationship table as the driving table. The view expose data for subject and object party. Please note that the view does not join with hz_org_contacts.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_PARTY_ID	NUMBER	(15)	Yes	Object party identifier
OBJECT_PARTY_NAME	VARCHAR2	(360)	Yes	Object party name
OBJECT_PARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this object party
SUBJECT_PARTY_ID	NUMBER	(15)	Yes	Subject party identifier
SUBJECT_PARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this subject party
SUBJECT_PARTY_NAME	VARCHAR2	(360)	Yes	Subject party name
VALIDATED_FLAG	VARCHAR2	(1)		Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Salutary introduction, such as Mr. or Herr
PERSON_FIRST_NAME	VARCHAR2	(150)		First name of the person
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Middle name of the person
PERSON_LAST_NAME	VARCHAR2	(150)		Last or surname of the person
PERSON_NAME_SUFFIX	VARCHAR2	(30)		Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
PERSON_TITLE	VARCHAR2	(60)		A professional or family title. For example, Don or The Right Honorable.
PERSON_ACADEMIC_TITLE	VARCHAR2	(30)		Academic title that is part of a person's name, such as Dr. John Smith.
PERSON_PREVIOUS_LAST_NAME	VARCHAR2	(150)		Previous last or surname of the person
KNOWN_AS	VARCHAR2	(240)		An alias or other name by which a party is known
PERSON_IDEN_TYPE	VARCHAR2	(30)		Personal identifier type, such as driver's license or passport. Lookup type for PERSON_IDENTIFIER column
PERSON_IDENTIFIER	VARCHAR2	(60)		Personal identifier, such as driver's license or passport number, or country-specific identifier for person located or doing business in multiple countries
JGZZ_FISCAL_CODE	VARCHAR2	(20)		Taxpayer identification number, often unique identifier of person or organization. Can be SSN or income taxpayer ID in US, fiscal code or NIF in Europe
TAX_NAME	VARCHAR2	(60)		No longer used
TAX_REFERENCE	VARCHAR2	(50)		Taxpayer registration number, also known as the VAT number.
START_DATE	DATE		Yes	Date relationship begins
END_DATE	DATE			Date relationship ends
SUBJECT_ID	NUMBER	(15)	Yes	The identifier of the subject in this relationship
PARTY_RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The relationship type name. For example, CUSTOMER_SUPPLIER
PARTY_RELATIONSHIP_ID	NUMBER	(15)	Yes	The unique identifier of this relationship
PARTY_ID	NUMBER	(15)		Internal identifier of party with PARTY_RELATIONSHIP party type
SUBJECT_EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address

Query Text

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


SELECT OBJECT_PARTY_ID
,      OBJECT_PARTY_NAME
,      OBJECT_PARTY_NUMBER
,      SUBJECT_PARTY_ID
,      SUBJECT_PARTY_NUMBER
,      SUBJECT_PARTY_NAME
,      VALIDATED_FLAG
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_LAST_NAME
,      KNOWN_AS
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      JGZZ_FISCAL_CODE
,      TAX_NAME
,      TAX_REFERENCE
,      START_DATE
,      END_DATE
,      SUBJECT_ID
,      PARTY_RELATIONSHIP_TYPE
,      PARTY_RELATIONSHIP_ID
,      PARTY_ID
,      SUBJECT_EMAIL_ADDRESS
FROM APPS.JTF_PARTY_ALL_CONTACTS_V;

Dependencies

[top of page]

APPS.JTF_PARTY_ALL_CONTACTS_V references the following:

APPS: HZ_CODE_ASSIGNMENTS; HZ_PARTIES; HZ_RELATIONSHIPS; HZ_RELATIONSHIP_TYPES

APPS.JTF_PARTY_ALL_CONTACTS_V is referenced by following:

APPS: CSF_TASKS_PUB - show dependent code; JTF_EC_UTIL - show dependent code; JTF_EC_WORKFLOW_PKG - show dependent code; JTF_TASK_UTL - show dependent code