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

TABLE: DDD.DDD_MODEL_OBJECTS

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDD_MODEL_OBJECT_COMP_ID_N NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPONENT_ID
DDD_MODEL_OBJECTS_MODEL_ID_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMODEL_ID
DDD_MODEL_OBJECTS_OBJ_NAME_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_NAME
DDD_MODEL_OBJECT_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECTID
Columns
Name Datatype Length Mandatory Comments
MODEL_ID NUMBER (18)
Model Id
OBJECTID NUMBER (18) Yes Object Id
OBJECT_NAME VARCHAR2 (255) Yes Object name
COMPONENT_ID NUMBER (18) Yes Component Id
BILL_SEQUENCE_ID NUMBER

Bill Sequence id
COMPONENT_SEQUENCE_ID NUMBER

Component sequence id
ITEM_CAD_MAP_ID NUMBER

Item CAD map id
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
OBJECT_VERSION NUMBER

Object version
Query Text

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


SELECT MODEL_ID
,      OBJECTID
,      OBJECT_NAME
,      COMPONENT_ID
,      BILL_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      ITEM_CAD_MAP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION
FROM DDD.DDD_MODEL_OBJECTS;

Dependencies

[top of page]

DDD.DDD_MODEL_OBJECTS does not reference any database object

DDD.DDD_MODEL_OBJECTS is referenced by following:

SchemaAPPS
SynonymDDD_MODEL_OBJECTS