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


VIEW: APPS.HZ_PARTY_RELATIONSHIP_V

Object Details
Object Name: HZ_PARTY_RELATIONSHIP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAR.HZ_PARTY_RELATIONSHIP_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
PARTY_RELATIONSHIP_ID NUMBER (15) Yes The unique identifier of a relationship
PARTY_ID NUMBER (15)
Identifier for the party. Foreign key to the HZ_PARTIES table.
RELATIONSHIP_TYPE_CODE VARCHAR2 (30) Yes Either a forward or a backward relationship code
RELATIONSHIP_TYPE VARCHAR2 (80)
QuickCode meaning
COMMENTS VARCHAR2 (240)
User comments
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
OBJECT_ID NUMBER (15) Yes The identifier of the object in this relationship
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
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
STATUS VARCHAR2 (1) Yes Indicates if this is an active or inactive relationship. A for active, I for inactive.
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

Date when the record was entered or changed in a data warehouse
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).
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
CONTENT_SOURCE_TYPE VARCHAR2 (30) Yes Source of data content
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.
SUBJECT_PARTY_ID NUMBER (15) Yes Party identifier
SUBJECT_PARTY_NUMBER VARCHAR2 (30) Yes Unique identification number for this party
SUBJECT_PARTY_NAME VARCHAR2 (360) Yes Name of this party
SUBJECT_PARTY_TYPE VARCHAR2 (30) Yes The party type can only be Person, Organization, Group or Relationship.
SUBJECT_VALIDATED_FLAG VARCHAR2 (1)
Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
SUBJECT_ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Customer identifier from foreign system. May not be unique.
SUBJECT_SIC_CODE VARCHAR2 (30)
Standard Industry Classification (SIC) code
SUBJECT_HQ_BRANCH_IND VARCHAR2 (30)
Status of this site. Identifies if the location is the headquarters, a branch, or a single location.
SUBJECT_CUSTOMER_KEY VARCHAR2 (500)
Derived key used to facilitate fuzzy searches
SUBJECT_TAX_REFERENCE VARCHAR2 (50)
Taxpayer registration number, also known as the VAT number.
SUBJECT_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
SUBJECT_DUNS_NUMBER NUMBER

The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet
SUBJECT_TAX_NAME VARCHAR2 (60)
No longer used
SUBJECT_PER_PRE_NAME_ADJUNCT VARCHAR2 (30)
Salutary introduction, such as Mr. or Herr
SUBJECT_PERSON_FIRST_NAME VARCHAR2 (150)
First name of the person
SUBJECT_PERSON_MIDDLE_NAME VARCHAR2 (60)
Middle name of the person
SUBJECT_PERSON_LAST_NAME VARCHAR2 (150)
Last or surname of the person
SUBJECT_PERSON_NAME_SUFFIX VARCHAR2 (30)
Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
SUBJECT_PERSON_TITLE VARCHAR2 (60)
A professional or family title. For example, Don or The Right Honorable.
SUBJECT_PERSON_ACADEMIC_TITLE VARCHAR2 (30)
Academic title that is part of a person's name, such as Dr. John Smith.
SUBJECT_PERSON_PREV_LAST_NAME VARCHAR2 (150)
Previous last or surname of the person
SUBJECT_KNOWN_AS VARCHAR2 (240)
An alias or other name by which a party is known
SUBJECT_PERSON_IDEN_TYPE VARCHAR2 (30)
Personal identifier type, such as driver's license or passport. Lookup type for PERSON_IDENTIFIER column
SUBJECT_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
SUBJECT_GROUP_TYPE VARCHAR2 (30)
Lookup for group type
SUBJECT_COUNTRY VARCHAR2 (60)
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
SUBJECT_ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
SUBJECT_ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
SUBJECT_ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
SUBJECT_ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
SUBJECT_CITY VARCHAR2 (60)
City of the Identifying address
SUBJECT_POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
SUBJECT_STATE VARCHAR2 (60)
State of the Identifying address
SUBJECT_PROVINCE VARCHAR2 (60)
Province of the Identifying address
SUBJECT_STATUS VARCHAR2 (1) Yes Party status flag.
SUBJECT_COUNTY VARCHAR2 (60)
County of the Identifying address
SUBJECT_SIC_CODE_TYPE VARCHAR2 (30)
Version of Standard Industry Classification (SIC) code
SUBJECT_TOTAL_NUM_OF_ORDERS NUMBER

