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


TABLE: HRI.HRI_EDW_EVENT_HRCHY_CMBNS

Object Details
Object Name: HRI_EDW_EVENT_HRCHY_CMBNS
Object Type: TABLE
Owner: HRI
FND Design Data: TableHRI.HRI_EDW_EVENT_HRCHY_CMBNS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_EDW_EVENT_HRCHY_CMBNS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCOMBINATION_ID
HRI_EDW_EVENT_HRCHY_CMBNS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnGAIN_EVENT_ID
HRI_EDW_EVENT_HRCHY_CMBNS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnLOSS_EVENT_ID
HRI_EDW_EVENT_HRCHY_CMBNS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnREC_EVENT_ID
HRI_EDW_EVENT_HRCHY_CMBNS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSEP_EVENT_ID
Columns
Name Datatype Length Mandatory Comments
COMBINATION_ID NUMBER

GAIN_EVENT_ID NUMBER

LOSS_EVENT_ID NUMBER

REC_EVENT_ID NUMBER

SEP_EVENT_ID NUMBER

REASON_TYPE VARCHAR2 (30)
COMBINATION VARCHAR2 (30)
FACTS VARCHAR2 (30)
DESCRIPTION VARCHAR2 (80)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

Query Text

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


SELECT COMBINATION_ID
,      GAIN_EVENT_ID
,      LOSS_EVENT_ID
,      REC_EVENT_ID
,      SEP_EVENT_ID
,      REASON_TYPE
,      COMBINATION
,      FACTS
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HRI.HRI_EDW_EVENT_HRCHY_CMBNS;

Dependencies

[top of page]

HRI.HRI_EDW_EVENT_HRCHY_CMBNS does not reference any database object

HRI.HRI_EDW_EVENT_HRCHY_CMBNS is referenced by following:

SchemaAPPS
SynonymHRI_EDW_EVENT_HRCHY_CMBNS
TriggerHRI_EDW_EVENT_HRCHY_CMBNS_WHO