eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: EGO.EGO_FLEX_VALUE_SET_INTF#

Object Details

Object Name:	EGO_FLEX_VALUE_SET_INTF#
Object Type:	VIEW
Owner:	EGO
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
VALUE_SET_NAME	VARCHAR2	(60)
VALUE_SET_ID	NUMBER	(10)
DESCRIPTION	VARCHAR2	(240)
VERSION_DESCRIPTION	VARCHAR2	(240)
FORMAT_TYPE	VARCHAR2	(1)
LONGLIST_FLAG	VARCHAR2	(1)
VALIDATION_TYPE	VARCHAR2	(1)
PARENT_VALUE_SET_NAME	VARCHAR2	(60)
VERSION_SEQ_ID	NUMBER	(10)
START_ACTIVE_DATE	DATE
END_ACTIVE_DATE	DATE
MAXIMUM_SIZE	NUMBER	(3)
MINIMUM_VALUE	VARCHAR2	(150)
MAXIMUM_VALUE	VARCHAR2	(150)
VALUE_COLUMN_NAME	VARCHAR2	(240)
VALUE_COLUMN_TYPE	VARCHAR2	(1)
VALUE_COLUMN_SIZE	NUMBER	(3)
ID_COLUMN_NAME	VARCHAR2	(240)
ID_COLUMN_SIZE	NUMBER	(3)
ID_COLUMN_TYPE	VARCHAR2	(1)
MEANING_COLUMN_NAME	VARCHAR2	(240)
MEANING_COLUMN_SIZE	NUMBER	(3)
MEANING_COLUMN_TYPE	VARCHAR2	(1)
TABLE_APPLICATION_ID	NUMBER	(10)
APPLICATION_TABLE_NAME	VARCHAR2	(240)
ADDITIONAL_WHERE_CLAUSE	VARCHAR2	(2000)
TRANSACTION_TYPE	VARCHAR2	(20)
TRANSACTION_ID	NUMBER	(15)
PROCESS_STATUS	NUMBER	(15)
SET_PROCESS_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)

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# references the following:

EGO: EGO_FLEX_VALUE_SET_INTF

EGO.EGO_FLEX_VALUE_SET_INTF# is referenced by following:

APPS: EGO_FLEX_VALUE_SET_INTF