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


TABLE: OPI.OPI_DBI_BASELINE_SCHEDULES

Object Details
Object Name: OPI_DBI_BASELINE_SCHEDULES
Object Type: TABLE
Owner: OPI
Subobject Name:
Status: VALID


Schedule table for baseline, storing baseline collection schedules.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BASELINE_ID NUMBER
Yes Baseline ID.
FROM_DATE DATE

From Date.
TO_DATE DATE

To Date.
NEXT_COLLECTION_DATE DATE

Next Collection Date.
SCHEDULE_TYPE NUMBER

Schedule Type.
SCHEDULE_ID NUMBER

Schedule ID.
CREATION_DATE DATE
Yes Who Column.
CREATED_BY NUMBER
Yes Who Column.
LAST_UPDATE_DATE DATE
Yes Who Column.
LAST_UPDATED_BY NUMBER
Yes Who Column.
LAST_UPDATE_LOGIN NUMBER

Who Column.
Query Text

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


SELECT BASELINE_ID
,      FROM_DATE
,      TO_DATE
,      NEXT_COLLECTION_DATE
,      SCHEDULE_TYPE
,      SCHEDULE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OPI.OPI_DBI_BASELINE_SCHEDULES;

Dependencies

[top of page]

OPI.OPI_DBI_BASELINE_SCHEDULES does not reference any database object

OPI.OPI_DBI_BASELINE_SCHEDULES is referenced by following:

SchemaAPPS
SynonymOPI_DBI_BASELINE_SCHEDULES