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.CSC_HZ_PARTIES_SRCH_REL_V

Object Details

Object Name:	CSC_HZ_PARTIES_SRCH_REL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSC.CSC_HZ_PARTIES_SRCH_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	Comments
ROW_ID	ROWID	(10)	Row ID column
REL_PARTY_ID	NUMBER	(15)	Relationship's party identifier
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_OBJ_VER_NUMBER	NUMBER		Object's Object Version Number
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_STATUS	VARCHAR2	(1)	Object's party status flag.
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
OBJ_JGZZ_FISCAL_CODE	VARCHAR2	(20)	Taxpayer identification number. Used in Europe to identify customers. Also known as the fiscal code or NIF.
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_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_STATUS	VARCHAR2	(1)	Subject's party status flag.
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_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_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 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_OBJ_VER_NUMBER	NUMBER		Object Version Number 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
,      REL_PARTY_ID
,      OBJ_PARTY_ID
,      OBJ_PARTY_NUMBER
,      OBJ_PARTY_NAME
,      OBJ_PARTY_TYPE
,      OBJ_OBJ_VER_NUMBER
,      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_STATUS
,      OBJ_ORGANIZATION_NAME_PHONETIC
,      OBJ_PERSON_FIRST_NAME_PHONETIC
,      OBJ_PERSON_LAST_NAME_PHONETIC
,      OBJ_JGZZ_FISCAL_CODE
,      SUB_PARTY_ID
,      SUB_PARTY_NUMBER
,      SUB_PARTY_NAME
,      SUB_PARTY_TYPE
,      SUB_OBJ_VER_NUMBER
,      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_STATUS
,      SUB_ORGANIZATION_NAME_PHONETIC
,      SUB_PERSON_FIRST_NAME_PHONETIC
,      SUB_PERSON_LAST_NAME_PHONETIC
,      REL_PARTY_NUMBER
,      REL_PARTY_NAME
,      REL_PARTY_TYPE
,      REL_OBJ_VER_NUMBER
,      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
,      OBJ_TERI_TERRITORY_SHORT_NAME
FROM APPS.CSC_HZ_PARTIES_SRCH_REL_V;

Dependencies

[top of page]

APPS.CSC_HZ_PARTIES_SRCH_REL_V references the following:

APPS: AR_LOOKUPS; FND_TERRITORIES_TL; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.CSC_HZ_PARTIES_SRCH_REL_V is not referenced by any database object