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

Object Details

Object Name:	HRBV_CONTACT_RELATIONSHIP
Object Type:	VIEW
Owner:	APPS
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

A Business Intelligence System view

Shared HRMS base view on PER_CONTACT_RELATIONSHIPS for use in Discoverer shared HRMS end user layer

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMMENTS	CLOB	(4000)		General remark.
DATE_START	DATE			The start date of the relationship.
DATE_END	DATE			The date the relationship ended.
SEQUENCE_NUMBER	NUMBER	(9)		The unique sequence number for the relationship used to identify contacts with a third party organization.
PRIMARY_CONTACT	VARCHAR2	(4000)
CONTACT_TYPE	VARCHAR2	(4000)
DEPENDENT_FLAG	VARCHAR2	(4000)
THIRD_PARTY_PAY	VARCHAR2	(4000)
BENEFICIARY	VARCHAR2	(4000)
BOND_HOLDER	VARCHAR2	(4000)
PERSONAL_FLAG	VARCHAR2	(4000)
RLTD_PER_RSDS_W_DSGNTR_FLAG	VARCHAR2	(4000)
PRIMARY_CONTACT_FLAG_CODE	VARCHAR2	(30)
CONTACT_TYPE_CODE	VARCHAR2	(30)	Yes
DEPENDENT_FLAG_CODE	VARCHAR2	(30)
THIRD_PARTY_PAY_FLAG_CODE	VARCHAR2	(30)
BENEFICIARY_FLAG_CODE	VARCHAR2	(30)
BONDHOLDER_FLAG_CODE	VARCHAR2	(30)
PERSONAL_FLAG_CODE	VARCHAR2	(30)
RD_P_RSDS_W_DSR_FLAG_CODE	VARCHAR2	(30)
CONT_INFORMATION_CATEGORY	VARCHAR2	(30)
CONT_INFORMATION1	VARCHAR2	(150)
CONT_INFORMATION2	VARCHAR2	(150)
CONT_INFORMATION3	VARCHAR2	(150)
CONT_INFORMATION4	VARCHAR2	(150)
CONT_INFORMATION5	VARCHAR2	(150)
CONT_INFORMATION6	VARCHAR2	(150)
CONT_INFORMATION7	VARCHAR2	(150)
CONT_INFORMATION8	VARCHAR2	(150)
CONT_INFORMATION9	VARCHAR2	(150)
CONT_INFORMATION10	VARCHAR2	(150)
CONT_INFORMATION11	VARCHAR2	(150)
CONT_INFORMATION12	VARCHAR2	(150)
CONT_INFORMATION13	VARCHAR2	(150)
CONT_INFORMATION14	VARCHAR2	(150)
CONT_INFORMATION15	VARCHAR2	(150)
CONT_INFORMATION16	VARCHAR2	(150)
CONT_INFORMATION17	VARCHAR2	(150)
CONT_INFORMATION18	VARCHAR2	(150)
CONT_INFORMATION19	VARCHAR2	(150)
CONT_INFORMATION20	VARCHAR2	(150)
_DF:ACRD	CHAR	(24)
LEGISLATION_CODE	VARCHAR2	(4000)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
CONTACT_PERSON_ID	NUMBER	(10)	Yes
CONTACT_RELATIONSHIP_ID	NUMBER	(15)	Yes
PERSON_ID	NUMBER	(10)	Yes
START_LIFE_REASON_ID	NUMBER	(15)
END_LIFE_REASON_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
BG_SECURITY_FLAG_CODE	CHAR	(1)

Query Text

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


SELECT COMMENTS
,      DATE_START
,      DATE_END
,      SEQUENCE_NUMBER
,      PRIMARY_CONTACT
,      CONTACT_TYPE
,      DEPENDENT_FLAG
,      THIRD_PARTY_PAY
,      BENEFICIARY
,      BOND_HOLDER
,      PERSONAL_FLAG
,      RLTD_PER_RSDS_W_DSGNTR_FLAG
,      PRIMARY_CONTACT_FLAG_CODE
,      CONTACT_TYPE_CODE
,      DEPENDENT_FLAG_CODE
,      THIRD_PARTY_PAY_FLAG_CODE
,      BENEFICIARY_FLAG_CODE
,      BONDHOLDER_FLAG_CODE
,      PERSONAL_FLAG_CODE
,      RD_P_RSDS_W_DSR_FLAG_CODE
,      CONT_INFORMATION_CATEGORY
,      CONT_INFORMATION1
,      CONT_INFORMATION2
,      CONT_INFORMATION3
,      CONT_INFORMATION4
,      CONT_INFORMATION5
,      CONT_INFORMATION6
,      CONT_INFORMATION7
,      CONT_INFORMATION8
,      CONT_INFORMATION9
,      CONT_INFORMATION10
,      CONT_INFORMATION11
,      CONT_INFORMATION12
,      CONT_INFORMATION13
,      CONT_INFORMATION14
,      CONT_INFORMATION15
,      CONT_INFORMATION16
,      CONT_INFORMATION17
,      CONT_INFORMATION18
,      CONT_INFORMATION19
,      CONT_INFORMATION20
,      _DF:ACRD
,      LEGISLATION_CODE
,      BUSINESS_GROUP_ID
,      CONTACT_PERSON_ID
,      CONTACT_RELATIONSHIP_ID
,      PERSON_ID
,      START_LIFE_REASON_ID
,      END_LIFE_REASON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_CONTACT_RELATIONSHIP;