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

VIEW: APPS.CSC_HZ_PARTIES_CONT_PTS_REL_V

Object Details
Object Name: CSC_HZ_PARTIES_CONT_PTS_REL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSC.CSC_HZ_PARTIES_CONT_PTS_REL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID column
OBJ_PARTY_ID NUMBER (15)
Object's party identifier
OBJ_PARTY_NUMBER VARCHAR2 (30)
Object's party number
OBJ_PARTY_NAME VARCHAR2 (360)
Object's Party name
OBJ_PARTY_TYPE VARCHAR2 (30)
Object's Type of party. This is limited to person, organization, group or relationship
OBJ_LAST_UPDATE_DATE DATE

Object's standard who column
OBJ_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Object's Descriptive Flexfield Structure Defining column
OBJ_ATTRIBUTE1 VARCHAR2 (150)
Object 's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE2 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE3 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE4 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE5 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE6 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE7 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE8 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE9 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE10 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE11 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE12 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE13 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE14 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE15 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE16 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE17 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE18 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE19 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE20 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE21 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE22 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE23 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_ATTRIBUTE24 VARCHAR2 (150)
Object's Descriptive Flexfield Segment Column
OBJ_PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Object's Salutary introduction, such as Mr. or Herr
OBJ_PERSON_FIRST_NAME VARCHAR2 (150)
Object's First name of the person
OBJ_PERSON_MIDDLE_NAME VARCHAR2 (60)
Object's Middle name of the person
OBJ_PERSON_LAST_NAME VARCHAR2 (150)
Object's Last or surname of the person
OBJ_PERSON_NAME_SUFFIX VARCHAR2 (30)
Object's Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
OBJ_PERSON_TITLE VARCHAR2 (60)
Object's professional or family title. For example, Don or The Right Honorable.
OBJ_ADDRESS VARCHAR2 (963)
Object's Identifying address
OBJ_ADDRESS1 VARCHAR2 (240)
Object's first line identifying address
OBJ_ADDRESS2 VARCHAR2 (240)
Object's second line of the Identifying address
OBJ_ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
OBJ_ADDRESS4 VARCHAR2 (240)
Object's fourth line of the Identifying address
OBJ_CITY VARCHAR2 (60)
Object's city for identifying address
OBJ_STATE VARCHAR2 (60)
Object's state for identifying address
OBJ_PROVINCE VARCHAR2 (60)
Object's province for identifying address
OBJ_POSTAL_CODE VARCHAR2 (60)
Object's Postal Code for identifying address
OBJ_COUNTRY VARCHAR2 (60)
Object's FND_TERRITORY.TERRITORY_CODE for identifying address. (where
OBJ_STATUS VARCHAR2 (1)
Object's party status flag.
OBJ_COUNTY VARCHAR2 (60)
Object's county of the Identifying address
OBJ_URL VARCHAR2 (2000)
Object's uniform resource locator
OBJ_EMAIL_ADDRESS VARCHAR2 (2000)
Object's E-mail address
OBJ_ORGANIZATION_NAME_PHONETIC VARCHAR2 (320)
Object's Japanese Kana, or phonetic representation of organization name
OBJ_PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Object's Phonetic representation of the person's first name
OBJ_PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Object's phonetic representation of the person's last name
SUB_PARTY_ID NUMBER (15)
Subject's Party identifier
SUB_PARTY_NUMBER VARCHAR2 (30)
Subject's unique identification number for this party
SUB_PARTY_NAME VARCHAR2 (360)
Subject's party name
SUB_PARTY_TYPE VARCHAR2 (30)
Subject's type of party. This is limited to person, organization, group or relationship
SUB_LAST_UPDATE_DATE DATE

