[Home] [Help] [Dependency Information]
Object Name: | DDD_MODEL_OBJECTS |
---|---|
Object Type: | TABLE |
Owner: | DDD |
FND Design Data: | DDD.DDD_MODEL_OBJECTS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DDD_MODEL_OBJECT_COMP_ID_N | NORMAL | UNIQUE | APPS_TS_TX_IDX | COMPONENT_ID |
DDD_MODEL_OBJECTS_MODEL_ID_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MODEL_ID |
DDD_MODEL_OBJECTS_OBJ_NAME_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OBJECT_NAME |
DDD_MODEL_OBJECT_N | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OBJECTID |
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 |
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;
DDD.DDD_MODEL_OBJECTS does not reference any database object
DDD.DDD_MODEL_OBJECTS is referenced by following:
|
|
|