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

Object Details

Object Name:	IGS_PE_HZ_REL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PE_HZ_REL_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
ROW_ID	ROWID	(10)		Unique identifier of each record in the database
PARTY_ID	NUMBER	(15)		Unique identifier of the party
RELATIONSHIP_ID	NUMBER	(15)	Yes	Unique identifier of the relationship of a person
SUBJECT_ID	NUMBER	(15)	Yes	Person identifier for whom the relationship is created
OBJECT_ID	NUMBER	(15)	Yes	Person identifier who is related to subject identifier
OBJECT_ID_NUMBER	VARCHAR2	(30)	Yes	Person number who is related to subject identifier
PARTY_RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	Type of the relationship
PARTY_RELATIONSHIP_TYP_MEANING	VARCHAR2	(80)	Yes	Meaning of the relationship type
RELATIONSHIP_CODE	VARCHAR2	(30)	Yes	Relationship Code
DIRECTIONAL_FLAG	VARCHAR2	(1)	Yes	Flag which holds the direction of relationship
FULL_NAME	VARCHAR2	(450)		Full Name of the related party (for Person)
PRIMARY	VARCHAR2	(1)		Indicator to indicate whether the Record is Primary
SECONDARY	VARCHAR2	(1)		Indicator to indicate whether the Record is Secondary
JOINT_SALUTATION	VARCHAR2	(1000)		Salutation to be used during letter generation.
REP_FACULTY	VARCHAR2	(1)		Faculty Information of the Relation reported by related Person
REP_STAFF	VARCHAR2	(1)		Staff Information of the Relation reported by related Person
REP_STUDENT	VARCHAR2	(1)		Student Information of the Relation reported by related Person
REP_ALUMNI	VARCHAR2	(1)		Alumni Information of the Relation reported by related Person
START_DATE	DATE		Yes	Date from that the relationship is effective
END_DATE	DATE			End date after that the relationship is not effective
NEXT_TO_KIN	VARCHAR2	(1)		Column to store Next Of Kin
COMMENTS	VARCHAR2	(240)		Description of the relationship
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes	Content source type of the relationship
STATUS	VARCHAR2	(1)	Yes	Status of the relationship
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard attribute column, describing Flex field
ATTRIBUTE1	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE2	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE3	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE4	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE5	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE6	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE7	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE8	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE9	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE10	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE11	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE12	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE13	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE14	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE15	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE16	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE17	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE18	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE19	VARCHAR2	(150)		Standard attribute column, describing Flex field
ATTRIBUTE20	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Standard attribute column, describing Flex field
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Standard attribute column, describing Flex field
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PREFIX	VARCHAR2	(30)		Prefix
FIRST_NAME	VARCHAR2	(150)		First Name
MIDDLE_NAME	VARCHAR2	(60)		Middle Name
LAST_NAME	VARCHAR2	(150)		Last Name
SUFFIX	VARCHAR2	(30)		Suffix
DATE_OF_BIRTH	DATE			Date of Birth
GENDER	VARCHAR2	(30)		Gender
PERSON_TITLE	VARCHAR2	(60)		Person Title
KNOWN_AS	VARCHAR2	(240)		Known As
MARITAL_STATUS	VARCHAR2	(30)		Marital Status
HP_OVN	NUMBER			Hz Parties Object Version Number
EMERGENCY_CONTACT_FLAG	VARCHAR2	(1)		Flag indicating whether the person is an emergency contact
SUBJECT_TYPE	VARCHAR2	(30)	Yes	Subject Type
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object Type
REL_START_DATE	DATE		Yes	Start Date of the Relationship
REL_END_DATE	DATE			End Date of the Relationship
DECEASED_IND	VARCHAR2	(4000)		Deceased Indicator
JOINT_MAILING	CHAR	(1)		Joint Mailing

Query Text

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


SELECT ROW_ID
,      PARTY_ID
,      RELATIONSHIP_ID
,      SUBJECT_ID
,      OBJECT_ID
,      OBJECT_ID_NUMBER
,      PARTY_RELATIONSHIP_TYPE
,      PARTY_RELATIONSHIP_TYP_MEANING
,      RELATIONSHIP_CODE
,      DIRECTIONAL_FLAG
,      FULL_NAME
,      PRIMARY
,      SECONDARY
,      JOINT_SALUTATION
,      REP_FACULTY
,      REP_STAFF
,      REP_STUDENT
,      REP_ALUMNI
,      START_DATE
,      END_DATE
,      NEXT_TO_KIN
,      COMMENTS
,      CONTENT_SOURCE_TYPE
,      STATUS
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PREFIX
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      SUFFIX
,      DATE_OF_BIRTH
,      GENDER
,      PERSON_TITLE
,      KNOWN_AS
,      MARITAL_STATUS
,      HP_OVN
,      EMERGENCY_CONTACT_FLAG
,      SUBJECT_TYPE
,      OBJECT_TYPE
,      REL_START_DATE
,      REL_END_DATE
,      DECEASED_IND
,      JOINT_MAILING
FROM APPS.IGS_PE_HZ_REL_V;

Dependencies

[top of page]

APPS.IGS_PE_HZ_REL_V references the following:

APPS: FND_LOOKUP_VALUES; HZ_PARTIES; HZ_PERSON_PROFILES; HZ_RELATIONSHIPS; IGS_PE_GEN_004 - show dependent code; IGS_PE_HZ_REL

APPS.IGS_PE_HZ_REL_V is referenced by following:

APPS: IGS_AD_SS_GEN_001 - show dependent code; IGS_SV_BATCH_PROCESS_PKG - show dependent code