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

VIEW: APPS.EGO_VALUE_SET_VALUES_V

Object Details
Object Name: EGO_VALUE_SET_VALUES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEGO.EGO_VALUE_SET_VALUES_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_TYPE VARCHAR2 (1) Yes This column stores the Format Type of Value Set
VALIDATION_TYPE VARCHAR2 (1) Yes This column stores the Validation Type of Value Set
FLEX_VALUE_ID NUMBER (15) Yes Foreign key from table FND_FLEX_VALUES.FLEX_VALUE_ID
INTERNAL_NAME VARCHAR2 (150) Yes internal name
DISPLAY_NAME VARCHAR2 (150) Yes display name
DESCRIPTION VARCHAR2 (240)
This column stores the description of the Value Set Value
ENABLED_CODE VARCHAR2 (1) Yes Is this value set enabled
ENABLED_MEANING VARCHAR2 (80) Yes meaning of enabled_code
SEQUENCE NUMBER

Display Sequence
START_DATE DATE

Date from which value set will be used
END_DATE DATE

Date from which value set will be disabled
Query Text

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


SELECT VALUE_SET_ID
,      VALUE_SET_NAME
,      FORMAT_TYPE
,      VALIDATION_TYPE
,      FLEX_VALUE_ID
,      INTERNAL_NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      ENABLED_CODE
,      ENABLED_MEANING
,      SEQUENCE
,      START_DATE
,      END_DATE
FROM APPS.EGO_VALUE_SET_VALUES_V;

Dependencies

[top of page]

APPS.EGO_VALUE_SET_VALUES_V references the following:

SchemaAPPS
ViewEGO_VS_DISPLAY_CODES_V
ViewEGO_VS_FORMAT_CODES_V
ViewEGO_VS_VALIDATION_CODES_V
SynonymEGO_VS_VALUES_DISP_ORDER
ViewFND_FLEX_VALUES_VL
SynonymFND_FLEX_VALUE_SETS
SynonymFND_LOOKUP_VALUES
APPS.EGO_VALUE_SET_VALUES_V is referenced by following:

SchemaAPPS
Package BodyEGO_ITEM_COMPARE_PKG - show dependent code
Package BodyEGO_ITEM_PVT - show dependent code
Package BodyINV_EGO_REVISION_VALIDATE - show dependent code