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

Object Details

Object Name:	CS_SR_HZ_RELATIONSHIPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_HZ_RELATIONSHIPS_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
REL_PARTY_ID	NUMBER	(15)	Yes	Related Party Identifier
REL_PARTY_NUMBER	VARCHAR2	(30)	Yes	Related Party Number
REL_PARTY_NAME	VARCHAR2	(360)	Yes	Related Party Name
REL_PARTY_TYPE	VARCHAR2	(30)	Yes	Related party type
REL_LAST_UPDATE_DATE	DATE		Yes	Last Update date
REL_PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Person firstname Adjunct of the related party.
REL_PERSON_FIRST_NAME	VARCHAR2	(150)		Person first name of the related party.
REL_PERSON_MIDDLE_NAME	VARCHAR2	(60)		Person middle name of the related party.
REL_PERSON_LAST_NAME	VARCHAR2	(150)		Person last name of the related party.
REL_PERSON_NAME_SUFFIX	VARCHAR2	(30)		Person name suffix of the related party.
REL_COUNTRY	VARCHAR2	(60)		Country of the related party.
REL_ADDRESS1	VARCHAR2	(240)		Address of the related party.
REL_ADDRESS2	VARCHAR2	(240)		Address of the related party.
REL_ADDRESS3	VARCHAR2	(240)		Address of the related party.
REL_ADDRESS4	VARCHAR2	(240)		Address of the related party.
REL_CITY	VARCHAR2	(60)		City of the related party.
REL_POSTAL_CODE	VARCHAR2	(60)		Postal code of the related party.
REL_STATE	VARCHAR2	(60)		State of the related party.
REL_PROVINCE	VARCHAR2	(60)		Province of the related party.
REL_STATUS	VARCHAR2	(1)	Yes	Status of the related party.
REL_EMAIL_ADDRESS	VARCHAR2	(2000)		Email address of the related party.
REL_ADDRESS	VARCHAR2	(963)		Address of the related party.
REL_LANGUAGE_NAME	VARCHAR2	(4)		Language of the related party.
REL_COUNTY	VARCHAR2	(60)		County of the related party.
SUB_PARTY_ID	NUMBER	(15)	Yes	Subject Party identifier.
SUB_PARTY_NUMBER	VARCHAR2	(30)	Yes	Subject Party number.
SUB_PARTY_NAME	VARCHAR2	(360)	Yes	Subject Party name.
SUB_PARTY_TYPE	VARCHAR2	(30)	Yes	Subject Party type.
SUB_LAST_UPDATE_DATE	DATE		Yes	Last update date.
SUB_PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Person firstname Adjunct of the subject party.
SUB_PERSON_FIRST_NAME	VARCHAR2	(150)		Person first name of the subject party.
SUB_PERSON_MIDDLE_NAME	VARCHAR2	(60)		Person middle name of the subject party.
SUB_PERSON_LAST_NAME	VARCHAR2	(150)		Person first name of the subject party.
SUB_PERSON_NAME_SUFFIX	VARCHAR2	(30)		Person name suffix of the subject party.
SUB_COUNTRY	VARCHAR2	(60)		Subject person country.
SUB_ADDRESS1	VARCHAR2	(240)		Subject person address.
SUB_ADDRESS2	VARCHAR2	(240)		Subject person address.
SUB_ADDRESS3	VARCHAR2	(240)		Subject person address.
SUB_ADDRESS4	VARCHAR2	(240)		Subject person address.
SUB_CITY	VARCHAR2	(60)		Subject person city.
SUB_POSTAL_CODE	VARCHAR2	(60)		Subject person postal code.
SUB_STATE	VARCHAR2	(60)		Subject person state.
SUB_PROVINCE	VARCHAR2	(60)		Subject person province.
SUB_STATUS	VARCHAR2	(1)	Yes	Subject person status.
SUB_EMAIL_ADDRESS	VARCHAR2	(2000)		Subject person email address.
SUB_ADDRESS	VARCHAR2	(963)		Subject person address.
SUB_LANGUAGE_NAME	VARCHAR2	(4)		Subject person language.
SUB_COUNTY	VARCHAR2	(60)		Subject person county.
OBJ_PARTY_ID	NUMBER	(15)	Yes	Object Party identifier.
OBJ_PARTY_NUMBER	VARCHAR2	(30)	Yes	Object Party number.
OBJ_PARTY_NAME	VARCHAR2	(360)	Yes	Object Party name.
OBJ_PARTY_TYPE	VARCHAR2	(30)	Yes	Object Party type.
OBJ_LAST_UPDATE_DATE	DATE		Yes	Last update date.
OBJ_PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Person first name Adjunct of the object party.
OBJ_PERSON_FIRST_NAME	VARCHAR2	(150)		Person first name of the object party.
OBJ_PERSON_MIDDLE_NAME	VARCHAR2	(60)		Person middle name of the object party.
OBJ_PERSON_LAST_NAME	VARCHAR2	(150)		Person last name of the object party.
OBJ_PERSON_NAME_SUFFIX	VARCHAR2	(30)		Person first name of the object party.
OBJ_COUNTRY	VARCHAR2	(60)		Object person country.
OBJ_ADDRESS1	VARCHAR2	(240)		Object person address.
OBJ_ADDRESS2	VARCHAR2	(240)		Object person address.
OBJ_ADDRESS3	VARCHAR2	(240)		Object person address.
OBJ_ADDRESS4	VARCHAR2	(240)		Object person address.
OBJ_CITY	VARCHAR2	(60)		Object person city.
OBJ_POSTAL_CODE	VARCHAR2	(60)		Object person postal code.
OBJ_STATE	VARCHAR2	(60)		Object person state.
OBJ_PROVINCE	VARCHAR2	(60)		Object person province.
OBJ_STATUS	VARCHAR2	(1)	Yes	Object person status.
OBJ_EMAIL_ADDRESS	VARCHAR2	(2000)		Object person email address.
OBJ_ADDRESS	VARCHAR2	(963)		Object person address.
OBJ_LANGUAGE_NAME	VARCHAR2	(4)		Object person language.
OBJ_COUNTY	VARCHAR2	(60)		Object person county.
PARTY_RELATIONSHIP_ID	NUMBER	(15)	Yes	Party relationship identifier.
PARTY_RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	party relationship type.
PARTY_RELATIONSHIP_MEANING	VARCHAR2	(80)	Yes	Party relationship meaning.
OBJ_KNOWN_AS	VARCHAR2	(240)		Object known as.

