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

TABLE: DDD.DDD_MODEL_CATALOG

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


Same as comment: Stores models (3dx) and information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDD_MODEL_CATALOG_N NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMODEL_ID
Columns
Name Datatype Length Mandatory Comments
MODEL_ID NUMBER (18) Yes Model id
VERSION NUMBER (18) Yes Version
STREAMGUID VARCHAR2 (38) Yes Stream GUID
CREATEUSER VARCHAR2 (255) Yes Standard WHO column
CREATEDATE DATE
Yes Standard WHO column
LASTMODUSER VARCHAR2 (255) Yes Standard WHO column
LASTMODDATE DATE
Yes Standard WHO column
NAME VARCHAR2 (255) Yes Name
PUBLISHSTATUS NUMBER (3) Yes Publish status
DESCRIPTION VARCHAR2 (255)
Description
BOMCREATESTATUS NUMBER (3) Yes BOM create status
BATCHBOMCREATE VARCHAR2 (1) Yes Batch BOM create
PK1_VALUE VARCHAR2 (150)
Primary key
PK2_VALUE VARCHAR2 (150)
Primary key
PK3_VALUE VARCHAR2 (150)
Primary key
PK4_VALUE VARCHAR2 (150)
Primary key
PK5_VALUE VARCHAR2 (150)
Primary key
PK_TYPE NUMBER (18)
PK type
TOP_BILL_SEQUENCE_ID NUMBER

Top Bill sequence id
Query Text

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


SELECT MODEL_ID
,      VERSION
,      STREAMGUID
,      CREATEUSER
,      CREATEDATE
,      LASTMODUSER
,      LASTMODDATE
,      NAME
,      PUBLISHSTATUS
,      DESCRIPTION
,      BOMCREATESTATUS
,      BATCHBOMCREATE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PK_TYPE
,      TOP_BILL_SEQUENCE_ID
FROM DDD.DDD_MODEL_CATALOG;

Dependencies

[top of page]

DDD.DDD_MODEL_CATALOG does not reference any database object

DDD.DDD_MODEL_CATALOG is referenced by following:

SchemaAPPS
SynonymDDD_MODEL_CATALOG