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

VIEW: APPS.EGO_VALIDATION_TABLE_INFO_V

Object Details
Object Name: EGO_VALIDATION_TABLE_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_VALIDATION_TABLE_INFO_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
FLEX_VALUE_SET_ID NUMBER (10) Yes Flexfield value set identifier
TABLE_APPLICATION_ID NUMBER (10)
Table application identifier
APPLICATION_TABLE_NAME VARCHAR2 (240) Yes table name
VALUE_COLUMN_NAME VARCHAR2 (240) Yes Value column name
VALUE_COLUMN_TYPE VARCHAR2 (1) Yes Value column type
VALUE_COLUMN_SIZE NUMBER (3) Yes Value column size
MEANING_COLUMN_NAME VARCHAR2 (240)
Meaning column name
MEANING_COLUMN_TYPE VARCHAR2 (1)
Meaning column type
MEANING_COLUMN_SIZE NUMBER (3)
Meaning column size
ID_COLUMN_NAME VARCHAR2 (240)
Hidden ID column name
ID_COLUMN_TYPE VARCHAR2 (1)
ID column type
ID_COLUMN_SIZE NUMBER (3)
Size of ID column
ADDITIONAL_WHERE_CLAUSE CLOB (4000)
The SQL WHERE clause
TABLE_APPLICATION_NAME VARCHAR2 (240)
Application Name
Query Text

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


SELECT FLEX_VALUE_SET_ID
,      TABLE_APPLICATION_ID
,      APPLICATION_TABLE_NAME
,      VALUE_COLUMN_NAME
,      VALUE_COLUMN_TYPE
,      VALUE_COLUMN_SIZE
,      MEANING_COLUMN_NAME
,      MEANING_COLUMN_TYPE
,      MEANING_COLUMN_SIZE
,      ID_COLUMN_NAME
,      ID_COLUMN_TYPE
,      ID_COLUMN_SIZE
,      ADDITIONAL_WHERE_CLAUSE
,      TABLE_APPLICATION_NAME
FROM APPS.EGO_VALIDATION_TABLE_INFO_V;

Dependencies

[top of page]

APPS.EGO_VALIDATION_TABLE_INFO_V references the following:

SchemaAPPS
SynonymFND_APPLICATION_TL
SynonymFND_FLEX_VALIDATION_TABLES
APPS.EGO_VALIDATION_TABLE_INFO_V is referenced by following:

SchemaAPPS
Package BodyEGO_ODI_PUB - show dependent code
Package BodyEGO_USER_ATTRS_COMMON_PVT - show dependent code
Package BodyEGO_USER_ATTRS_DATA_PVT - show dependent code