Subject's standard Who column
SUB_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Subject's descriptive Flexfield Structure Defining column
SUB_ATTRIBUTE1 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE2 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE3 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE4 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE5 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE6 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE7 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE8 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE9 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE10 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE11 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE12 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE13 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE14 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE15 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE16 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE17 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE18 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE19 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE20 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE21 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE22 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Segment Column
SUB_ATTRIBUTE24 VARCHAR2 (150)
Subject's descriptive Flexfield Segment Column
SUB_PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Subject's salutary introduction, such as Mr. or Herr
SUB_PERSON_FIRST_NAME VARCHAR2 (150)
Subject's first name of the person
SUB_PERSON_MIDDLE_NAME VARCHAR2 (60)
Subject's middle name of the person
SUB_PERSON_LAST_NAME VARCHAR2 (150)
Subject's last or surname of the person
SUB_PERSON_NAME_SUFFIX VARCHAR2 (30)
Subject's indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
SUB_PERSON_TITLE VARCHAR2 (60)
Subject's professional or family title. For example, Don or The Right Honorable.
SUB_ADDRESS VARCHAR2 (963)
Subject's Identifying address
SUB_ADDRESS1 VARCHAR2 (240)
Subject's first line of the Identifying address
SUB_ADDRESS2 VARCHAR2 (240)
Subject's second line of the Identifying address
SUB_ADDRESS3 VARCHAR2 (240)
Subject's third line of the Identifying address
SUB_ADDRESS4 VARCHAR2 (240)
Subject's fourth line of the Identifying address
SUB_CITY VARCHAR2 (60)
Subject's city of the Identifying address
SUB_STATE VARCHAR2 (60)
Subject's state of the Identifying address
SUB_PROVINCE VARCHAR2 (60)
Subject's province of the Identifying address
SUB_POSTAL_CODE VARCHAR2 (60)
Subject's postal Code of the Identifying address
SUB_COUNTRY VARCHAR2 (60)
Subject's country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
SUB_STATUS VARCHAR2 (1)
Subject's party status flag.
SUB_COUNTY VARCHAR2 (60)
Subject's county of the Identifying address
SUB_URL VARCHAR2 (2000)
Subject's uniform resource locator
SUB_EMAIL_ADDRESS VARCHAR2 (2000)
Subject's E-mail address
SUB_ORGANIZATION_NAME_PHONETIC VARCHAR2 (320)
Subject's Japanese Kana, or phonetic representation of organization name
SUB_PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Subject's phonetic representation of the person's first name
SUB_PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Subject's phonetic representation of the person's last name
REL_PARTY_ID NUMBER (15)
Relationship's party identifier
REL_PARTY_NUMBER VARCHAR2 (30)
Relationship's unique identification number for this party
REL_PARTY_NAME VARCHAR2 (360)
Relationship's name of this party
REL_PARTY_TYPE VARCHAR2 (30)
Relationship's party type can only be Person, Organization, Group or Relationship.
REL_LAST_UPDATE_DATE DATE

