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

VIEW: APPS.HZ_PERSON_PROFILES_V

Object Details
Object Name: HZ_PERSON_PROFILES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.HZ_PERSON_PROFILES_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
PERSON_PROFILE_ID NUMBER (15) Yes Unique identifier for the person profile
PARTY_ID NUMBER (15) Yes Identifier for the party. Foreign key to the HZ_PARTIES table.
PERSON_NAME VARCHAR2 (450)
The combination of title, first, middle, last, and suffix names.
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
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
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Salutary introduction such as Mr., Herr, etc.
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".
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 the person's name such as Dr. Jane Smith
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous last or surname of the person
PERSON_INITIALS VARCHAR2 (6)
Name initials
KNOWN_AS VARCHAR2 (240)
An alias or other name by which a person is known
TAX_NAME VARCHAR2 (60)
No longer used
PERSON_NAME_PHONETIC VARCHAR2 (320)
Japanese Kana, or phonetic representation of person name
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's first name
PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's last name
TAX_REFERENCE VARCHAR2 (60)
Taxpayer registration number, also known as the VAT number.
JGZZ_FISCAL_CODE VARCHAR2 (20)
Taxpayer identification number. Used in Europe to identify customers. Also known as the fiscal code or NIF.
PRIMARY_CONTACT_ID NUMBER (15)
No longer used
PERSON_IDEN_TYPE VARCHAR2 (30)
Lookup representing most common personal identification number in a country. For example, Social Security Number in the US
PERSON_IDENTIFIER VARCHAR2 (60)
Identity reference field for things like Social Security, tax identity number, or driver's license number.
DATE_OF_BIRTH DATE

Date the person was born
PLACE_OF_BIRTH VARCHAR2 (60)
Where the person was born. Typically, the city and country.
DATE_OF_DEATH DATE

Date the person died
GENDER VARCHAR2 (30)
The gender (male, female, unknown) of the person
DECLARED_ETHNICITY VARCHAR2 (60)
The declared ethnicity of the person
MARITAL_STATUS VARCHAR2 (30)
Marital status of the person
MARITAL_STATUS_EFFECTIVE_DATE DATE

Date when the person's marital status changed.
PERSONAL_INCOME NUMBER

The estimated gross annual income of the person
HEAD_OF_HOUSEHOLD_FLAG VARCHAR2 (1)
Indicates if the person is the head of the household. Y for the head of a household, N for people who are not the head of a household.
HOUSEHOLD_INCOME NUMBER

Income of the household that this person is a part of
HOUSEHOLD_SIZE NUMBER

The size of the household this person is a part of
RENT_OWN_IND VARCHAR2 (30)
Indicates if the person rents or owns his or her residence. Lookup of values for rent, own, lease, and so on.
LAST_KNOWN_GPS VARCHAR2 (60)
The geophysical location (GPS point) that was last reported for the person
BEST_TIME_CONTACT_BEGIN DATE

No longer used
BEST_TIME_CONTACT_END DATE

No longer used
EFFECTIVE_START_DATE DATE
Yes For date tracking capabilities
EFFECTIVE_END_DATE DATE

For date tracking capabilities
CONTENT_SOURCE_TYPE VARCHAR2 (30) Yes Source of data content
CONTENT_SOURCE_NUMBER VARCHAR2 (30)
No longer used
INTERNAL_FLAG VARCHAR2 (1)
Indicates whether the person is internal or external to the user's organization. Y for a person who is a member of the user's organization, N for a person who is not a member of the user's organization.
KNOWN_AS2 VARCHAR2 (240)
An alias or other name by which a party is known
KNOWN_AS3 VARCHAR2 (240)
An alias or other name by which a party is known
MIDDLE_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of person's middle name
KNOWN_AS4 VARCHAR2 (240)
An alias or other name by which a party is known
KNOWN_AS5 VARCHAR2 (240)
An alias or other name by which a party is known
PARTY_NUMBER VARCHAR2 (30) Yes Unique identification number for this party
PARTY_NAME VARCHAR2 (360) Yes Name of this party
PARTY_TYPE VARCHAR2 (30) Yes The party type can only be Person, Organization, Group or Relationship.
VALIDATED_FLAG VARCHAR2 (1)
Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
GROUP_TYPE VARCHAR2 (30)
Lookup for group type
COUNTRY VARCHAR2 (60)
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
CITY VARCHAR2 (60)
City of the Identifying address
POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
STATE VARCHAR2 (60)
State of the Identifying address
PROVINCE VARCHAR2 (60)
Province of the Identifying address
STATUS VARCHAR2 (1) Yes Party status flag.
COUNTY VARCHAR2 (60)
County of the Identifying address
TOTAL_NUM_OF_ORDERS NUMBER

