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_PARTIES_V

Object Details

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

View Type

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

JTF_PARTIES_V stores information about parties such as organizations, people, and groups, including the identifying address information for the party.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Row Identifier
PARTY_ID	NUMBER	(15)	This column uniquely identifies a party. FK to HZ_PARTIES
PARTY_RELATIONSHIP_ID	NUMBER		Uniquely identifies a specific relationship between two parties
PARTY_NUMBER	VARCHAR2	(30)	Party Number
PARTY_TYPE	VARCHAR2	(30)	Type of party - Organization or Person or Group or Party relationship.
PARTY_NAME	VARCHAR2	(360)	Name of the party
SUBJECT_ID	NUMBER		Unique identifier of the caller. FK to HZ_PARTIES
SUBJECT_NUMBER	VARCHAR2	(30)	Party number of the caller
OBJECT_ID	NUMBER	(15)	Unique identifier of the Organization or Person or Group. FK to HZ_PARTIES
OBJECT_NUMBER	VARCHAR2	(30)	Party number of the Organization or Person or Group
OBJECT_NAME	VARCHAR2	(360)	Name ot he Organization or Person or Group
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated 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).
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJ_PARTY_TYPE	VARCHAR2	(30)	Party type, either Organization or Person or Group
OBJ_COMPANY_NAME	VARCHAR2	(360)	Name of the organization
OBJ_GROUP_NAME	VARCHAR2	(360)	Name of the group
OBJ_GROUP_TYPE	VARCHAR2	(30)	Group type
OBJ_FIRST_NAME	VARCHAR2	(150)	First name of the person
OBJ_MIDDLE_NAME	VARCHAR2	(60)	Middle name of the person
OBJ_LAST_NAME	VARCHAR2	(150)	Last name of the person
OBJ_NAME_SUFFIX	VARCHAR2	(30)	Indicates the place in a family structure. For example, in "Tom Jones III", the "III" for third is the suffix.
OBJ_TITLE	VARCHAR2	(30)	A professional or family title. For example, 'Don', or 'The Right Honorable'.
OBJ_ALIAS	VARCHAR2	(240)	An alias or other name by which a party is known
OBJ_SIC_CODE	VARCHAR2	(30)	Standard Industry Classification Code
OBJ_LONG_NAME	VARCHAR2	(360)	Long Name of the party
OBJ_ANALYSIS_FY	VARCHAR2	(5)	Fiscal Year upon which financial information is based on (net worth, number of employees, potential revenue)
OBJ_FISCAL_YEAREND_MONTH	VARCHAR2	(30)	Month in which fiscal year ends for organization
OBJ_NUM_OF_EMPLOYEES	NUMBER		Total number of employees
OBJ_POT_REVENUE_CURR_FY	NUMBER		Potential revenue this fiscal year for organization
OBJ_POT_REVENUE_NEXT_FY	NUMBER		Potential revenue next fiscal year for organization
OBJ_TAX_REFERENCE	VARCHAR2	(50)	Tax identification number
OBJ_YEAR_ESTABLISHED	NUMBER	(4)	Year on which organization began its business
OBJ_INTERNAL_FLAG	VARCHAR2	(1)	External or Internal organization
OBJ_PUB_PRIVATE_OWNER_FLAG	VARCHAR2	(1)	Public or Private organization
OBJ_DUNS_NUMBER	NUMBER		DUNS Number: a unique, nine digit identification number assigned to business entities by Dun and Bradstreet
OBJ_JGZZ_FISCAL_CODE	VARCHAR2	(20)	This column is used as the "Fiscal Code" for certain European Countries
SUB_PARTY_TYPE	VARCHAR2	(30)	Party type - Organization or Person or Group
SUB_PARTY_NAME	VARCHAR2	(360)	Name of the caller
SUB_FIRST_NAME	VARCHAR2	(150)	First name of the person
SUB_MIDDLE_NAME	VARCHAR2	(60)	Middle name of the person
SUB_LAST_NAME	VARCHAR2	(150)	Last name of the person
SUB_NAME_SUFFIX	VARCHAR2	(30)	Indicates the place in a family structure. For example, in "Tom Jones III", the "III" for third is the suffix.
SUB_TITLE	VARCHAR2	(30)	A professional or family title. For example, 'Don', or 'The Right Honorable'.
SUB_NICKNAME	VARCHAR2	(240)	An alias or other name by which a party is known
SUB_PERSON_NAME_PHONETIC	VARCHAR2	(320)	Phonetic representation of the persons name
SUB_ORG_CONTACT_ID	NUMBER		Identifier of the organization contact. FK to HZ_ORG_CONTACTS
SUB_JOB_TITLE	VARCHAR2	(100)	Job title (free form text)
SUB_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.
SUB_JOB_TITLE_CODE	VARCHAR2	(30)	Lookup : RESPONSIBILITY
SUB_MANAGED_BY	NUMBER		FK to HZ_PARTIES
SUB_NATIVE_LANGUAGE	VARCHAR2	(30)	Language of the contact
SUB_REFERENCE_USE_FLAG	VARCHAR2	(1)	Y if this contact can be used as a reference, N otherwise
SUB_OTHER_LANGUAGE_1	VARCHAR2	(30)	Mailing Language
SUB_OTHER_LANGUAGE_2	VARCHAR2	(30)	Mailing Language
SUB_RANK	VARCHAR2	(30)	Importance of the contact relative to other contacts
SUB_SALUTATION	VARCHAR2	(30)	Salutary introduction such as Mr., Herr, etc.
SUB_DEPARTMENT_CODE	VARCHAR2	(30)	Used by OSM
SUB_DEPARTMENT	VARCHAR2	(60)	Used by OSM
SUB_DATE_OF_BIRTH	DATE		Person's date of birth
SUB_PERSONAL_INCOME	NUMBER		Income of the person
RELATION	VARCHAR2	(30)	Relationship between the parties
ADDRESS	VARCHAR2	(963)	Concatenated address of the party
CITY	VARCHAR2	(60)	City
STATE	VARCHAR2	(60)	State
PROVINCE	VARCHAR2	(60)	Province
POSTAL_CODE	VARCHAR2	(60)	Postal Code
COUNTRY	VARCHAR2	(60)	Country
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)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)	Reserved for Globalization Functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)	Reserved for Globalization Functionality
SUB_LAST_UPDATE_DATE	DATE		Standard Who column
OBJ_LAST_UPDATE_DATE	DATE		Standard Who column
REL_LAST_UPDATE_DATE	DATE		Standard Who column
ORGPR_LAST_UPDATE_DATE	DATE		Standard Who column
ORGCT_LAST_UPDATE_DATE	DATE		Standard Who column
PERSU_LAST_UPDATE_DATE	DATE		Standard Who column
PEROB_LAST_UPDATE_DATE	DATE		Standard Who column
PARTY_LAST_UPDATE_DATE	DATE		Standard Who column
PARTY_STATUS	VARCHAR2	(1)	Party status flag.
ORGPR_LINE_OF_BUSINESS	VARCHAR2	(240)	Type of business activities performed at this site
ORGPR_DB_RATING	VARCHAR2	(5)	Dun & Bradstreet credit rating
ORGCT_STATUS	VARCHAR2	(1)	No longer used

