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

Object Details

Object Name:	HR_PAY_INTERFACE_CONTACTS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
PERSON_ID	NUMBER	(10)	Yes
CONTACT_PERSON_ID	NUMBER	(10)	Yes
CONTACT_TYPE_LOOKUP_CODE	VARCHAR2	(30)	Yes
CONTACT_TYPE	VARCHAR2	(80)	Yes
PRIMARY_CONTACT_FLAG	VARCHAR2	(30)
DEPENDENT_FLAG	VARCHAR2	(30)
CONTACT_LAST_NAME	VARCHAR2	(150)	Yes
CONTACT_FIRST_NAME	VARCHAR2	(150)
CONTACT_MIDDLE_NAMES	VARCHAR2	(60)
CONTACT_FULL_NAME	VARCHAR2	(240)
CONTACT_SUFFIX	VARCHAR2	(30)
CONTACT_TITLE	VARCHAR2	(30)
CONTACT_EMPLOYEE_NUMBER	VARCHAR2	(30)
CONTACT_DATE_OF_BIRTH	DATE
CONT_ATTRIBUTE1	VARCHAR2	(150)
CONT_ATTRIBUTE2	VARCHAR2	(150)
CONT_ATTRIBUTE3	VARCHAR2	(150)
CONT_ATTRIBUTE4	VARCHAR2	(150)
CONT_ATTRIBUTE5	VARCHAR2	(150)
CONT_ATTRIBUTE6	VARCHAR2	(150)
CONT_ATTRIBUTE7	VARCHAR2	(150)
CONT_ATTRIBUTE8	VARCHAR2	(150)
CONT_ATTRIBUTE9	VARCHAR2	(150)
CONT_ATTRIBUTE10	VARCHAR2	(150)
CONT_ATTRIBUTE11	VARCHAR2	(150)
CONT_ATTRIBUTE12	VARCHAR2	(150)
CONT_ATTRIBUTE13	VARCHAR2	(150)
CONT_ATTRIBUTE14	VARCHAR2	(150)
CONT_ATTRIBUTE15	VARCHAR2	(150)
CONT_ATTRIBUTE16	VARCHAR2	(150)
CONT_ATTRIBUTE17	VARCHAR2	(150)
CONT_ATTRIBUTE18	VARCHAR2	(150)
CONT_ATTRIBUTE19	VARCHAR2	(150)
CONT_ATTRIBUTE20	VARCHAR2	(150)
PER_LAST_UPDATE_DATE	DATE
CON_LAST_UPDATE_DATE	DATE
GREATEST_LAST_UPDATE_DATE	DATE

Query Text

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


SELECT BUSINESS_GROUP_ID
,      PERSON_ID
,      CONTACT_PERSON_ID
,      CONTACT_TYPE_LOOKUP_CODE
,      CONTACT_TYPE
,      PRIMARY_CONTACT_FLAG
,      DEPENDENT_FLAG
,      CONTACT_LAST_NAME
,      CONTACT_FIRST_NAME
,      CONTACT_MIDDLE_NAMES
,      CONTACT_FULL_NAME
,      CONTACT_SUFFIX
,      CONTACT_TITLE
,      CONTACT_EMPLOYEE_NUMBER
,      CONTACT_DATE_OF_BIRTH
,      CONT_ATTRIBUTE1
,      CONT_ATTRIBUTE2
,      CONT_ATTRIBUTE3
,      CONT_ATTRIBUTE4
,      CONT_ATTRIBUTE5
,      CONT_ATTRIBUTE6
,      CONT_ATTRIBUTE7
,      CONT_ATTRIBUTE8
,      CONT_ATTRIBUTE9
,      CONT_ATTRIBUTE10
,      CONT_ATTRIBUTE11
,      CONT_ATTRIBUTE12
,      CONT_ATTRIBUTE13
,      CONT_ATTRIBUTE14
,      CONT_ATTRIBUTE15
,      CONT_ATTRIBUTE16
,      CONT_ATTRIBUTE17
,      CONT_ATTRIBUTE18
,      CONT_ATTRIBUTE19
,      CONT_ATTRIBUTE20
,      PER_LAST_UPDATE_DATE
,      CON_LAST_UPDATE_DATE
,      GREATEST_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_CONTACTS_V;

Dependencies

[top of page]

APPS.HR_PAY_INTERFACE_CONTACTS_V references the following:

APPS: HR_API - show dependent code; HR_LOOKUPS; HR_PAY_INTERFACE_PKG - show dependent code; PER_ALL_PEOPLE_F; PER_CONTACT_RELATIONSHIPS

APPS.HR_PAY_INTERFACE_CONTACTS_V is not referenced by any database object