Total number of orders through the last ordered date
TOTAL_ORDERED_AMOUNT NUMBER

Total amount ordered through the last ordered date
LAST_ORDERED_DATE DATE

Date of the most recent order
URL VARCHAR2 (2000)
Uniform resource locator
EMAIL_ADDRESS VARCHAR2 (2000)
E-mail address
DO_NOT_MAIL_FLAG VARCHAR2 (1)
No longer used
ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Customer identifier from foreign system. May not be unique.
CUSTOMER_KEY VARCHAR2 (500)
Derived key used to facilitate fuzzy searches
LANGUAGE_NAME VARCHAR2 (4)
Standard name for a language
CATEGORY_CODE VARCHAR2 (30)
User-definable category. Lookup type is CUSTOMER_CATEGORY
REFERENCE_USE_FLAG VARCHAR2 (1)
Indicates if customer has agreed to be a reference. Y for customer who is referencable, N or null for a nonreferencable customer
THIRD_PARTY_FLAG VARCHAR2 (1)
Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory.
COMPETITOR_FLAG VARCHAR2 (1)
Indicates if a party is a competitor. Y for a party that is a competitor, N or null for a party that is not a competitor
SALUTATION VARCHAR2 (60)
Phrase used to address a party in any correspondence.
ACTUAL_CONTENT_SOURCE VARCHAR2 (30) Yes Additional Content Source Type column for backward compatibility.
DECEASED_FLAG VARCHAR2 (1)
Y or N indicates whether the person is deceased or not
PARTY_OBJECT_VERSION_NUMBER NUMBER

This column is used for locking purposes
Query Text

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


SELECT PERSON_PROFILE_ID
,      PARTY_ID
,      PERSON_NAME
,      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
,      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
,      PERSON_INITIALS
,      KNOWN_AS
,      TAX_NAME
,      PERSON_NAME_PHONETIC
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_LAST_NAME_PHONETIC
,      TAX_REFERENCE
,      JGZZ_FISCAL_CODE
,      PRIMARY_CONTACT_ID
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      DATE_OF_BIRTH
,      PLACE_OF_BIRTH
,      DATE_OF_DEATH
,      GENDER
,      DECLARED_ETHNICITY
,      MARITAL_STATUS
,      MARITAL_STATUS_EFFECTIVE_DATE
,      PERSONAL_INCOME
,      HEAD_OF_HOUSEHOLD_FLAG
,      HOUSEHOLD_INCOME
,      HOUSEHOLD_SIZE
,      RENT_OWN_IND
,      LAST_KNOWN_GPS
,      BEST_TIME_CONTACT_BEGIN
,      BEST_TIME_CONTACT_END
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CONTENT_SOURCE_TYPE
,      CONTENT_SOURCE_NUMBER
,      INTERNAL_FLAG
,      KNOWN_AS2
,      KNOWN_AS3
,      MIDDLE_NAME_PHONETIC
,      KNOWN_AS4
,      KNOWN_AS5
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      VALIDATED_FLAG
,      GROUP_TYPE
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      STATUS
,      COUNTY
,      TOTAL_NUM_OF_ORDERS
,      TOTAL_ORDERED_AMOUNT
,      LAST_ORDERED_DATE
,      URL
,      EMAIL_ADDRESS
,      DO_NOT_MAIL_FLAG
,      ORIG_SYSTEM_REFERENCE
,      CUSTOMER_KEY
,      LANGUAGE_NAME
,      CATEGORY_CODE
,      REFERENCE_USE_FLAG
,      THIRD_PARTY_FLAG
,      COMPETITOR_FLAG
,      SALUTATION
,      ACTUAL_CONTENT_SOURCE
,      DECEASED_FLAG
,      PARTY_OBJECT_VERSION_NUMBER
FROM APPS.HZ_PERSON_PROFILES_V;

Dependencies

[top of page]

APPS.HZ_PERSON_PROFILES_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES

APPS.HZ_PERSON_PROFILES_V is not referenced by any database object