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

TABLE: ONT.OE_UI_QUERY_COLUMNS

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


This table stores the column values for the user defined queries that are stored in OE_UI_QUERIES_TL table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_UI_QUERY_COLUMNS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCOLUMN_ID
Columns
Name Datatype Length Mandatory Comments
COLUMN_ID NUMBER
Yes Unique ID for the record
QUERY_ID NUMBER
Yes Foreign Key value from OE_UI_QUERIES_TL table
QUERY_COLUMN_INDEX_ID NUMBER

Stores ID's used by the UI to know the column name
COLUMN_NAME VARCHAR2 (240) Yes Name of the column used in the query
COLUMN_VALUE VARCHAR2 (2000) Yes Value of the column used in the query
COLUMN_TYPE VARCHAR2 (200) Yes Data Type of the column used in the query
OVERRIDE_FLAG VARCHAR2 (1)
Specifies if user can override the column values at runtime
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT COLUMN_ID
,      QUERY_ID
,      QUERY_COLUMN_INDEX_ID
,      COLUMN_NAME
,      COLUMN_VALUE
,      COLUMN_TYPE
,      OVERRIDE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ONT.OE_UI_QUERY_COLUMNS;

Dependencies

[top of page]

ONT.OE_UI_QUERY_COLUMNS does not reference any database object

ONT.OE_UI_QUERY_COLUMNS is referenced by following:

SchemaAPPS
SynonymOE_UI_QUERY_COLUMNS