DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRFV_VACANCIES

Object Details
Object Name: HRFV_VACANCIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_VACANCIES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows recruitment requisitions and vacancies that have been created for the enterprise.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240)

VACANCY_NAME VARCHAR2 (30) Yes
DESCRIPTION VARCHAR2 (80)

VACANCY_STATUS VARCHAR2 (4000)

NUMBER_OF_OPENINGS NUMBER (5)

BUDGET_MEASUREMENT_TYPE VARCHAR2 (4000)
BUDGET_MEASUREMENT_VALUE NUMBER (22)
VACANCY_START_DATE DATE
Yes
VACANCY_END_DATE DATE


ORGANIZATION_NAME VARCHAR2 (240)

JOB_NAME VARCHAR2 (700)

POSITION_NAME VARCHAR2 (240)

GRADE_NAME VARCHAR2 (240)

PEOPLE_GROUP VARCHAR2 (240)

LOCATION_NAME VARCHAR2 (60)

REQUISITION_NAME VARCHAR2 (30) Yes
REQUISITION_START_DATE DATE
Yes
REQUISITION_END_DATE DATE


RAISED_BY VARCHAR2 (240)

RECRUITER_NAME VARCHAR2 (240)

_DF:VAC CHAR (25)

_DF:REQ CHAR (28)
BUSINESS_GROUP_ID NUMBER (15) Yes
GRADE_ID NUMBER (15)

JOB_ID NUMBER (15)

LOCATION_ID NUMBER (15)

ORGANIZATION_ID NUMBER


PEOPLE_GROUP_ID NUMBER (15)

POSITION_ID NUMBER (15)

RAISER_ID NUMBER (10)

RECRUITER_ID NUMBER (10)

REQUISITION_ID NUMBER (15) Yes
VACANCY_ID NUMBER (15) Yes
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      VACANCY_NAME
,      DESCRIPTION
,      VACANCY_STATUS
,      NUMBER_OF_OPENINGS
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_VALUE
,      VACANCY_START_DATE
,      VACANCY_END_DATE
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      GRADE_NAME
,      PEOPLE_GROUP
,      LOCATION_NAME
,      REQUISITION_NAME
,      REQUISITION_START_DATE
,      REQUISITION_END_DATE
,      RAISED_BY
,      RECRUITER_NAME
,      _DF:VAC
,      _DF:REQ
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      POSITION_ID
,      RAISER_ID
,      RECRUITER_ID
,      REQUISITION_ID
,      VACANCY_ID
FROM APPS.HRFV_VACANCIES;

Dependencies

[top of page]

APPS.HRFV_VACANCIES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_PEOPLE_GROUPS
SynonymPER_ALL_PEOPLE_F
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL
SynonymPER_REQUISITIONS
ViewPER_VACANCIES

APPS.HRFV_VACANCIES is not referenced by any database object