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

VIEW: APPS.EGO_DATA_LEVEL_VL

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

View Type

MultiLingual view (a language resolved view of the data.)


View EGO_DATA_LEVEL_VL provides the complete information of the data level metadata. This information includes data level name, id, attribute group type, primary key column names and types, and view and edit priviledges.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DATA_LEVEL_ID NUMBER
Yes Data Level Identifier, Uniquely identifies the Data Level Information
APPLICATION_ID NUMBER
Yes Application Identifier, Foreign key to FND_APPLICATIONS.APPLICATION_ID.
ATTR_GROUP_TYPE VARCHAR2 (40) Yes Attribute Group Type Identifier, Foreign key to FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME.
DATA_LEVEL_NAME VARCHAR2 (30) Yes Data Level Internal Name, for user identification of the data level
USER_DATA_LEVEL_NAME VARCHAR2 (240)
User Name for Data Level to be displayed to the end user.
PK1_COLUMN_NAME VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.1 name for the Data Level
PK2_COLUMN_NAME VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.2 name for the Data Level
PK3_COLUMN_NAME VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.3 name for the Data Level
PK4_COLUMN_NAME VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.4 name for the Data Level
PK5_COLUMN_NAME VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.5 name for the Data Level
PK1_COLUMN_TYPE VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.1 data type for the Data Level
PK2_COLUMN_TYPE VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.2 data type for the Data Level
PK3_COLUMN_TYPE VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.3 data type for the Data Level
PK4_COLUMN_TYPE VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.4 data type for the Data Level
PK5_COLUMN_TYPE VARCHAR2 (30)
Primary Key COLUMN EGO_DATA_LEVEL_VL.5 data type for the Data Level
ENABLE_DEFAULTING VARCHAR2 (1)
Flag Y/N indicates the behavior availability at the Data Level.
ENABLE_VIEW_PRIV VARCHAR2 (1)
Flag Y/N indicates view privilege availability at the Data Level.
ENABLE_EDIT_PRIV VARCHAR2 (1)
Flag Y/N indicates edit privilege availability at the Data Level.
ENABLE_PRE_EVENT VARCHAR2 (1)
Flag Y/N indicates pre event availability at the Data Level.
ENABLE_POST_EVENT VARCHAR2 (1)
Flag Y/N indicates post event availability at the Data Level.
Query Text

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


SELECT DATA_LEVEL_ID
,      APPLICATION_ID
,      ATTR_GROUP_TYPE
,      DATA_LEVEL_NAME
,      USER_DATA_LEVEL_NAME
,      PK1_COLUMN_NAME
,      PK2_COLUMN_NAME
,      PK3_COLUMN_NAME
,      PK4_COLUMN_NAME
,      PK5_COLUMN_NAME
,      PK1_COLUMN_TYPE
,      PK2_COLUMN_TYPE
,      PK3_COLUMN_TYPE
,      PK4_COLUMN_TYPE
,      PK5_COLUMN_TYPE
,      ENABLE_DEFAULTING
,      ENABLE_VIEW_PRIV
,      ENABLE_EDIT_PRIV
,      ENABLE_PRE_EVENT
,      ENABLE_POST_EVENT
FROM APPS.EGO_DATA_LEVEL_VL;

Dependencies

[top of page]

APPS.EGO_DATA_LEVEL_VL references the following:

SchemaAPPS
SynonymEGO_DATA_LEVEL_B
SynonymEGO_DATA_LEVEL_TL
APPS.EGO_DATA_LEVEL_VL is referenced by following:

SchemaAPPS
Package BodyEGO_IMPORT_PVT - show dependent code
Package BodyEGO_IMPORT_UTIL_PVT - show dependent code
Package BodyEGO_ITEM_ASSOCIATIONS_PUB - show dependent code
Package BodyEGO_ITEM_USER_ATTRS_CP_PUB - show dependent code
Package BodyEGO_ITEM_WS_PVT - show dependent code
ViewEGO_OBJ_ATTR_GRP_ASSOCS_V
ViewEGO_PAGES_V
Package BodyEGO_PUBLICATION_PKG - show dependent code
Package BodyEGO_RULES_UTIL_PVT - show dependent code
Package BodyEGO_RULE_SETS_PKG - show dependent code
Package BodyEGO_USER_ATTRS_BULK_PVT - show dependent code
Package BodyEGO_USER_ATTRS_COMMON_PVT - show dependent code
Package BodyEGO_USER_ATTRS_DATA_PVT - show dependent code
Package BodyPON_ATTR_MAPPING - show dependent code
ViewUDA_SETUP_METADATA_V