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

TABLE: HRI.HRI_TIME_BANDS

Object Details
Object Name: HRI_TIME_BANDS
Object Type: TABLE
Owner: HRI
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_TIME_BANDS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTYPE
ColumnBAND_MIN_VALUE
HRI_TIME_BANDS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTYPE
ColumnBAND_SEQUENCE
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (30) Yes
BAND_MIN_VALUE NUMBER
Yes
BAND_MAX_VALUE NUMBER

BAND_SEQUENCE NUMBER
Yes
BAND_MIN_DAY_COMP NUMBER

BAND_MIN_WEEK_COMP NUMBER

BAND_MIN_MONTH_COMP NUMBER

BAND_MIN_YEAR_COMP NUMBER

BAND_MAX_DAY_COMP NUMBER

BAND_MAX_WEEK_COMP NUMBER

BAND_MAX_MONTH_COMP NUMBER

BAND_MAX_YEAR_COMP NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER

LAST_UPDATED_BY NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

Query Text

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


SELECT TYPE
,      BAND_MIN_VALUE
,      BAND_MAX_VALUE
,      BAND_SEQUENCE
,      BAND_MIN_DAY_COMP
,      BAND_MIN_WEEK_COMP
,      BAND_MIN_MONTH_COMP
,      BAND_MIN_YEAR_COMP
,      BAND_MAX_DAY_COMP
,      BAND_MAX_WEEK_COMP
,      BAND_MAX_MONTH_COMP
,      BAND_MAX_YEAR_COMP
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM HRI.HRI_TIME_BANDS;

Dependencies

[top of page]

HRI.HRI_TIME_BANDS does not reference any database object

HRI.HRI_TIME_BANDS is referenced by following:

SchemaAPPS
SynonymHRI_TIME_BANDS
TriggerHRI_TIME_BANDS_WHO