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

TABLE: HRI.HRI_CS_SUPH_ORGMGR_CT

Object Details
Object Name: HRI_CS_SUPH_ORGMGR_CT
Object Type: TABLE
Owner: HRI
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_CS_SUPH_ORGMGR_CT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUB_ORGANIZATION_ID
HRI_CS_SUPH_ORGMGR_CT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUP_PERSON_ID
ColumnSUB_PERSON_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
Columns
Name Datatype Length Mandatory Comments
SUP_BUSINESS_GROUP_ID NUMBER (15) Yes
SUP_PERSON_ID NUMBER (15) Yes
SUP_ASSIGNMENT_ID NUMBER (15) Yes
SUP_ORGANIZATION_ID NUMBER (15) Yes
SUP_LEVEL NUMBER (15) Yes
SUB_BUSINESS_GROUP_ID NUMBER (15) Yes
SUB_PERSON_ID NUMBER (15) Yes
SUB_ASSIGNMENT_ID NUMBER (15) Yes
SUB_ORGANIZATION_ID NUMBER (15) Yes
SUB_LEVEL NUMBER (15) Yes
SUB_RELATIVE_LEVEL NUMBER (15) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT SUP_BUSINESS_GROUP_ID
,      SUP_PERSON_ID
,      SUP_ASSIGNMENT_ID
,      SUP_ORGANIZATION_ID
,      SUP_LEVEL
,      SUB_BUSINESS_GROUP_ID
,      SUB_PERSON_ID
,      SUB_ASSIGNMENT_ID
,      SUB_ORGANIZATION_ID
,      SUB_LEVEL
,      SUB_RELATIVE_LEVEL
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HRI.HRI_CS_SUPH_ORGMGR_CT;

Dependencies

[top of page]

HRI.HRI_CS_SUPH_ORGMGR_CT does not reference any database object

HRI.HRI_CS_SUPH_ORGMGR_CT is referenced by following:

SchemaAPPS
SynonymHRI_CS_SUPH_ORGMGR_CT
TriggerHRI_CS_SUPH_ORGMGR_CT_WHO