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

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
RECRUITMENT_ACTIVITY_NAME	VARCHAR2	(30)	Yes
REC_ACTIVITY_DATE_START	DATE		Yes
REC_ACTIVITY_DATE_END	DATE
REC_ACTIVITY_DATE_CLOSING	DATE
PLANNED_COST	NUMBER
ACTUAL_COST	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
EXTERNAL_CONTACT_NAME	VARCHAR2	(80)
EXT_CONTACT_TELEPHONE_NUMBER	VARCHAR2	(60)
INTERNAL_CONTACT_NAME	VARCHAR2	(240)
INT_CONTACT_EMPLOYEE_NUMBER	VARCHAR2	(30)
RECRUITMENT_ACTIVITY_TYPE	VARCHAR2	(4000)
COORDINATING_ORGANIZATION	VARCHAR2	(240)
INTERNAL_POSTING	VARCHAR2	(4000)
EXTERNAL_POSTING	VARCHAR2	(4000)
_DF	CHAR	(38)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
COORDINATING_ORGANIZATION_ID	NUMBER	(15)
INTERNAL_CONTACT_ID	NUMBER	(10)
RECRUITMENT_ACTIVITY_ID	NUMBER	(15)	Yes
POSTING_CONTENT_ID	NUMBER	(15)	Yes
SITE_NAME	VARCHAR2	(240)

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.HRFV_RECRUITMENT_ACTIVITIES references the following:

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

APPS.HRFV_RECRUITMENT_ACTIVITIES is not referenced by any database object