[Home] [Help] [Dependency Information]
Object Name: | HRI_MB_REC_VACANCY_CT |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MB_REC_VACANCY_CT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RVAC_VACNCY_FK |
HRI_MB_REC_VACANCY_CT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORG_ORGANZTN_MRGD_FK |
HRI_MB_REC_VACANCY_CT_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PER_PERSON_MRGD_FK |
HRI_MB_REC_VACANCY_CT_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORG_ORGANZTN_FK |
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 |
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;
HRI.HRI_MB_REC_VACANCY_CT does not reference any database object
HRI.HRI_MB_REC_VACANCY_CT is referenced by following:
|
|
|