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

TABLE: CLN.CLN_COLL_COMPLETED_STATUS

Object Details
Object Name: CLN_COLL_COMPLETED_STATUS
Object Type: TABLE
Owner: CLN
FND Design Data: TableCLN.CLN_COLL_COMPLETED_STATUS
Subobject Name:
Status: VALID


This table is used to default the collaboration status based on input parameters


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CLN_COLL_COMPLETED_STATUS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCOMPLETED_STATUS_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
GUID RAW (16) Yes Primary Key
COMPLETED_STATUS_ID NUMBER

COMPLETED_STATUS_ID IS 'UNIQUE_ID'
APPLICATION_ID NUMBER

Application ID of the product
COLLABORATION_TYPE VARCHAR2 (30)
Collaboration Type for the document
DOCUMENT_TYPE VARCHAR2 (100)
Document type
DOCUMENT_DIRECTION VARCHAR2 (3)
Direction of the document
MESSAGE_COUNT NUMBER

Total number of Messages with the same application id,document type, collaboration type and document direction possible
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
COLLABORATION_STANDARD VARCHAR2 (30)
Collaboration Standard
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT GUID
,      COMPLETED_STATUS_ID
,      APPLICATION_ID
,      COLLABORATION_TYPE
,      DOCUMENT_TYPE
,      DOCUMENT_DIRECTION
,      MESSAGE_COUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COLLABORATION_STANDARD
,      ZD_EDITION_NAME
FROM CLN.CLN_COLL_COMPLETED_STATUS;

Dependencies

[top of page]

CLN.CLN_COLL_COMPLETED_STATUS does not reference any database object

CLN.CLN_COLL_COMPLETED_STATUS is referenced by following:

SchemaCLN
ViewCLN_COLL_COMPLETED_STATUS#