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


TABLE: HXT.HXT_ROTATION_PLANS

Object Details
Object Name: HXT_ROTATION_PLANS
Object Type: TABLE
Owner: HXT
FND Design Data: TableHXT.HXT_ROTATION_PLANS
Subobject Name:
Status: VALID


The details of a rotation plan which is composed of many work plans
starting at specified dates.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HXT_ROTATION_PLANS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
HXT_ROTATION_PLANS_UK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
Columns
Name Datatype Length Mandatory Comments
ID NUMBER (15) Yes System generated rotation plan primary key
NAME VARCHAR2 (80) Yes Rotation plan name -
DATE_FROM DATE
Yes First effective date
DESCRIPTION VARCHAR2 (255)
Rotation plan description
DATE_TO DATE

Last effective day
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

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


SELECT ID
,      NAME
,      DATE_FROM
,      DESCRIPTION
,      DATE_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HXT.HXT_ROTATION_PLANS;

Dependencies

[top of page]

HXT.HXT_ROTATION_PLANS does not reference any database object

HXT.HXT_ROTATION_PLANS is referenced by following:

SchemaAPPS
SynonymHXT_ROTATION_PLANS
TriggerHXT_ROTATION_PLANS_WHO