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

TABLE: CCT.CCT_MW_ROUTE_POINT_PARAMS

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


Parameters table for Middleware Route Points


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CCT_MW_ROUTE_POINT_PARAMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMW_ROUTE_POINT_PARAM_ID
Columns
Name Datatype Length Mandatory Comments
MW_ROUTE_POINT_PARAM_ID NUMBER (15) Yes Unique ID for the table
NAME VARCHAR2 (240) Yes Name of the Parameter
TYPE VARCHAR2 (240)
DataType of the Parameter
LENGTH VARCHAR2 (240)
Length of the Parameter
DOMAIN_LOOKUP_TYPE VARCHAR2 (240)
Used to lookup values for the Parameter
LAST_UPDATE_DATE DATE

FND Who Columns
LAST_UPDATED_BY NUMBER (15)
FND Who Columns
CREATED_BY NUMBER (15)
FND Who Columns
CREATION_DATE DATE

FND Who Columns
LAST_UPDATE_LOGIN NUMBER (15)
FND Who Columns
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object Version Number
F_DELETEDFLAG VARCHAR2 (240)
Delete Flag for HTML Admins
SECURITY_GROUP_ID NUMBER (15)
Security Group ID for Hosting
Query Text

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


SELECT MW_ROUTE_POINT_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_MW_ROUTE_POINT_PARAMS;

Dependencies

[top of page]

CCT.CCT_MW_ROUTE_POINT_PARAMS does not reference any database object

CCT.CCT_MW_ROUTE_POINT_PARAMS is referenced by following:

SchemaAPPS
SynonymCCT_MW_ROUTE_POINT_PARAMS