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

TABLE: EGO.EGO_FLEX_VALUE_SET_INTF

Object Details
Object Name: EGO_FLEX_VALUE_SET_INTF
Object Type: TABLE
Owner: EGO
FND Design Data: TableEGO.EGO_FLEX_VALUE_SET_INTF
Subobject Name:
Status: VALID

This table stores the value set.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
VALUE_SET_NAME VARCHAR2 (60)
Flexfield value set.
VALUE_SET_ID NUMBER (10)
Flexfield value set identifier.
DESCRIPTION VARCHAR2 (240)
Description.
VERSION_DESCRIPTION VARCHAR2 (240)
Version description.
FORMAT_TYPE VARCHAR2 (1)
Format type.
LONGLIST_FLAG VARCHAR2 (1)
Flag to indicate whether the LOV LongList feature for the value set is enabled.
VALIDATION_TYPE VARCHAR2 (1)
Validation type.
PARENT_VALUE_SET_NAME VARCHAR2 (60)
Parent value set name for a child value set.
VERSION_SEQ_ID NUMBER (10)
Version to a value set.
START_ACTIVE_DATE DATE

The date a version becomes active.
END_ACTIVE_DATE DATE

The date a version expires.
MAXIMUM_SIZE NUMBER (3)
The maximum size of values in the value set.
MINIMUM_VALUE VARCHAR2 (150)
Minimum value.
MAXIMUM_VALUE VARCHAR2 (150)
Maximum value.
VALUE_COLUMN_NAME VARCHAR2 (240)
Value column name.
VALUE_COLUMN_TYPE VARCHAR2 (1)
Value column type.
VALUE_COLUMN_SIZE NUMBER (3)
Size of value column.
ID_COLUMN_NAME VARCHAR2 (240)
Hidden ID column name.
ID_COLUMN_SIZE NUMBER (3)
Size of ID column.
ID_COLUMN_TYPE VARCHAR2 (1)
ID column type.
MEANING_COLUMN_NAME VARCHAR2 (240)
Meaning column name.
MEANING_COLUMN_SIZE NUMBER (3)
Size of meaning column.
MEANING_COLUMN_TYPE VARCHAR2 (1)
Meaning column type.
TABLE_APPLICATION_ID NUMBER (10)
Table application identifier.
APPLICATION_TABLE_NAME VARCHAR2 (240)
Table name.
ADDITIONAL_WHERE_CLAUSE VARCHAR2 (2000)
The SQL WHERE clause.
TRANSACTION_TYPE VARCHAR2 (20)
Transaction type.
TRANSACTION_ID NUMBER (15)
Row Identifier.
PROCESS_STATUS NUMBER (15)
Row status.
SET_PROCESS_ID NUMBER (15)
Used when multiple Value Set Open Interface processes are run in parallel.
REQUEST_ID NUMBER (15)
Concurrent Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Who column.
PROGRAM_ID NUMBER (15)
Concurrent Who column.
PROGRAM_UPDATE_DATE DATE

Concurrent Who column.
LAST_UPDATE_DATE DATE

standard "WHO" column.
LAST_UPDATED_BY NUMBER (15)
standard "WHO" column.
CREATION_DATE DATE

standard "WHO" column.
CREATED_BY NUMBER (15)
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 VALUE_SET_NAME
,      VALUE_SET_ID
,      DESCRIPTION
,      VERSION_DESCRIPTION
,      FORMAT_TYPE
,      LONGLIST_FLAG
,      VALIDATION_TYPE
,      PARENT_VALUE_SET_NAME
,      VERSION_SEQ_ID
,      START_ACTIVE_DATE
,      END_ACTIVE_DATE
,      MAXIMUM_SIZE
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      VALUE_COLUMN_NAME
,      VALUE_COLUMN_TYPE
,      VALUE_COLUMN_SIZE
,      ID_COLUMN_NAME
,      ID_COLUMN_SIZE
,      ID_COLUMN_TYPE
,      MEANING_COLUMN_NAME
,      MEANING_COLUMN_SIZE
,      MEANING_COLUMN_TYPE
,      TABLE_APPLICATION_ID
,      APPLICATION_TABLE_NAME
,      ADDITIONAL_WHERE_CLAUSE
,      TRANSACTION_TYPE
,      TRANSACTION_ID
,      PROCESS_STATUS
,      SET_PROCESS_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM EGO.EGO_FLEX_VALUE_SET_INTF;

Dependencies

[top of page]

EGO.EGO_FLEX_VALUE_SET_INTF does not reference any database object

EGO.EGO_FLEX_VALUE_SET_INTF is referenced by following:

SchemaEGO
ViewEGO_FLEX_VALUE_SET_INTF#