Relationship's standard Who column
REL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Relationship's descriptive Flexfield Structure Defining column
REL_ATTRIBUTE1 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE2 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE3 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE4 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE5 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE6 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE7 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE8 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE9 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE10 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE11 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE12 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE13 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE14 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE15 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE16 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE17 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE18 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE19 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE20 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE21 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE22 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE23 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_ATTRIBUTE24 VARCHAR2 (150)
Relationship's descriptive Flexfield Segment Column
REL_PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Relationship's salutary introduction, such as Mr. or Herr
REL_PERSON_FIRST_NAME VARCHAR2 (150)
Relationship's first name of the person
REL_PERSON_MIDDLE_NAME VARCHAR2 (60)
Relationship's middle name of the person
REL_PERSON_LAST_NAME VARCHAR2 (150)
Relationship's last or surname of the person
REL_PERSON_NAME_SUFFIX VARCHAR2 (30)
Relationship's indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
REL_PERSON_TITLE VARCHAR2 (60)
Relationship's professional or family title. For example, Don or The Right Honorable.
REL_ADDRESS VARCHAR2 (963)
Relationship's Identifying address
REL_ADDRESS1 VARCHAR2 (240)
Relationship's first line of the Identifying address
REL_ADDRESS2 VARCHAR2 (240)
Relationship's second line of the Identifying address
REL_ADDRESS3 VARCHAR2 (240)
Relationship's third line of the Identifying address
REL_ADDRESS4 VARCHAR2 (240)
Relationship's fourth line of the Identifying address
REL_CITY VARCHAR2 (60)
Relationship's city of the Identifying address
REL_STATE VARCHAR2 (60)
Relationship's state of the Identifying address
REL_PROVINCE VARCHAR2 (60)
Relationship's province of the Identifying address
REL_POSTAL_CODE VARCHAR2 (60)
Relationship's postal Code of the Identifying address
REL_COUNTRY VARCHAR2 (60)
Relationship's country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
REL_STATUS VARCHAR2 (1)
Relationship's party status flag.
REL_COUNTY VARCHAR2 (60)
Relationship's county of the Identifying address
REL_CONTACT_POINT_ID NUMBER (15)
Relationship's county of the Identifying address
REL_CONTACT_POINT_TYPE VARCHAR2 (30)
Relationship's county of the Identifying address
REL_URL VARCHAR2 (2000)
Relationship's uniform resource locator
REL_EMAIL_ADDRESS VARCHAR2 (2000)
Relationship's E-mail address
REL_PHONE_COUNTRY_CODE VARCHAR2 (10)
Relationship's E-mail address
REL_PHONE_AREA_CODE VARCHAR2 (10)
Relationship's E-mail address
REL_PHONE_NUMBER VARCHAR2 (40)
Relationship's E-mail address
REL_PHONE_LINE_TYPE VARCHAR2 (30)
Relationship's E-mail address
REL_TRANSPOSED_PHONE_NUMBER VARCHAR2 (60)
Relationship's E-mail address
REL_CONT_PTS_LAST_UPDATE_DATE DATE

Relationship's E-mail address
REL_ORGANIZATION_NAME_PHONETIC VARCHAR2 (320)
Relationship's Japanese Kana, or phonetic representation of organization name
REL_PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Relationship's Phonetic representation of the person's first name
REL_PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Relationship's Phonetic representation of the person's last name
PARTY_REL_RELATIONSHIP_ID NUMBER

Party Relationship identifier
PARTY_REL_PARTY_ID NUMBER

Party identifier
PARTY_REL_SUBJECT_ID NUMBER

ID of the subject in the relationship
PARTY_REL_SUBJECT_TYPE VARCHAR2 (30)
Party Type of the subject in the relationship
PARTY_REL_SUBJECT_TABLE_NAME VARCHAR2 (30)
The party type can only be Person, Organization, Group or Relationship.
PARTY_REL_OBJECT_ID NUMBER

ID of the object in the relationship
PARTY_REL_OBJECT_TYPE VARCHAR2 (30)
The party type can only be Person, Organization, Group or Relationship.
PARTY_REL_OBJECT_TABLE_NAME VARCHAR2 (30)
The party type can only be Person, Organization, Group or Relationship.
PARTY_REL_RELATIONSHIP_CODE VARCHAR2 (30)
The party type can only be Person, Organization, Group or Relationship.
PARTY_REL_DIRECTIONAL_FLAG VARCHAR2 (1)
Y if this is a directional relationship, N otherwise
PARTY_REL_START_DATE DATE

Date relationship begins
PARTY_REL_END_DATE DATE

Date relationship ends
PARTY_REL_STATUS VARCHAR2 (1)
Party relationship status flag
PARTY_REL_RELATIONSHIP_TYPE VARCHAR2 (30)
Lookup: party_relationship_type.
PARTY_REL_LAST_UPDATE_DATE DATE

Last Update Date of Relationship Party
LKUP_MEANING VARCHAR2 (80)
Meaning
TERI_TERRITORY_SHORT_NAME VARCHAR2 (80)
Territory Short Name
OBJ_TERI_TERRITORY_SHORT_NAME VARCHAR2 (80)
Territory Short Name for Object Party
Query Text

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


