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

TABLE: DDD.DDD_MODEL_LISTING

Object Details
Object Name: DDD_MODEL_LISTING
Object Type: TABLE
Owner: DDD
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDD_MODEL_LISTING_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAMMID
ColumnAMCID
Columns
Name Datatype Length Mandatory Comments
SHOWN VARCHAR2 (1) Yes Shown
AMMID VARCHAR2 (255) Yes Ammid
AMCID VARCHAR2 (255) Yes Amcid
AMM_FILENAME VARCHAR2 (255)
Filename
MODEL_NAME VARCHAR2 (255)
Model name
MODEL_DESCRIPTION VARCHAR2 (1000)
Model description
USERNAME VARCHAR2 (255)
User name
CREATEDATE DATE

Creation date
COLLABDBASSID VARCHAR2 (20)
Collaboration database SID
PATH_PREFIX VARCHAR2 (255)
Path prefix
GUID VARCHAR2 (255)
GUID
STRUCT VARCHAR2 (255)
Struct
ITEMID VARCHAR2 (255)
Item id
ORGID VARCHAR2 (255)
Organization id
REVISION VARCHAR2 (255)
Revision
TOP_BILL_SEQUENCE_ID VARCHAR2 (255)
Top Bill Sequence Id
COMMON_BILL_SEQUENCE_ID VARCHAR2 (255)
Common Bill Sequence id
ITEM_NAME VARCHAR2 (255)
Item name
ORG_CODE VARCHAR2 (255)
Organization code
ORG_NAME VARCHAR2 (255)
Organization name
STRUCT_TYPE_ID VARCHAR2 (255)
Structure type id
ATTRIBUTE1 VARCHAR2 (255)
Misc. value
ATTRIBUTE2 VARCHAR2 (255)
Misc. value
ATTRIBUTE3 VARCHAR2 (255)
Misc. value
ATTRIBUTE4 VARCHAR2 (255)
Misc. value
ATTRIBUTE5 VARCHAR2 (255)
Misc. value
ATTRIBUTE6 VARCHAR2 (255)
Misc. value
ATTRIBUTE7 VARCHAR2 (255)
Misc. value
ATTRIBUTE8 VARCHAR2 (255)
Misc. value
ATTRIBUTE9 VARCHAR2 (255)
Misc. value
ATTRIBUTE10 VARCHAR2 (255)
Misc. value
Query Text

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


SELECT SHOWN
,      AMMID
,      AMCID
,      AMM_FILENAME
,      MODEL_NAME
,      MODEL_DESCRIPTION
,      USERNAME
,      CREATEDATE
,      COLLABDBASSID
,      PATH_PREFIX
,      GUID
,      STRUCT
,      ITEMID
,      ORGID
,      REVISION
,      TOP_BILL_SEQUENCE_ID
,      COMMON_BILL_SEQUENCE_ID
,      ITEM_NAME
,      ORG_CODE
,      ORG_NAME
,      STRUCT_TYPE_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
FROM DDD.DDD_MODEL_LISTING;

Dependencies

[top of page]

DDD.DDD_MODEL_LISTING does not reference any database object

DDD.DDD_MODEL_LISTING is referenced by following:

SchemaAPPS
SynonymDDD_MODEL_LISTING