[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_RECRUITMENT_ACTIVITIES

Object Details

Object Name:	HRFV_RECRUITMENT_ACTIVITIES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_RECRUITMENT_ACTIVITIES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows recruitment activities that have been run by your enterprise.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      RECRUITMENT_ACTIVITY_NAME
,      REC_ACTIVITY_DATE_START
,      REC_ACTIVITY_DATE_END
,      REC_ACTIVITY_DATE_CLOSING
,      PLANNED_COST
,      ACTUAL_COST
,      CURRENCY_CODE
,      EXTERNAL_CONTACT_NAME
,      EXT_CONTACT_TELEPHONE_NUMBER
,      INTERNAL_CONTACT_NAME
,      INT_CONTACT_EMPLOYEE_NUMBER
,      RECRUITMENT_ACTIVITY_TYPE
,      COORDINATING_ORGANIZATION
,      INTERNAL_POSTING
,      EXTERNAL_POSTING
,      _DF
,      BUSINESS_GROUP_ID
,      COORDINATING_ORGANIZATION_ID
,      INTERNAL_CONTACT_ID
,      RECRUITMENT_ACTIVITY_ID
,      POSTING_CONTENT_ID
,      SITE_NAME
FROM APPS.HRFV_RECRUITMENT_ACTIVITIES;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

IRC_ALL_RECRUITING_SITES_TL

PER_PEOPLE_F

PER_RECRUITMENT_ACTIVITIES

PUBLIC

HRFV_RECRUITMENT_ACTIVITIES