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

VIEW: APPS.EGO_VALUE_SETS_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
VALUE_SET_ID NUMBER (10) Yes Value set identifier
VALUE_SET_NAME VARCHAR2 (60) Yes Value set name
FORMAT_CODE VARCHAR2 (1) Yes Data type format (Eg: C,N ..)
FORMAT_MEANING VARCHAR2 (80) Yes Meaning of format code (Eg Char, Number ..)
MAXIMUM_SIZE NUMBER (3) Yes Maximum size
DESCRIPTION VARCHAR2 (240)
Description
LONGLIST_FLAG VARCHAR2 (1) Yes Flag to indicate whether the LOV LongList feature for the value set is enabled
LONGLIST_FLAG_MEANING VARCHAR2 (80) Yes Meaning of longlist flag
VALIDATION_CODE VARCHAR2 (30)
Validation Type
VALIDATION_MEANING VARCHAR2 (80) Yes Meaning of Validation code
MINIMUM_VALUE VARCHAR2 (150)
Maximum value
MAXIMUM_VALUE VARCHAR2 (150)
Minimum value
VALIDATION_CODE_ADMIN VARCHAR2 (1) Yes This column stores the Validation Type of Value Set
PARENT_VALUE_SET_ID NUMBER (15)
Query Text

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


SELECT VALUE_SET_ID
,      VALUE_SET_NAME
,      FORMAT_CODE
,      FORMAT_MEANING
,      MAXIMUM_SIZE
,      DESCRIPTION
,      LONGLIST_FLAG
,      LONGLIST_FLAG_MEANING
,      VALIDATION_CODE
,      VALIDATION_MEANING
,      MINIMUM_VALUE
,      MAXIMUM_VALUE
,      VALIDATION_CODE_ADMIN
,      PARENT_VALUE_SET_ID
FROM APPS.EGO_VALUE_SETS_V;

Dependencies

[top of page]

APPS.EGO_VALUE_SETS_V references the following:

SchemaAPPS
SynonymEGO_VALUE_SET_EXT
ViewEGO_VS_DISPLAY_CODES_V
ViewEGO_VS_FORMAT_CODES_V
ViewEGO_VS_VALIDATION_CODES_V
SynonymFND_FLEX_VALUE_SETS
APPS.EGO_VALUE_SETS_V is referenced by following:

SchemaAPPS
Package BodyEGO_EXT_FWK_PUB - show dependent code
Package BodyEGO_ITEM_USER_ATTRS_CP_PUB - show dependent code