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

Object Details

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

View Type

A Business Intelligence System view

Shows the consideration history of a iRecruitment candidate being considered for a vacancy

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
CANDIDATE_NAME	VARCHAR2	(450)
EMAIL_ADDRESS	VARCHAR2	(240)
VACANCY_NAME	VARCHAR2	(30)	Yes
CONSIDERATION_STATUS	VARCHAR2	(4000)
CONSIDER_STATUS_TIMESTAMP	DATE		Yes
VACANCY_DATE_FROM	DATE		Yes
VACANCY_DATE_TO	DATE
VACANCY_DATE_TO_NN	DATE
BUDGET_MEASUREMENT_TYPE	VARCHAR2	(30)
BUDGET_MEASUREMENT_VALUE	NUMBER	(22)
CONSIDERATION_STATUS_CODE	VARCHAR2	(30)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
ORGANIZATION_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)
REQUISITION_ID	NUMBER	(15)	Yes
PEOPLE_GROUP_ID	NUMBER	(15)
RECRUITER_ID	NUMBER	(10)
VACANCY_ID	NUMBER	(15)	Yes
MANAGER_ID	NUMBER	(15)
PARTY_ID	NUMBER	(15)	Yes
USER_ID	NUMBER	(15)
CUSTOMER_ID	NUMBER	(15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      CANDIDATE_NAME
,      EMAIL_ADDRESS
,      VACANCY_NAME
,      CONSIDERATION_STATUS
,      CONSIDER_STATUS_TIMESTAMP
,      VACANCY_DATE_FROM
,      VACANCY_DATE_TO
,      VACANCY_DATE_TO_NN
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_VALUE
,      CONSIDERATION_STATUS_CODE
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      JOB_ID
,      GRADE_ID
,      POSITION_ID
,      LOCATION_ID
,      REQUISITION_ID
,      PEOPLE_GROUP_ID
,      RECRUITER_ID
,      VACANCY_ID
,      MANAGER_ID
,      PARTY_ID
,      USER_ID
,      CUSTOMER_ID
FROM APPS.IRCFV_VACANCY_CONSIDERATION;

Dependencies

[top of page]

APPS.IRCFV_VACANCY_CONSIDERATION references the following:

APPS: FND_USER; HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; HZ_PERSON_PROFILES; IRC_NOTIFICATION_PREFERENCES; IRC_VACANCY_CONSIDERATIONS; PER_VACANCIES

APPS.IRCFV_VACANCY_CONSIDERATION is not referenced by any database object