eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.HRI_OBI_MD_REC_VACANCY_V

Object Details

Object Name:	HRI_OBI_MD_REC_VACANCY_V
Object Type:	VIEW
Owner:	APPS
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_RCRT_FK	NUMBER
PER_PERSON_RMGR_FK	NUMBER
PER_PERSON_RSED_FK	NUMBER
PER_PERSON_MRGD_FK	NUMBER
ORG_ORGANZTN_FK	NUMBER
ORG_ORGANZTN_MRGD_FK	NUMBER
GEO_LOCATION_FK	NUMBER
JOB_JOB_FK	NUMBER
GRD_GRADE_FK	NUMBER
POS_POSITION_FK	NUMBER
RVAC_VACNCY_FK	NUMBER
VAC_OPEN_CNT	NUMBER
INIT_APPL_STG_CNT	NUMBER
ASMT_STG_CNT	NUMBER
OFFR_EXTD_STG_CNT	NUMBER
STRT_PNDG_STG_CNT	NUMBER
HIRE_PRE_POW1_CNT	NUMBER
APPL_IN_PROGRESS_CNT	NUMBER
APPL_STRT_EVNT_CNT	NUMBER
APPL_TERM_INIT_EVNT_CNT	NUMBER
APPL_TERM_VOL_INIT_EVNT_CNT	NUMBER
APPL_TERM_INVOL_INIT_EVNT_CNT	NUMBER
ASMT_STRT_EVNT_CNT	NUMBER
APPL_TERM_ASMT_EVNT_CNT	NUMBER
APPL_TERM_VOL_ASMT_EVNT_CNT	NUMBER
APPL_TERM_INVOL_ASMT_EVNT_CNT	NUMBER
OFFR_EXTD_EVNT_CNT	NUMBER
APPL_TERM_OFFR_EVNT_CNT	NUMBER
APPL_TERM_VOL_OFFR_EVNT_CNT	NUMBER
APPL_TERM_INVOL_OFFR_EVNT_CNT	NUMBER
OFFR_ACPT_EVNT_CNT	NUMBER
APPL_TERM_ACPT_EVNT_CNT	NUMBER
APPL_TERM_VOL_ACPT_EVNT_CNT	NUMBER
APPL_TERM_INVOL_ACPT_EVNT_CNT	NUMBER
APPL_TERM_EVNT_CNT	NUMBER
APPL_TERM_VOL_EVNT_CNT	NUMBER
APPL_TERM_INVOL_EVNT_CNT	NUMBER
HIRE_APPL_EVNT_CNT	NUMBER
POST_HIRE_POW1_END_EVNT_CNT	NUMBER
PRE_POW1_END_SPRTN_EVNT_CNT	NUMBER
VAC_TO_APPL_STRT_EVNT_DAYS	NUMBER
VAC_TO_ASMT_STRT_EVNT_DAYS	NUMBER
VAC_TO_OFFR_EXTD_EVNT_DAYS	NUMBER
VAC_TO_OFFR_ACPT_EVNT_DAYS	NUMBER
VAC_TO_FILL_EVNT_DAYS	NUMBER
VAC_TO_APPL_HIRE_EVNT_DAYS	NUMBER
FILL_TO_APPL_HIRE_EVNT_DAYS	NUMBER
VAC_TO_TERM_OFFR_EVNT_DAYS	NUMBER
VAC_TO_APPL_TERM_EVNT_DAYS	NUMBER
APPL_TO_ASMT_STRT_EVNT_DAYS	NUMBER
APPL_TO_OFFR_EXTD_EVNT_DAYS	NUMBER
APPL_TO_OFFR_ACPT_EVNT_DAYS	NUMBER
APPL_TO_FILL_EVNT_DAYS	NUMBER
APPL_TO_APPL_HIRE_EVNT_DAYS	NUMBER
APPL_TO_TERM_OFFR_EVNT_DAYS	NUMBER
APPL_TO_APPL_TERM_EVNT_DAYS	NUMBER
OFFR_TO_TERM_VOL_EVNT_DAYS	NUMBER
OFFR_TO_TERM_INVOL_EVNT_DAYS	NUMBER
OFFR_TO_ACPT_EVNT_DAYS	NUMBER
ACPT_TO_TERM_VOL_EVNT_DAYS	NUMBER
ACPT_TO_TERM_INVOL_EVNT_DAYS	NUMBER
TOTAL_OPENINGS	NUMBER
FILLED_OPENINGS	NUMBER
TOTAL_HEADCOUNT	NUMBER
FILLED_HEADCOUNT	NUMBER
TOTAL_FTE	NUMBER
FILLED_FTE	NUMBER
TOTAL_MONEY	NUMBER
FILLED_MONEY	NUMBER
VAC_FILLED_IND	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_RCRT_FK
,      PER_PERSON_RMGR_FK
,      PER_PERSON_RSED_FK
,      PER_PERSON_MRGD_FK
,      ORG_ORGANZTN_FK
,      ORG_ORGANZTN_MRGD_FK
,      GEO_LOCATION_FK
,      JOB_JOB_FK
,      GRD_GRADE_FK
,      POS_POSITION_FK
,      RVAC_VACNCY_FK
,      VAC_OPEN_CNT
,      INIT_APPL_STG_CNT
,      ASMT_STG_CNT
,      OFFR_EXTD_STG_CNT
,      STRT_PNDG_STG_CNT
,      HIRE_PRE_POW1_CNT
,      APPL_IN_PROGRESS_CNT
,      APPL_STRT_EVNT_CNT
,      APPL_TERM_INIT_EVNT_CNT
,      APPL_TERM_VOL_INIT_EVNT_CNT
,      APPL_TERM_INVOL_INIT_EVNT_CNT
,      ASMT_STRT_EVNT_CNT
,      APPL_TERM_ASMT_EVNT_CNT
,      APPL_TERM_VOL_ASMT_EVNT_CNT
,      APPL_TERM_INVOL_ASMT_EVNT_CNT
,      OFFR_EXTD_EVNT_CNT
,      APPL_TERM_OFFR_EVNT_CNT
,      APPL_TERM_VOL_OFFR_EVNT_CNT
,      APPL_TERM_INVOL_OFFR_EVNT_CNT
,      OFFR_ACPT_EVNT_CNT
,      APPL_TERM_ACPT_EVNT_CNT
,      APPL_TERM_VOL_ACPT_EVNT_CNT
,      APPL_TERM_INVOL_ACPT_EVNT_CNT
,      APPL_TERM_EVNT_CNT
,      APPL_TERM_VOL_EVNT_CNT
,      APPL_TERM_INVOL_EVNT_CNT
,      HIRE_APPL_EVNT_CNT
,      POST_HIRE_POW1_END_EVNT_CNT
,      PRE_POW1_END_SPRTN_EVNT_CNT
,      VAC_TO_APPL_STRT_EVNT_DAYS
,      VAC_TO_ASMT_STRT_EVNT_DAYS
,      VAC_TO_OFFR_EXTD_EVNT_DAYS
,      VAC_TO_OFFR_ACPT_EVNT_DAYS
,      VAC_TO_FILL_EVNT_DAYS
,      VAC_TO_APPL_HIRE_EVNT_DAYS
,      FILL_TO_APPL_HIRE_EVNT_DAYS
,      VAC_TO_TERM_OFFR_EVNT_DAYS
,      VAC_TO_APPL_TERM_EVNT_DAYS
,      APPL_TO_ASMT_STRT_EVNT_DAYS
,      APPL_TO_OFFR_EXTD_EVNT_DAYS
,      APPL_TO_OFFR_ACPT_EVNT_DAYS
,      APPL_TO_FILL_EVNT_DAYS
,      APPL_TO_APPL_HIRE_EVNT_DAYS
,      APPL_TO_TERM_OFFR_EVNT_DAYS
,      APPL_TO_APPL_TERM_EVNT_DAYS
,      OFFR_TO_TERM_VOL_EVNT_DAYS
,      OFFR_TO_TERM_INVOL_EVNT_DAYS
,      OFFR_TO_ACPT_EVNT_DAYS
,      ACPT_TO_TERM_VOL_EVNT_DAYS
,      ACPT_TO_TERM_INVOL_EVNT_DAYS
,      TOTAL_OPENINGS
,      FILLED_OPENINGS
,      TOTAL_HEADCOUNT
,      FILLED_HEADCOUNT
,      TOTAL_FTE
,      FILLED_FTE
,      TOTAL_MONEY
,      FILLED_MONEY
,      VAC_FILLED_IND
FROM APPS.HRI_OBI_MD_REC_VACANCY_V;

Dependencies

[top of page]

APPS.HRI_OBI_MD_REC_VACANCY_V references the following:

APPS: HRI_MB_REC_CAND_PIPLN_CT; HRI_MB_REC_VACANCY_CT

APPS.HRI_OBI_MD_REC_VACANCY_V is not referenced by any database object