Total number of orders through the last ordered date
SUBJECT_TOTAL_ORDERED_AMOUNT NUMBER

Total amount ordered through the last ordered date
SUBJECT_LAST_ORDERED_DATE DATE

Date of the most recent order
SUBJECT_URL VARCHAR2 (2000)
Uniform resource locator
SUBJECT_EMAIL_ADDRESS VARCHAR2 (2000)
E-mail address
SUBJECT_DO_NOT_MAIL_FLAG VARCHAR2 (1)
No longer used
SUBJECT_ANALYSIS_FY VARCHAR2 (5)
Fiscal year that financial information is based on
SUBJECT_FISCAL_YEAREND_MONTH VARCHAR2 (30)
Month in which fiscal year ends for organization
SUBJECT_EMPLOYEES_TOTAL NUMBER

Total number of employees
SUBJECT_CURR_FY_POTENTIAL_REV NUMBER

Organization's potential revenue this fiscal year
SUBJECT_NEXT_FY_POTENTIAL_REV NUMBER

Organization's potential revenue for next fiscal year
SUBJECT_YEAR_ESTABLISHED NUMBER (4)
Year that the organization began doing business
SUBJECT_GSA_INDICATOR_FLAG VARCHAR2 (1)
Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA.
SUBJECT_MISSION_STATEMENT VARCHAR2 (2000)
Corporate charter of organization
SUBJECT_ORG_NAME_PHONETIC VARCHAR2 (320)
Japanese Kana, or phonetic representation of organization name
SUBJECT_PER_FIRST_NAME_PHONETC VARCHAR2 (60)
Phonetic representation of the person's first name
SUBJECT_PER_LAST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's last name
SUBJECT_LANGUAGE_NAME VARCHAR2 (4)
Standard name for a language
SUBJECT_CATEGORY_CODE VARCHAR2 (30)
User-definable category. Lookup type is CUSTOMER_CATEGORY
SUBJECT_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
SUBJECT_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.
SUBJECT_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
SUBJECT_SALUTATION VARCHAR2 (60)
Phrase used to address a party in any correspondence.
SUBJECT_KNOWN_AS2 VARCHAR2 (240)
An alias or other name by which a party is known
SUBJECT_KNOWN_AS4 VARCHAR2 (240)
An alias or other name by which a party is known
SUBJECT_KNOWN_AS3 VARCHAR2 (240)
An alias or other name by which a party is known
SUBJECT_KNOWN_AS5 VARCHAR2 (240)
An alias or other name by which a party is known
OBJECT_PARTY_ID NUMBER (15) Yes Party identifier
OBJECT_PARTY_NUMBER VARCHAR2 (30) Yes Unique identification number for this party
OBJECT_PARTY_NAME VARCHAR2 (360) Yes Name of this party
OBJECT_VALIDATED_FLAG VARCHAR2 (1)
Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
OBJECT_PARTY_TYPE VARCHAR2 (30) Yes The party type can only be Person, Organization, Group or Relationship.
OBJECT_ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Customer identifier from foreign system. May not be unique.
OBJECT_SIC_CODE VARCHAR2 (30)
Standard Industry Classification (SIC) code
OBJECT_HQ_BRANCH_IND VARCHAR2 (30)
Status of this site. Identifies if the location is the headquarters, a branch, or a single location.
OBJECT_CUSTOMER_KEY VARCHAR2 (500)
Derived key used to facilitate fuzzy searches
OBJECT_TAX_REFERENCE VARCHAR2 (50)
Taxpayer registration number, also known as the VAT number.
OBJECT_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
OBJECT_DUNS_NUMBER NUMBER

