[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_HIRES

Object Details

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

View Type

A Business Intelligence System view

This view shows hires into the enterprise, effective as of the employee's hire date, for every period of service served by the employee. Employee termination dates are also shown.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_CODE
,      HIRE_DATE
,      ASSIGNMENT_NUMBER
,      TERMINATION_DATE
,      EMPLOYEE_NUMBER
,      PERSON_TYPE
,      EMPLOYEE_PERSON_TYPE
,      USER_CONCAT_PERSON_TYPE
,      EMPLOYMENT_CATEGORY
,      ORGANIZATION_NAME
,      GRADE_NAME
,      JOB_NAME
,      POSITION_NAME
,      LOCATION_NAME
,      SYSTEM_PERSON_TYPE_CODE
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      ORGANIZATION_ID
,      PERSON_ID
,      POSITION_ID
,      PERSON_TYPE_ID
FROM APPS.HRFV_HIRES;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

HRI_BPL_PERSON_TYPE - show dependent code

HR_ALL_ORGANIZATION_UNITS_TL

HR_ALL_POSITIONS_F_TL

HR_API - show dependent code

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL_TL

HR_LOOKUPS

HR_SECURITY - show dependent code

PER_ALL_PEOPLE_F

PER_ASSIGNMENTS_F

PER_GRADES_TL

PER_JOBS_TL

PER_PERIODS_OF_SERVICE

PER_PERSON_TYPES

PER_PERSON_TYPES_TL

PER_PERSON_TYPE_USAGES_F

PUBLIC

HRFV_HIRES