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

VIEW: APPS.HRI_MB_VACANCY_V

Object Details
Object Name: HRI_MB_VACANCY_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Base Metric for Vacancy. Allows real time (database view) reporting of vacancy details.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TOTAL_DAYS_OPEN NUMBER

NUMBER_OF_OPENINGS NUMBER (5)
VACANCY_CLOSED_INDICATOR NUMBER

DATE_FROM DATE
Yes
DATE_TO DATE

BUDGET_MEASUREMENT_VALUE NUMBER (22)
VACANCY_CATEGORY_CODE VARCHAR2 (80)
BUDGET_MEASUREMENT_TYPE_CODE VARCHAR2 (30)
VACANCY_STATUS_CODE VARCHAR2 (30)
SECURITY_METHOD_CODE VARCHAR2 (30)
VACANCY_NAME VARCHAR2 (30) Yes
LAST_UPDATED DATE

BUSINESS_GROUP_ID NUMBER (15) Yes
GRADE_ID NUMBER

JOB_ID NUMBER

LOCATION_ID NUMBER

MANAGER_ID NUMBER

FK_MANAGER_ID NUMBER (15)
ORGANIZATION_ID NUMBER

FK_ORGANIZATION_ID NUMBER (15)
PEOPLE_GROUP_ID NUMBER

POSITION_ID NUMBER

RECRUITER_ID NUMBER

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

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


SELECT TOTAL_DAYS_OPEN
,      NUMBER_OF_OPENINGS
,      VACANCY_CLOSED_INDICATOR
,      DATE_FROM
,      DATE_TO
,      BUDGET_MEASUREMENT_VALUE
,      VACANCY_CATEGORY_CODE
,      BUDGET_MEASUREMENT_TYPE_CODE
,      VACANCY_STATUS_CODE
,      SECURITY_METHOD_CODE
,      VACANCY_NAME
,      LAST_UPDATED
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      MANAGER_ID
,      FK_MANAGER_ID
,      ORGANIZATION_ID
,      FK_ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      POSITION_ID
,      RECRUITER_ID
,      REQUISITION_ID
,      VACANCY_ID
FROM APPS.HRI_MB_VACANCY_V;

Dependencies

[top of page]

APPS.HRI_MB_VACANCY_V references the following:

SchemaAPPS
SynonymPER_ALL_VACANCIES
APPS.HRI_MB_VACANCY_V is referenced by following:

SchemaAPPS
ViewHRI_MD_REC_VAC_CLSD_STTS_V