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


VIEW: APPS.PER_VACANCIES_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

VACANCY_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
POSITION_ID NUMBER (15)

POSITION_NAME VARCHAR2 (4000)

JOB_ID NUMBER (15)

JOB_NAME VARCHAR2 (700)

GRADE_ID NUMBER (15)

GRADE_NAME VARCHAR2 (240)

ORGANIZATION_ID NUMBER (15)

ORGANIZATION_NAME VARCHAR2 (240)

REQUISITION_ID NUMBER (15) Yes
PEOPLE_GROUP_ID NUMBER (15)

LOCATION_ID NUMBER (15)

LOCATION VARCHAR2 (60)

RECRUITER_ID NUMBER (10)

RECRUITER_NAME VARCHAR2 (240)

RECRUITER_NUMBER VARCHAR2 (30)

DATE_FROM DATE
Yes
NAME VARCHAR2 (30) Yes
COMMENTS CLOB (4000)

DATE_TO DATE


DESCRIPTION VARCHAR2 (80)

VACANCY_CATEGORY VARCHAR2 (80)
NUMBER_OF_OPENINGS NUMBER (5)

STATUS VARCHAR2 (30)

STATUS_MEANING VARCHAR2 (80)

BUDGET_MEASUREMENT_TYPE VARCHAR2 (30)
BUDGET_MEASUREMENT_MEANING VARCHAR2 (80)
BUDGET_MEASUREMENT_VALUE NUMBER (22)
REQUEST_ID NUMBER (15)

PROGRAM_APPLICATION_ID NUMBER (15)

PROGRAM_ID NUMBER (15)

PROGRAM_UPDATE_DATE DATE


ATTRIBUTE_CATEGORY VARCHAR2 (30)

ATTRIBUTE1 VARCHAR2 (150)

ATTRIBUTE2 VARCHAR2 (150)

ATTRIBUTE3 VARCHAR2 (150)

ATTRIBUTE4 VARCHAR2 (150)

ATTRIBUTE5 VARCHAR2 (150)

ATTRIBUTE6 VARCHAR2 (150)

ATTRIBUTE7 VARCHAR2 (150)

ATTRIBUTE8 VARCHAR2 (150)

ATTRIBUTE9 VARCHAR2 (150)

ATTRIBUTE10 VARCHAR2 (150)

ATTRIBUTE11 VARCHAR2 (150)

ATTRIBUTE12 VARCHAR2 (150)

ATTRIBUTE13 VARCHAR2 (150)

ATTRIBUTE14 VARCHAR2 (150)

ATTRIBUTE15 VARCHAR2 (150)

ATTRIBUTE16 VARCHAR2 (150)

ATTRIBUTE17 VARCHAR2 (150)

ATTRIBUTE18 VARCHAR2 (150)

ATTRIBUTE19 VARCHAR2 (150)

ATTRIBUTE20 VARCHAR2 (150)

LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER (15)

LAST_UPDATE_LOGIN NUMBER (15)

CREATED_BY NUMBER (15)

CREATION_DATE DATE


D_VACANCY_CATEGORY VARCHAR2 (80)
Query Text

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


SELECT ROW_ID
,      VACANCY_ID
,      BUSINESS_GROUP_ID
,      POSITION_ID
,      POSITION_NAME
,      JOB_ID
,      JOB_NAME
,      GRADE_ID
,      GRADE_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      REQUISITION_ID
,      PEOPLE_GROUP_ID
,      LOCATION_ID
,      LOCATION
,      RECRUITER_ID
,      RECRUITER_NAME
,      RECRUITER_NUMBER
,      DATE_FROM
,      NAME
,      COMMENTS
,      DATE_TO
,      DESCRIPTION
,      VACANCY_CATEGORY
,      NUMBER_OF_OPENINGS
,      STATUS
,      STATUS_MEANING
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_MEANING
,      BUDGET_MEASUREMENT_VALUE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      D_VACANCY_CATEGORY
FROM APPS.PER_VACANCIES_V;

Dependencies

[top of page]

APPS.PER_VACANCIES_V references the following:

SchemaAPPS
SynonymFND_SESSIONS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_API - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
ViewHR_LOOKUPS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_PEOPLE_F
SynonymPER_GRADES
SynonymPER_GRADES_TL
SynonymPER_JOBS
SynonymPER_JOBS_TL
ViewPER_VACANCIES

APPS.PER_VACANCIES_V is not referenced by any database object