Query Text

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


SELECT ROW_ID
,      PARTY_ID
,      PARTY_RELATIONSHIP_ID
,      PARTY_NUMBER
,      PARTY_TYPE
,      PARTY_NAME
,      SUBJECT_ID
,      SUBJECT_NUMBER
,      OBJECT_ID
,      OBJECT_NUMBER
,      OBJECT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJ_PARTY_TYPE
,      OBJ_COMPANY_NAME
,      OBJ_GROUP_NAME
,      OBJ_GROUP_TYPE
,      OBJ_FIRST_NAME
,      OBJ_MIDDLE_NAME
,      OBJ_LAST_NAME
,      OBJ_NAME_SUFFIX
,      OBJ_TITLE
,      OBJ_ALIAS
,      OBJ_SIC_CODE
,      OBJ_LONG_NAME
,      OBJ_ANALYSIS_FY
,      OBJ_FISCAL_YEAREND_MONTH
,      OBJ_NUM_OF_EMPLOYEES
,      OBJ_POT_REVENUE_CURR_FY
,      OBJ_POT_REVENUE_NEXT_FY
,      OBJ_TAX_REFERENCE
,      OBJ_YEAR_ESTABLISHED
,      OBJ_INTERNAL_FLAG
,      OBJ_PUB_PRIVATE_OWNER_FLAG
,      OBJ_DUNS_NUMBER
,      OBJ_JGZZ_FISCAL_CODE
,      SUB_PARTY_TYPE
,      SUB_PARTY_NAME
,      SUB_FIRST_NAME
,      SUB_MIDDLE_NAME
,      SUB_LAST_NAME
,      SUB_NAME_SUFFIX
,      SUB_TITLE
,      SUB_NICKNAME
,      SUB_PERSON_NAME_PHONETIC
,      SUB_ORG_CONTACT_ID
,      SUB_JOB_TITLE
,      SUB_DECISION_MAKER_FLAG
,      SUB_JOB_TITLE_CODE
,      SUB_MANAGED_BY
,      SUB_NATIVE_LANGUAGE
,      SUB_REFERENCE_USE_FLAG
,      SUB_OTHER_LANGUAGE_1
,      SUB_OTHER_LANGUAGE_2
,      SUB_RANK
,      SUB_SALUTATION
,      SUB_DEPARTMENT_CODE
,      SUB_DEPARTMENT
,      SUB_DATE_OF_BIRTH
,      SUB_PERSONAL_INCOME
,      RELATION
,      ADDRESS
,      CITY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      COUNTRY
,      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
,      SUB_LAST_UPDATE_DATE
,      OBJ_LAST_UPDATE_DATE
,      REL_LAST_UPDATE_DATE
,      ORGPR_LAST_UPDATE_DATE
,      ORGCT_LAST_UPDATE_DATE
,      PERSU_LAST_UPDATE_DATE
,      PEROB_LAST_UPDATE_DATE
,      PARTY_LAST_UPDATE_DATE
,      PARTY_STATUS
,      ORGPR_LINE_OF_BUSINESS
,      ORGPR_DB_RATING
,      ORGCT_STATUS
FROM APPS.JTF_PARTIES_V;

Dependencies

[top of page]

APPS.JTF_PARTIES_V references the following:

APPS: HZ_ORGANIZATION_PROFILES; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_PERSON_PROFILES; HZ_RELATIONSHIPS

APPS.JTF_PARTIES_V is referenced by following:

APPS: IEX_UWQ_SEL_PKG - show dependent code