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

TABLE: ONT.OE_RESERVATION_SETS

Object Details
Object Name: OE_RESERVATION_SETS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_RESERVATION_SETS
Subobject Name:
Status: VALID


This table is to store header information of reservation sets.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_RESERVATION_SETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESERVATION_SET_ID
OE_RESERVATION_SETS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESERVATION_SET_NAME
Columns
Name Datatype Length Mandatory Comments
RESERVATION_SET_ID NUMBER
Yes Unique Set Identifier
RESERVATION_SET_NAME VARCHAR2 (50) Yes Reservation Set Name
RESERVATION_REQUEST_ID NUMBER

Reservation Set request Id
PROCESS_FLAG VARCHAR2 (1)
Reservation Processed flag
SIMULATION_REQUEST_ID NUMBER

Simulation Set Request Id
CREATION_DATE DATE
Yes date of creation of this record
CREATED_BY NUMBER
Yes User who created this record
PROGRAM_UPDATE_DATE DATE

Last date changed by concurrent program
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated rows
PROGRAM_ID NUMBER

Concurrent program that last updated row
LAST_UPDATE_LOGIN NUMBER
Yes Login used during last update
LAST_UPDATED_BY NUMBER
Yes User who last updated this record
LAST_UPDATE_DATE DATE
Yes Date when this record was last updated
Query Text

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


SELECT RESERVATION_SET_ID
,      RESERVATION_SET_NAME
,      RESERVATION_REQUEST_ID
,      PROCESS_FLAG
,      SIMULATION_REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM ONT.OE_RESERVATION_SETS;

Dependencies

[top of page]

ONT.OE_RESERVATION_SETS does not reference any database object

ONT.OE_RESERVATION_SETS is referenced by following:

SchemaONT
ViewOE_RESERVATION_SETS#