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

TABLE: DDD.DDD_COLLABORATION_DATA_INFO

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDD_COLLABORATION_DATA_INFO_N NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOLLAB_ID
ColumnINFO_ID
Columns
Name Datatype Length Mandatory Comments
COLLAB_ID NUMBER (18)
Collaboration id
INFO_ID NUMBER (18) Yes Info Id
TYPE NUMBER (18) Yes Type
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
PRIVATE NUMBER (1)
Private
STATUS NUMBER (1)
Status
NAME VARCHAR2 (255)
Name
DESCRIPTION VARCHAR2 (2000)
Description
URL VARCHAR2 (510)
URL
OBJECTID NUMBER (18)
Object Id
STREAMGUID VARCHAR2 (76)
Stream GUID
COLLABTEXTLENGTH NUMBER (18)
Collaboration text length
COLLABTEXTID NUMBER (18)
Collaboration text id
COLLABBINARYLENGTH NUMBER (18)
Collaboration binary length
COLLABBINARYID NUMBER (18)
Collaboration Binary Id
COLLABPSBINLENGTH NUMBER (18)
Collaboration PS Bin length
COLLABPSBINID NUMBER (18)
Collaboration PSBIN Id
Query Text

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


SELECT COLLAB_ID
,      INFO_ID
,      TYPE
,      CREATEUSER
,      CREATEDATE
,      LASTMODUSER
,      LASTMODDATE
,      PRIVATE
,      STATUS
,      NAME
,      DESCRIPTION
,      URL
,      OBJECTID
,      STREAMGUID
,      COLLABTEXTLENGTH
,      COLLABTEXTID
,      COLLABBINARYLENGTH
,      COLLABBINARYID
,      COLLABPSBINLENGTH
,      COLLABPSBINID
FROM DDD.DDD_COLLABORATION_DATA_INFO;

Dependencies

[top of page]

DDD.DDD_COLLABORATION_DATA_INFO does not reference any database object

DDD.DDD_COLLABORATION_DATA_INFO is referenced by following:

SchemaAPPS
SynonymDDD_COLLABORATION_DATA_INFO