The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet
OBJECT_TAX_NAME VARCHAR2 (60)
No longer used
OBJECT_PER_PRE_NAME_ADJUNCT VARCHAR2 (30)
Salutary introduction, such as Mr. or Herr
OBJECT_PERSON_FIRST_NAME VARCHAR2 (150)
First name of the person
OBJECT_PERSON_MIDDLE_NAME VARCHAR2 (60)
Middle name of the person
OBJECT_PERSON_LAST_NAME VARCHAR2 (150)
Last or surname of the person
OBJECT_PERSON_NAME_SUFFIX VARCHAR2 (30)
Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
OBJECT_PERSON_TITLE VARCHAR2 (60)
A professional or family title. For example, Don or The Right Honorable.
OBJECT_PERSON_ACADEMIC_TITLE VARCHAR2 (30)
Academic title that is part of a person's name, such as Dr. John Smith.
OBJECT_PER_PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous last or surname of the person
OBJECT_KNOWN_AS VARCHAR2 (240)
An alias or other name by which a party is known
OBJECT_PERSON_IDEN_TYPE VARCHAR2 (30)
Personal identifier type, such as driver's license or passport. Lookup type for PERSON_IDENTIFIER column
OBJECT_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
OBJECT_GROUP_TYPE VARCHAR2 (30)
Lookup for group type
OBJECT_COUNTRY VARCHAR2 (60)
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
OBJECT_ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
OBJECT_ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
OBJECT_ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
OBJECT_ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
OBJECT_CITY VARCHAR2 (60)
City of the Identifying address
OBJECT_POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
OBJECT_STATE VARCHAR2 (60)
State of the Identifying address
OBJECT_PROVINCE VARCHAR2 (60)
Province of the Identifying address
OBJECT_STATUS VARCHAR2 (1) Yes Party status flag.
OBJECT_COUNTY VARCHAR2 (60)
County of the Identifying address
OBJECT_SIC_CODE_TYPE VARCHAR2 (30)
Version of Standard Industry Classification (SIC) code
OBJECT_TOTAL_NUM_OF_ORDERS NUMBER

Total number of orders through the last ordered date
OBJECT_TOTAL_ORDERED_AMOUNT NUMBER

Total amount ordered through the last ordered date
OBJECT_LAST_ORDERED_DATE DATE

Date of the most recent order
OBJECT_URL VARCHAR2 (2000)
Uniform resource locator
OBJECT_EMAIL_ADDRESS VARCHAR2 (2000)
E-mail address
OBJECT_DO_NOT_MAIL_FLAG VARCHAR2 (1)
No longer used
OBJECT_ANALYSIS_FY VARCHAR2 (5)
Fiscal year that financial information is based on
OBJECT_FISCAL_YEAREND_MONTH VARCHAR2 (30)
Month in which fiscal year ends for organization
OBJECT_EMPLOYEES_TOTAL NUMBER

Total number of employees
OBJECT_CURR_FY_POTENTIAL_REV NUMBER

Organization's potential revenue this fiscal year
OBJECT_NEXT_FY_POTENTIAL_REV NUMBER

Organization's potential revenue for next fiscal year
OBJECT_YEAR_ESTABLISHED NUMBER (4)
Year that the organization began doing business
OBJECT_GSA_INDICATOR_FLAG VARCHAR2 (1)
Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA.
OBJECT_MISSION_STATEMENT VARCHAR2 (2000)
Corporate charter of organization
OBJECT_ORG_NAME_PHONETIC VARCHAR2 (320)
Japanese Kana, or phonetic representation of organization name
OBJECT_PER_FIRST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's first name
OBJECT_PER_LAST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's last name
OBJECT_LANGUAGE_NAME VARCHAR2 (4)
Standard name for a language
OBJECT_CATEGORY_CODE VARCHAR2 (30)
User-definable category. Lookup type is CUSTOMER_CATEGORY
OBJECT_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
OBJECT_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.
OBJECT_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
OBJECT_SALUTATION VARCHAR2 (60)
Phrase used to address a party in any correspondence.
OBJECT_KNOWN_AS2 VARCHAR2 (240)
An alias or other name by which a party is known
OBJECT_KNOWN_AS3 VARCHAR2 (240)
An alias or other name by which a party is known
OBJECT_KNOWN_AS4 VARCHAR2 (240)
An alias or other name by which a party is known
OBJECT_KNOWN_AS5 VARCHAR2 (240)
An alias or other name by which a party is known
Query Text

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


