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

TABLE: IEO.IEO_USER_PARAMETERS

Object Details
Object Name: IEO_USER_PARAMETERS
Object Type: TABLE
Owner: IEO
Subobject Name:
Status: VALID


User Parameters


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IEO_USER_PARAMETER_ID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_PARAMETER_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
USER_PARAMETER_ID NUMBER
Yes User Parameter Id
CATEGORY VARCHAR2 (64)
Category
SUBCATEGORY_ID NUMBER

SubCategory Id
PARAMETER_KEY VARCHAR2 (64)
Parameter Key
VALUE_DATA_TYPE VARCHAR2 (64)
Value Data Type
VALUE_LENGTH VARCHAR2 (64)
Value Length
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
OBJECT_VERSION_NUMBER NUMBER

OBJECT_VERSION_NUMBER for AOM web access
F_DELETEDFLAG VARCHAR2 (1)
Deleted Flag
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT USER_PARAMETER_ID
,      CATEGORY
,      SUBCATEGORY_ID
,      PARAMETER_KEY
,      VALUE_DATA_TYPE
,      VALUE_LENGTH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      F_DELETEDFLAG
,      ZD_EDITION_NAME
FROM IEO.IEO_USER_PARAMETERS;

Dependencies

[top of page]

IEO.IEO_USER_PARAMETERS does not reference any database object

IEO.IEO_USER_PARAMETERS is referenced by following:

SchemaIEO
ViewIEO_USER_PARAMETERS#