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

VIEW: APPS.IEO_SVR_TYPES_VL

Object Details
Object Name: IEO_SVR_TYPES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIEO.IEO_SVR_TYPES_VL
Subobject Name:
Status: VALID

View Type

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


This view represents translated server types, and is used to display the server type LOV in the server locator form.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Uniquely identifies a row.
TYPE_ID NUMBER (15) Yes FK to the server type id.
CREATED_BY NUMBER (15) Yes Standard WHO columns.
CREATION_DATE DATE
Yes Standard WHO columns.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO columns.
LAST_UPDATE_DATE DATE
Yes Standard WHO columns.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns.
TYPE_UUID VARCHAR2 (40) Yes The UUID of the server type.
RT_REFRESH_RATE NUMBER (5)
How often servers of this type refresh thier status.
MAX_MAJOR_LOAD_FACTOR NUMBER (15)
Maximum major load factor this server can support.
MAX_MINOR_LOAD_FACTOR NUMBER (15)
Maximum minor load factor this server can support.
IEO_SVR_TYPES VARCHAR2 (30)
Parameter lookup types (for LOVs).
TYPE_NAME VARCHAR2 (1996) Yes User displayable server type name.
TYPE_DESCRIPTION VARCHAR2 (1996)
User displayable server type description.
TYPE_EXTRA VARCHAR2 (1996)
User displayable server type extra information.
Query Text

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


SELECT ROW_ID
,      TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TYPE_UUID
,      RT_REFRESH_RATE
,      MAX_MAJOR_LOAD_FACTOR
,      MAX_MINOR_LOAD_FACTOR
,      IEO_SVR_TYPES
,      TYPE_NAME
,      TYPE_DESCRIPTION
,      TYPE_EXTRA
FROM APPS.IEO_SVR_TYPES_VL;

Dependencies

[top of page]

APPS.IEO_SVR_TYPES_VL references the following:

SchemaAPPS
SynonymIEO_SVR_TYPES_B
SynonymIEO_SVR_TYPES_TL

APPS.IEO_SVR_TYPES_VL is not referenced by any database object