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

VIEW: HRI.HRI_MB_REC_VACANCY_CT#

Object Details
Object Name: HRI_MB_REC_VACANCY_CT#
Object Type: VIEW
Owner: HRI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIME_DAY_VAC_STRT_FK DATE

TIME_DAY_VAC_END_FK DATE

PER_PERSON_RECR_FK NUMBER

PER_PERSON_RMGR_FK NUMBER

ORG_ORGANZTN_FK NUMBER

GEO_LOCATION_FK NUMBER

JOB_JOB_FK NUMBER

GRD_GRADE_FK NUMBER

POS_POSITION_FK NUMBER

RVAC_VACNCY_FK NUMBER

NUMBER_OF_OPENINGS NUMBER

BUDGET_MEASUREMENT_VALUE NUMBER

VAC_STRT_DATE DATE

ADT_BUSINESS_GROUP_ID NUMBER

ADT_VACANCY_STATUS_CODE VARCHAR2 (30)
ADT_BUDGET_TYPE_CODE VARCHAR2 (30)
ADT_VACANCY_CATEGORY_CODE VARCHAR2 (80)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

PER_PERSON_RSED_FK NUMBER

PER_PERSON_MRGD_FK NUMBER

ORG_ORGANZTN_MRGD_FK NUMBER

Query Text

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


SELECT TIME_DAY_VAC_STRT_FK
,      TIME_DAY_VAC_END_FK
,      PER_PERSON_RECR_FK
,      PER_PERSON_RMGR_FK
,      ORG_ORGANZTN_FK
,      GEO_LOCATION_FK
,      JOB_JOB_FK
,      GRD_GRADE_FK
,      POS_POSITION_FK
,      RVAC_VACNCY_FK
,      NUMBER_OF_OPENINGS
,      BUDGET_MEASUREMENT_VALUE
,      VAC_STRT_DATE
,      ADT_BUSINESS_GROUP_ID
,      ADT_VACANCY_STATUS_CODE
,      ADT_BUDGET_TYPE_CODE
,      ADT_VACANCY_CATEGORY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      PER_PERSON_RSED_FK
,      PER_PERSON_MRGD_FK
,      ORG_ORGANZTN_MRGD_FK
FROM HRI.HRI_MB_REC_VACANCY_CT#;

Dependencies

[top of page]

HRI.HRI_MB_REC_VACANCY_CT# references the following:

SchemaHRI
TableHRI_MB_REC_VACANCY_CT
HRI.HRI_MB_REC_VACANCY_CT# is referenced by following:

SchemaAPPS
SynonymHRI_MB_REC_VACANCY_CT
TriggerHRI_MB_REC_VACANCY_CT_WHO