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

Object Details

Object Name:	IGSBV_FAMILY_RELATIONSHIPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSBV_FAMILY_RELATIONSHIPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity contains information about the family relationships of a person.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUBJECT_ID_NUMBER	VARCHAR2	(30)	Yes	Unique identification number of the subject person
OBJECT_ID_NUMBER	VARCHAR2	(30)	Yes	Unique identification number of the object person
_LA:RELATIONSHIP_CODE	CHAR	(65)		Relationship code
RELATIONSHIP_START_DATE	DATE		Yes	Start date for the relationship
RELATIONSHIP_END_DATE	DATE			End date for the relationship
PRIMARY	VARCHAR2	(1)		Indicator whether the relationship is primary
SECONDARY	VARCHAR2	(1)		Indicator whether the relationship is secondary
JOINT_SALUTATION	VARCHAR2	(1000)		Salutation to be used during letter generation
NEXT_TO_KIN	VARCHAR2	(1)		Next of Kin
REPORTED_FACULTY	VARCHAR2	(1)		Faculty Information of the relation reported by related person
REPORTED_STAFF	VARCHAR2	(1)		Staff Information of the relation reported by related person
REPORTED_STUDENT	VARCHAR2	(1)		Student information of the relation reported by related person
REPORTED_ALUMNI	VARCHAR2	(1)		Alumni information of the relation reported by related person
RELATIONSHIP_ID	NUMBER	(15)	Yes	Unique identifier for the relationship
DIRECTIONAL_FLAG	VARCHAR2	(1)	Yes	Indicates if this is a directional relationship, such as parent-to-child or headquarters-to-branch. F for a forward relationship and B for a backward relationship.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

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


SELECT SUBJECT_ID_NUMBER
,      OBJECT_ID_NUMBER
,      _LA:RELATIONSHIP_CODE
,      RELATIONSHIP_START_DATE
,      RELATIONSHIP_END_DATE
,      PRIMARY
,      SECONDARY
,      JOINT_SALUTATION
,      NEXT_TO_KIN
,      REPORTED_FACULTY
,      REPORTED_STAFF
,      REPORTED_STUDENT
,      REPORTED_ALUMNI
,      RELATIONSHIP_ID
,      DIRECTIONAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_FAMILY_RELATIONSHIPS;

Dependencies

[top of page]

APPS.IGSBV_FAMILY_RELATIONSHIPS references the following:

APPS: HZ_PARTIES; HZ_RELATIONSHIPS; IGS_PE_HZ_REL

APPS.IGSBV_FAMILY_RELATIONSHIPS is not referenced by any database object