SELECT ROW_ID
,      OBJ_PARTY_ID
,      OBJ_PARTY_NUMBER
,      OBJ_PARTY_NAME
,      OBJ_PARTY_TYPE
,      OBJ_LAST_UPDATE_DATE
,      OBJ_ATTRIBUTE_CATEGORY
,      OBJ_ATTRIBUTE1
,      OBJ_ATTRIBUTE2
,      OBJ_ATTRIBUTE3
,      OBJ_ATTRIBUTE4
,      OBJ_ATTRIBUTE5
,      OBJ_ATTRIBUTE6
,      OBJ_ATTRIBUTE7
,      OBJ_ATTRIBUTE8
,      OBJ_ATTRIBUTE9
,      OBJ_ATTRIBUTE10
,      OBJ_ATTRIBUTE11
,      OBJ_ATTRIBUTE12
,      OBJ_ATTRIBUTE13
,      OBJ_ATTRIBUTE14
,      OBJ_ATTRIBUTE15
,      OBJ_ATTRIBUTE16
,      OBJ_ATTRIBUTE17
,      OBJ_ATTRIBUTE18
,      OBJ_ATTRIBUTE19
,      OBJ_ATTRIBUTE20
,      OBJ_ATTRIBUTE21
,      OBJ_ATTRIBUTE22
,      OBJ_ATTRIBUTE23
,      OBJ_ATTRIBUTE24
,      OBJ_PERSON_PRE_NAME_ADJUNCT
,      OBJ_PERSON_FIRST_NAME
,      OBJ_PERSON_MIDDLE_NAME
,      OBJ_PERSON_LAST_NAME
,      OBJ_PERSON_NAME_SUFFIX
,      OBJ_PERSON_TITLE
,      OBJ_ADDRESS
,      OBJ_ADDRESS1
,      OBJ_ADDRESS2
,      OBJ_ADDRESS3
,      OBJ_ADDRESS4
,      OBJ_CITY
,      OBJ_STATE
,      OBJ_PROVINCE
,      OBJ_POSTAL_CODE
,      OBJ_COUNTRY
,      OBJ_STATUS
,      OBJ_COUNTY
,      OBJ_URL
,      OBJ_EMAIL_ADDRESS
,      OBJ_ORGANIZATION_NAME_PHONETIC
,      OBJ_PERSON_FIRST_NAME_PHONETIC
,      OBJ_PERSON_LAST_NAME_PHONETIC
,      SUB_PARTY_ID
,      SUB_PARTY_NUMBER
,      SUB_PARTY_NAME
,      SUB_PARTY_TYPE
,      SUB_LAST_UPDATE_DATE
,      SUB_ATTRIBUTE_CATEGORY
,      SUB_ATTRIBUTE1
,      SUB_ATTRIBUTE2
,      SUB_ATTRIBUTE3
,      SUB_ATTRIBUTE4
,      SUB_ATTRIBUTE5
,      SUB_ATTRIBUTE6
,      SUB_ATTRIBUTE7
,      SUB_ATTRIBUTE8
,      SUB_ATTRIBUTE9
,      SUB_ATTRIBUTE10
,      SUB_ATTRIBUTE11
,      SUB_ATTRIBUTE12
,      SUB_ATTRIBUTE13
,      SUB_ATTRIBUTE14
,      SUB_ATTRIBUTE15
,      SUB_ATTRIBUTE16
,      SUB_ATTRIBUTE17
,      SUB_ATTRIBUTE18
,      SUB_ATTRIBUTE19
,      SUB_ATTRIBUTE20
,      SUB_ATTRIBUTE21
,      SUB_ATTRIBUTE22
,      SUB_ATTRIBUTE23
,      SUB_ATTRIBUTE24
,      SUB_PERSON_PRE_NAME_ADJUNCT
,      SUB_PERSON_FIRST_NAME
,      SUB_PERSON_MIDDLE_NAME
,      SUB_PERSON_LAST_NAME
,      SUB_PERSON_NAME_SUFFIX
,      SUB_PERSON_TITLE
,      SUB_ADDRESS
,      SUB_ADDRESS1
,      SUB_ADDRESS2
,      SUB_ADDRESS3
,      SUB_ADDRESS4
,      SUB_CITY
,      SUB_STATE
,      SUB_PROVINCE
,      SUB_POSTAL_CODE
,      SUB_COUNTRY
,      SUB_STATUS
,      SUB_COUNTY
,      SUB_URL
,      SUB_EMAIL_ADDRESS
,      SUB_ORGANIZATION_NAME_PHONETIC
,      SUB_PERSON_FIRST_NAME_PHONETIC
,      SUB_PERSON_LAST_NAME_PHONETIC
,      REL_PARTY_ID
,      REL_PARTY_NUMBER
,      REL_PARTY_NAME
,      REL_PARTY_TYPE
,      REL_LAST_UPDATE_DATE
,      REL_ATTRIBUTE_CATEGORY
,      REL_ATTRIBUTE1
,      REL_ATTRIBUTE2
,      REL_ATTRIBUTE3
,      REL_ATTRIBUTE4
,      REL_ATTRIBUTE5
,      REL_ATTRIBUTE6
,      REL_ATTRIBUTE7
,      REL_ATTRIBUTE8
,      REL_ATTRIBUTE9
,      REL_ATTRIBUTE10
,      REL_ATTRIBUTE11
,      REL_ATTRIBUTE12
,      REL_ATTRIBUTE13
,      REL_ATTRIBUTE14
,      REL_ATTRIBUTE15
,      REL_ATTRIBUTE16
,      REL_ATTRIBUTE17
,      REL_ATTRIBUTE18
,      REL_ATTRIBUTE19
,      REL_ATTRIBUTE20
,      REL_ATTRIBUTE21
,      REL_ATTRIBUTE22
,      REL_ATTRIBUTE23
,      REL_ATTRIBUTE24
,      REL_PERSON_PRE_NAME_ADJUNCT
,      REL_PERSON_FIRST_NAME
,      REL_PERSON_MIDDLE_NAME
,      REL_PERSON_LAST_NAME
,      REL_PERSON_NAME_SUFFIX
,      REL_PERSON_TITLE
,      REL_ADDRESS
,      REL_ADDRESS1
,      REL_ADDRESS2
,      REL_ADDRESS3
,      REL_ADDRESS4
,      REL_CITY
,      REL_STATE
,      REL_PROVINCE
,      REL_POSTAL_CODE
,      REL_COUNTRY
,      REL_STATUS
,      REL_COUNTY
,      REL_CONTACT_POINT_ID
,      REL_CONTACT_POINT_TYPE
,      REL_URL
,      REL_EMAIL_ADDRESS
,      REL_PHONE_COUNTRY_CODE
,      REL_PHONE_AREA_CODE
,      REL_PHONE_NUMBER
,      REL_PHONE_LINE_TYPE
,      REL_TRANSPOSED_PHONE_NUMBER
,      REL_CONT_PTS_LAST_UPDATE_DATE
,      REL_ORGANIZATION_NAME_PHONETIC
,      REL_PERSON_FIRST_NAME_PHONETIC
,      REL_PERSON_LAST_NAME_PHONETIC
,      PARTY_REL_RELATIONSHIP_ID
,      PARTY_REL_PARTY_ID
,      PARTY_REL_SUBJECT_ID
,      PARTY_REL_SUBJECT_TYPE
,      PARTY_REL_SUBJECT_TABLE_NAME
,      PARTY_REL_OBJECT_ID
,      PARTY_REL_OBJECT_TYPE
,      PARTY_REL_OBJECT_TABLE_NAME
,      PARTY_REL_RELATIONSHIP_CODE
,      PARTY_REL_DIRECTIONAL_FLAG
,      PARTY_REL_START_DATE
,      PARTY_REL_END_DATE
,      PARTY_REL_STATUS
,      PARTY_REL_RELATIONSHIP_TYPE
,      PARTY_REL_LAST_UPDATE_DATE
,      LKUP_MEANING
,      TERI_TERRITORY_SHORT_NAME
,      OBJ_TERI_TERRITORY_SHORT_NAME
FROM APPS.CSC_HZ_PARTIES_CONT_PTS_REL_V;

Dependencies

[top of page]

APPS.CSC_HZ_PARTIES_CONT_PTS_REL_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
ViewFND_TERRITORIES_VL
SynonymHZ_CONTACT_POINTS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS

APPS.CSC_HZ_PARTIES_CONT_PTS_REL_V is not referenced by any database object