SELECT PARTY_RELATIONSHIP_ID
,      PARTY_ID
,      RELATIONSHIP_TYPE_CODE
,      RELATIONSHIP_TYPE
,      COMMENTS
,      START_DATE
,      END_DATE
,      SUBJECT_ID
,      OBJECT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE7
,      ATTRIBUTE6
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      LAST_UPDATE_DATE
,      STATUS
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WH_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      CONTENT_SOURCE_TYPE
,      DIRECTIONAL_FLAG
,      SUBJECT_PARTY_ID
,      SUBJECT_PARTY_NUMBER
,      SUBJECT_PARTY_NAME
,      SUBJECT_PARTY_TYPE
,      SUBJECT_VALIDATED_FLAG
,      SUBJECT_ORIG_SYSTEM_REFERENCE
,      SUBJECT_SIC_CODE
,      SUBJECT_HQ_BRANCH_IND
,      SUBJECT_CUSTOMER_KEY
,      SUBJECT_TAX_REFERENCE
,      SUBJECT_JGZZ_FISCAL_CODE
,      SUBJECT_DUNS_NUMBER
,      SUBJECT_TAX_NAME
,      SUBJECT_PER_PRE_NAME_ADJUNCT
,      SUBJECT_PERSON_FIRST_NAME
,      SUBJECT_PERSON_MIDDLE_NAME
,      SUBJECT_PERSON_LAST_NAME
,      SUBJECT_PERSON_NAME_SUFFIX
,      SUBJECT_PERSON_TITLE
,      SUBJECT_PERSON_ACADEMIC_TITLE
,      SUBJECT_PERSON_PREV_LAST_NAME
,      SUBJECT_KNOWN_AS
,      SUBJECT_PERSON_IDEN_TYPE
,      SUBJECT_PERSON_IDENTIFIER
,      SUBJECT_GROUP_TYPE
,      SUBJECT_COUNTRY
,      SUBJECT_ADDRESS1
,      SUBJECT_ADDRESS2
,      SUBJECT_ADDRESS3
,      SUBJECT_ADDRESS4
,      SUBJECT_CITY
,      SUBJECT_POSTAL_CODE
,      SUBJECT_STATE
,      SUBJECT_PROVINCE
,      SUBJECT_STATUS
,      SUBJECT_COUNTY
,      SUBJECT_SIC_CODE_TYPE
,      SUBJECT_TOTAL_NUM_OF_ORDERS
,      SUBJECT_TOTAL_ORDERED_AMOUNT
,      SUBJECT_LAST_ORDERED_DATE
,      SUBJECT_URL
,      SUBJECT_EMAIL_ADDRESS
,      SUBJECT_DO_NOT_MAIL_FLAG
,      SUBJECT_ANALYSIS_FY
,      SUBJECT_FISCAL_YEAREND_MONTH
,      SUBJECT_EMPLOYEES_TOTAL
,      SUBJECT_CURR_FY_POTENTIAL_REV
,      SUBJECT_NEXT_FY_POTENTIAL_REV
,      SUBJECT_YEAR_ESTABLISHED
,      SUBJECT_GSA_INDICATOR_FLAG
,      SUBJECT_MISSION_STATEMENT
,      SUBJECT_ORG_NAME_PHONETIC
,      SUBJECT_PER_FIRST_NAME_PHONETC
,      SUBJECT_PER_LAST_NAME_PHONETIC
,      SUBJECT_LANGUAGE_NAME
,      SUBJECT_CATEGORY_CODE
,      SUBJECT_REFERENCE_USE_FLAG
,      SUBJECT_THIRD_PARTY_FLAG
,      SUBJECT_COMPETITOR_FLAG
,      SUBJECT_SALUTATION
,      SUBJECT_KNOWN_AS2
,      SUBJECT_KNOWN_AS4
,      SUBJECT_KNOWN_AS3
,      SUBJECT_KNOWN_AS5
,      OBJECT_PARTY_ID
,      OBJECT_PARTY_NUMBER
,      OBJECT_PARTY_NAME
,      OBJECT_VALIDATED_FLAG
,      OBJECT_PARTY_TYPE
,      OBJECT_ORIG_SYSTEM_REFERENCE
,      OBJECT_SIC_CODE
,      OBJECT_HQ_BRANCH_IND
,      OBJECT_CUSTOMER_KEY
,      OBJECT_TAX_REFERENCE
,      OBJECT_JGZZ_FISCAL_CODE
,      OBJECT_DUNS_NUMBER
,      OBJECT_TAX_NAME
,      OBJECT_PER_PRE_NAME_ADJUNCT
,      OBJECT_PERSON_FIRST_NAME
,      OBJECT_PERSON_MIDDLE_NAME
,      OBJECT_PERSON_LAST_NAME
,      OBJECT_PERSON_NAME_SUFFIX
,      OBJECT_PERSON_TITLE
,      OBJECT_PERSON_ACADEMIC_TITLE
,      OBJECT_PER_PREVIOUS_LAST_NAME
,      OBJECT_KNOWN_AS
,      OBJECT_PERSON_IDEN_TYPE
,      OBJECT_PERSON_IDENTIFIER
,      OBJECT_GROUP_TYPE
,      OBJECT_COUNTRY
,      OBJECT_ADDRESS1
,      OBJECT_ADDRESS2
,      OBJECT_ADDRESS3
,      OBJECT_ADDRESS4
,      OBJECT_CITY
,      OBJECT_POSTAL_CODE
,      OBJECT_STATE
,      OBJECT_PROVINCE
,      OBJECT_STATUS
,      OBJECT_COUNTY
,      OBJECT_SIC_CODE_TYPE
,      OBJECT_TOTAL_NUM_OF_ORDERS
,      OBJECT_TOTAL_ORDERED_AMOUNT
,      OBJECT_LAST_ORDERED_DATE
,      OBJECT_URL
,      OBJECT_EMAIL_ADDRESS
,      OBJECT_DO_NOT_MAIL_FLAG
,      OBJECT_ANALYSIS_FY
,      OBJECT_FISCAL_YEAREND_MONTH
,      OBJECT_EMPLOYEES_TOTAL
,      OBJECT_CURR_FY_POTENTIAL_REV
,      OBJECT_NEXT_FY_POTENTIAL_REV
,      OBJECT_YEAR_ESTABLISHED
,      OBJECT_GSA_INDICATOR_FLAG
,      OBJECT_MISSION_STATEMENT
,      OBJECT_ORG_NAME_PHONETIC
,      OBJECT_PER_FIRST_NAME_PHONETIC
,      OBJECT_PER_LAST_NAME_PHONETIC
,      OBJECT_LANGUAGE_NAME
,      OBJECT_CATEGORY_CODE
,      OBJECT_REFERENCE_USE_FLAG
,      OBJECT_THIRD_PARTY_FLAG
,      OBJECT_COMPETITOR_FLAG
,      OBJECT_SALUTATION
,      OBJECT_KNOWN_AS2
,      OBJECT_KNOWN_AS3
,      OBJECT_KNOWN_AS4
,      OBJECT_KNOWN_AS5
FROM APPS.HZ_PARTY_RELATIONSHIP_V;

Dependencies

[top of page]

APPS.HZ_PARTY_RELATIONSHIP_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
APPS.HZ_PARTY_RELATIONSHIP_V is referenced by following:

SchemaAPPS
Package BodyPV_TAP_BES_PKG - show dependent code