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_JOB_APPLICATIONS

Object Details

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

View Type

A Business Intelligence System view

This view shows information about current applications, including applicants who have
been hired.

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes
PERSON_NAME	VARCHAR2	(240)
VACANCY_NAME	VARCHAR2	(30)
START_DATE	DATE		Yes
END_DATE	DATE
CURRENT_EMPLOYER	VARCHAR2	(30)
PROJECTED_HIRE_DATE	DATE
APPLICATION_STATUS	VARCHAR2	(4000)
NEW_APPLICANTS	NUMBER
INTERVIEW1	NUMBER
INTERVIEW2	NUMBER
TERMINATIONS	NUMBER
OFFERS	NUMBER
ACCEPTS	NUMBER
STILL_CURRENT_EMPLOYEE	NUMBER
HIRED	VARCHAR2	(4000)
HIRED_CODE	VARCHAR2	(1)
APPLICATION_TERMINATED	VARCHAR2	(4000)
CURRENT_APPLICANT_FLAG	VARCHAR2	(4000)
APPLICANT_NUMBER	VARCHAR2	(30)
RECRUITMENT_ACTIVITY_NAME	VARCHAR2	(30)
REFERRING_EMPLOYEE_NAME	VARCHAR2	(240)
REFERRING_EMPLOYEE_NUMBER	VARCHAR2	(30)
SOURCE_ORGANIZATION_NAME	VARCHAR2	(240)
SUPERVISOR_NAME	VARCHAR2	(240)
SUPERVISOR_NUMBER	VARCHAR2	(30)
TERMINATION_REASON	VARCHAR2	(4000)
RECRUITER_NAME	VARCHAR2	(240)
ORGANIZATION_NAME	VARCHAR2	(240)
POSITION_NAME	VARCHAR2	(240)
JOB_NAME	VARCHAR2	(700)
LOCATION_NAME	VARCHAR2	(60)
GRADE_NAME	VARCHAR2	(240)
PEOPLE_GROUP	VARCHAR2	(240)
_DF:ASG	CHAR	(27)
_DF:APPL	CHAR	(28)
APPLICATION_ID	NUMBER	(15)
ASSIGNMENT_ID	NUMBER	(10)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
GRADE_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)	Yes
PEOPLE_GROUP_ID	NUMBER	(15)
PERSON_ID	NUMBER	(10)	Yes
POSITION_ID	NUMBER	(15)
RECRUITER_ID	NUMBER	(10)
RECRUITMENT_ACTIVITY_ID	NUMBER	(15)
REFERRING_EMPLOYEE_ID	NUMBER	(10)
SUPERVISOR_ID	NUMBER	(10)
VACANCY_ID	NUMBER	(15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      VACANCY_NAME
,      START_DATE
,      END_DATE
,      CURRENT_EMPLOYER
,      PROJECTED_HIRE_DATE
,      APPLICATION_STATUS
,      NEW_APPLICANTS
,      INTERVIEW1
,      INTERVIEW2
,      TERMINATIONS
,      OFFERS
,      ACCEPTS
,      STILL_CURRENT_EMPLOYEE
,      HIRED
,      HIRED_CODE
,      APPLICATION_TERMINATED
,      CURRENT_APPLICANT_FLAG
,      APPLICANT_NUMBER
,      RECRUITMENT_ACTIVITY_NAME
,      REFERRING_EMPLOYEE_NAME
,      REFERRING_EMPLOYEE_NUMBER
,      SOURCE_ORGANIZATION_NAME
,      SUPERVISOR_NAME
,      SUPERVISOR_NUMBER
,      TERMINATION_REASON
,      RECRUITER_NAME
,      ORGANIZATION_NAME
,      POSITION_NAME
,      JOB_NAME
,      LOCATION_NAME
,      GRADE_NAME
,      PEOPLE_GROUP
,      _DF:ASG
,      _DF:APPL
,      APPLICATION_ID
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      PERSON_ID
,      POSITION_ID
,      RECRUITER_ID
,      RECRUITMENT_ACTIVITY_ID
,      REFERRING_EMPLOYEE_ID
,      SUPERVISOR_ID
,      VACANCY_ID
FROM APPS.HRFV_JOB_APPLICATIONS;

Dependencies

[top of page]

APPS.HRFV_JOB_APPLICATIONS references the following:

APPS: HRI_OLTP_VIEW_ASG_STATUS_TYPES - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_ALL_POSITIONS_F_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL_TL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PAY_PEOPLE_GROUPS; PER_ALL_ASSIGNMENTS_F; PER_ALL_VACANCIES; PER_APPLICATIONS; PER_ASSIGNMENTS_F; PER_ASSIGNMENT_STATUS_TYPES; PER_ASSIGNMENT_STATUS_TYPES_TL; PER_ASS_STATUS_TYPE_AMENDS; PER_ASS_STATUS_TYPE_AMENDS_TL; PER_GRADES_TL; PER_JOBS_TL; PER_PEOPLE_X; PER_PERIODS_OF_SERVICE; PER_RECRUITMENT_ACTIVITIES

APPS.HRFV_JOB_APPLICATIONS is not referenced by any database object