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

TABLE: CCT.CCT_MULTISITE_PARAMS

Object Details
Object Name: CCT_MULTISITE_PARAMS
Object Type: TABLE
Owner: CCT
Subobject Name:
Status: VALID


This table specifies the specific multisite parameters a multisite needs.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CCT_MULTISITE_PARAM_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnMULTISITE_PARAM_ID
Columns
Name Datatype Length Mandatory Comments
MULTISITE_PARAM_ID NUMBER (15) Yes Multisite Parameter ID. Unique ID.
NAME VARCHAR2 (32) Yes Multisite Parameter Name
TYPE VARCHAR2 (32)
Multisite Parameter Type
LENGTH VARCHAR2 (32)
Length for Validation in the HTML Admin
DOMAIN_LOOKUP_TYPE VARCHAR2 (32)
Lookup Type for LOV in the HTML admin
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
OBJECT_VERSION_NUMBER NUMBER (9) Yes OBJECT_VERSION_NUMBER for AOM web access
F_DELETEDFLAG VARCHAR2 (1)
F_DELETEDFLAG for AOM web access
SECURITY_GROUP_ID NUMBER (15)
Used in hosted environments
Query Text

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


SELECT MULTISITE_PARAM_ID
,      NAME
,      TYPE
,      LENGTH
,      DOMAIN_LOOKUP_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      F_DELETEDFLAG
,      SECURITY_GROUP_ID
FROM CCT.CCT_MULTISITE_PARAMS;

Dependencies

[top of page]

CCT.CCT_MULTISITE_PARAMS does not reference any database object

CCT.CCT_MULTISITE_PARAMS is referenced by following:

SchemaCCT
ViewCCT_MULTISITE_PARAMS#