[Home] [Help] [Dependency Information]
Object Name: | CSC_HZ_PARTIES_CONT_INFO_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_HZ_PARTIES_CONT_INFO_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID column | |
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_OBJ_VER_NUMBER | NUMBER | Subject's Object Version Number | ||
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_OBJ_VER_NUMBER | NUMBER | Relationship's Object Version Number | ||
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_URL | VARCHAR2 | (2000) | Relationship's uniform resource locator | |
REL_EMAIL_ADDRESS | VARCHAR2 | (2000) | 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 Relationship's Party identifier | ||
PARTY_REL_SUBJECT_ID | NUMBER | (15) | Party Relationship's ID of the subject in the relationship | |
PARTY_REL_SUBJECT_TYPE | VARCHAR2 | (30) | Party Relationship's subject type can only be Person, Organization, Group or Relationship. | |
PARTY_REL_SUBJECT_TABLE_NAME | VARCHAR2 | (30) | The party type can only be Person, Organization, Group or Relationship. | |
PARTY_REL_OBJECT_ID | NUMBER | (15) | Party Relationship's ID of the object in the relationship | |
PARTY_REL_OBJECT_TYPE | VARCHAR2 | (30) | Party Relationship's object type can only be Person, Organization, Group or Relationship. | |
PARTY_REL_OBJECT_TABLE_NAME | VARCHAR2 | (30) | Party Relationship's object table name | |
PARTY_REL_RELATIONSHIP_CODE | VARCHAR2 | (30) | Party Relationship's relationship code | |
PARTY_REL_DIRECTIONAL_FLAG | VARCHAR2 | (1) | Party Relationship's Directional flag, Y if this is a directional relationship, N otherwise | |
PARTY_REL_START_DATE | DATE | Party Relationship's date relationship begins | ||
PARTY_REL_END_DATE | DATE | Party Relationship's date relationship ends | ||
PARTY_REL_STATUS | VARCHAR2 | (1) | Party relationship status flag | |
PARTY_REL_RELATIONSHIP_TYPE | VARCHAR2 | (30) | Lookup: party_relationship_type. | |
PARTY_REL_OBJ_VER_NUMBER | NUMBER | Party Relationship's Object Version Number | ||
LKUP_MEANING | VARCHAR2 | (80) | QuickCode meaning | |
TERI_TERRITORY_SHORT_NAME | VARCHAR2 | (80) | Relationship's short name that stands for the territory |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SUB_PARTY_ID
, SUB_PARTY_NUMBER
, SUB_PARTY_NAME
, SUB_PARTY_TYPE
, SUB_OBJ_VER_NUMBER
, 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_OBJ_VER_NUMBER
, 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_URL
, REL_EMAIL_ADDRESS
, 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_OBJ_VER_NUMBER
, LKUP_MEANING
, TERI_TERRITORY_SHORT_NAME
FROM APPS.CSC_HZ_PARTIES_CONT_INFO_V;
APPS.CSC_HZ_PARTIES_CONT_INFO_V is not referenced by any database object
|
|
|