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

TABLE: DDD.DDD_MODEL_ATTRIBUTE_VALUES

Object Details
Object Name: DDD_MODEL_ATTRIBUTE_VALUES
Object Type: TABLE
Owner: DDD
FND Design Data: TableDDD.DDD_MODEL_ATTRIBUTE_VALUES
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDD_MODEL_ATTRIBUTE_VALUES_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMODEL_ID
ColumnOBJECTID
Columns
Name Datatype Length Mandatory Comments
MODEL_ID NUMBER (18)
Model id
OBJECTID NUMBER (18) Yes Object id
ATTRIBUTENAMEID NUMBER (18)
Attribute name id
VALUE_ID NUMBER (18) Yes Value id
BYTEVAL NUMBER (3)
Byte value
SHORTVAL NUMBER (5)
Short value
INTVAL NUMBER (10)
Integer value
INT64VAL NUMBER (18)
Int64 value
FLOATVAL NUMBER

Float value
DOUBLEVAL NUMBER

Double value
STRINGVAL VARCHAR2 (255)
String value
DATEVAL DATE

Date value
LONGSTRINGVAL VARCHAR2 (1000)
Long string value
HUGESTRINGVAL VARCHAR2 (2000)
Hige string value
BINARYVAL LONG RAW (0)
Query Text

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


SELECT MODEL_ID
,      OBJECTID
,      ATTRIBUTENAMEID
,      VALUE_ID
,      BYTEVAL
,      SHORTVAL
,      INTVAL
,      INT64VAL
,      FLOATVAL
,      DOUBLEVAL
,      STRINGVAL
,      DATEVAL
,      LONGSTRINGVAL
,      HUGESTRINGVAL
,      BINARYVAL
FROM DDD.DDD_MODEL_ATTRIBUTE_VALUES;

Dependencies

[top of page]

DDD.DDD_MODEL_ATTRIBUTE_VALUES does not reference any database object

DDD.DDD_MODEL_ATTRIBUTE_VALUES is referenced by following:

SchemaAPPS
SynonymDDD_MODEL_ATTRIBUTE_VALUES