[Home] [Help] [Dependency Information]
Object Name: | HRI_CS_ORGH_CT# |
---|---|
Object Type: | VIEW |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGH_ORGHRCHY_FK | NUMBER | |||
ORGH_GLOBAL_FLAG | VARCHAR2 | (30) | ||
ORGH_ORGHVRSN_FK | NUMBER | |||
ORGH_SUP_ORGANZTN_FK | NUMBER | |||
ORGH_SUP_LEVEL | NUMBER | |||
ORGH_SUP_SUB1_ORGANZTN_FK | NUMBER | |||
ORGH_SUP_SUB2_ORGANZTN_FK | NUMBER | |||
ORGH_SUP_SUB3_ORGANZTN_FK | NUMBER | |||
ORGH_SUP_SUB4_ORGANZTN_FK | NUMBER | |||
ORGH_ORGANZTN_FK | NUMBER | |||
ORGH_LEVEL | NUMBER | |||
ORGH_RELATIVE_LEVEL | NUMBER | |||
ORGH_ADT_ORG_STRUCT_ID | NUMBER | |||
ORGH_ADT_ORG_STRUCT_VERSION_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
ORGH_SUB_NODE_HAS_WORKERS_FLAG | VARCHAR2 | (30) | ||
ORGH_SUB_ORG_HAS_WORKERS_FLAG | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ORGH_ORGHRCHY_FK
, ORGH_GLOBAL_FLAG
, ORGH_ORGHVRSN_FK
, ORGH_SUP_ORGANZTN_FK
, ORGH_SUP_LEVEL
, ORGH_SUP_SUB1_ORGANZTN_FK
, ORGH_SUP_SUB2_ORGANZTN_FK
, ORGH_SUP_SUB3_ORGANZTN_FK
, ORGH_SUP_SUB4_ORGANZTN_FK
, ORGH_ORGANZTN_FK
, ORGH_LEVEL
, ORGH_RELATIVE_LEVEL
, ORGH_ADT_ORG_STRUCT_ID
, ORGH_ADT_ORG_STRUCT_VERSION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, ORGH_SUB_NODE_HAS_WORKERS_FLAG
, ORGH_SUB_ORG_HAS_WORKERS_FLAG
FROM HRI.HRI_CS_ORGH_CT#;
|
|
|