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

TABLE: ENG.ENG_CHANGE_TYPE_ROUTES

Object Details
Object Name: ENG_CHANGE_TYPE_ROUTES
Object Type: TABLE
Owner: ENG
FND Design Data: TableENG.ENG_CHANGE_TYPE_ROUTES
Subobject Name:
Status: VALID


Engineering Change Type Route Templates


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENG_CHANGE_TYPE_ROUTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCHANGE_TYPE_ROUTE_ID
ColumnZD_EDITION_NAME
ENG_CHANGE_TYPE_ROUTES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnCHANGE_TYPE_ID
ColumnROUTE_ID
ColumnCHANGE_LIFECYCLE_STATUS_ID
ColumnZD_EDITION_NAME
ENG_CHANGE_TYPE_ROUTES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnCHANGE_TYPE_ID
ColumnCHANGE_LIFECYCLE_STATUS_ID
Columns
Name Datatype Length Mandatory Comments
CHANGE_TYPE_ROUTE_ID NUMBER
Yes Change Type Route ID
CHANGE_TYPE_ID NUMBER
Yes Change Type ID
ROUTE_ID NUMBER
Yes Route ID
DEFAULT_ROUTE_FLAG VARCHAR2 (1)
Default Route Template Flag
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
CHANGE_LIFECYCLE_STATUS_ID NUMBER

Change Lifecycle Status Id
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT CHANGE_TYPE_ROUTE_ID
,      CHANGE_TYPE_ID
,      ROUTE_ID
,      DEFAULT_ROUTE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_LIFECYCLE_STATUS_ID
,      ZD_EDITION_NAME
FROM ENG.ENG_CHANGE_TYPE_ROUTES;

Dependencies

[top of page]

ENG.ENG_CHANGE_TYPE_ROUTES does not reference any database object

ENG.ENG_CHANGE_TYPE_ROUTES is referenced by following:

SchemaENG
ViewENG_CHANGE_TYPE_ROUTES#