Query Text

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


SELECT REL_PARTY_ID
,      REL_PARTY_NUMBER
,      REL_PARTY_NAME
,      REL_PARTY_TYPE
,      REL_LAST_UPDATE_DATE
,      REL_PERSON_PRE_NAME_ADJUNCT
,      REL_PERSON_FIRST_NAME
,      REL_PERSON_MIDDLE_NAME
,      REL_PERSON_LAST_NAME
,      REL_PERSON_NAME_SUFFIX
,      REL_COUNTRY
,      REL_ADDRESS1
,      REL_ADDRESS2
,      REL_ADDRESS3
,      REL_ADDRESS4
,      REL_CITY
,      REL_POSTAL_CODE
,      REL_STATE
,      REL_PROVINCE
,      REL_STATUS
,      REL_EMAIL_ADDRESS
,      REL_ADDRESS
,      REL_LANGUAGE_NAME
,      REL_COUNTY
,      SUB_PARTY_ID
,      SUB_PARTY_NUMBER
,      SUB_PARTY_NAME
,      SUB_PARTY_TYPE
,      SUB_LAST_UPDATE_DATE
,      SUB_PERSON_PRE_NAME_ADJUNCT
,      SUB_PERSON_FIRST_NAME
,      SUB_PERSON_MIDDLE_NAME
,      SUB_PERSON_LAST_NAME
,      SUB_PERSON_NAME_SUFFIX
,      SUB_COUNTRY
,      SUB_ADDRESS1
,      SUB_ADDRESS2
,      SUB_ADDRESS3
,      SUB_ADDRESS4
,      SUB_CITY
,      SUB_POSTAL_CODE
,      SUB_STATE
,      SUB_PROVINCE
,      SUB_STATUS
,      SUB_EMAIL_ADDRESS
,      SUB_ADDRESS
,      SUB_LANGUAGE_NAME
,      SUB_COUNTY
,      OBJ_PARTY_ID
,      OBJ_PARTY_NUMBER
,      OBJ_PARTY_NAME
,      OBJ_PARTY_TYPE
,      OBJ_LAST_UPDATE_DATE
,      OBJ_PERSON_PRE_NAME_ADJUNCT
,      OBJ_PERSON_FIRST_NAME
,      OBJ_PERSON_MIDDLE_NAME
,      OBJ_PERSON_LAST_NAME
,      OBJ_PERSON_NAME_SUFFIX
,      OBJ_COUNTRY
,      OBJ_ADDRESS1
,      OBJ_ADDRESS2
,      OBJ_ADDRESS3
,      OBJ_ADDRESS4
,      OBJ_CITY
,      OBJ_POSTAL_CODE
,      OBJ_STATE
,      OBJ_PROVINCE
,      OBJ_STATUS
,      OBJ_EMAIL_ADDRESS
,      OBJ_ADDRESS
,      OBJ_LANGUAGE_NAME
,      OBJ_COUNTY
,      PARTY_RELATIONSHIP_ID
,      PARTY_RELATIONSHIP_TYPE
,      PARTY_RELATIONSHIP_MEANING
,      OBJ_KNOWN_AS
FROM APPS.CS_SR_HZ_RELATIONSHIPS_V;

Dependencies

[top of page]

APPS.CS_SR_HZ_RELATIONSHIPS_V references the following:

APPS: AR_LOOKUPS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.CS_SR_HZ_RELATIONSHIPS_V is not referenced by any database object