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

VIEW: APPS.ENG_CHANGE_TYPE_ROUTES_V

Object Details
Object Name: ENG_CHANGE_TYPE_ROUTES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewENG.ENG_CHANGE_TYPE_ROUTES_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


ENG_CHANGE_TYPE_ROUTES_V stores information to display Engineering Change Type Route Templates in a change order.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CHANGE_TYPE_ROUTE_ID NUMBER
Yes Change type route identifier
CHANGE_TYPE_ID NUMBER
Yes Change type
ROUTE_ID NUMBER
Yes Change route identifier
ROUTE_NAME VARCHAR2 (240) Yes Route name
ROUTE_DESCRIPTION VARCHAR2 (4000)
Route description
DEFAULT_ROUTE_FLAG VARCHAR2 (1)
Flag to indicate if the route is set by default
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
ROTUE_START_DATE DATE

Rotue Start Date
ROUTE_END_DATE DATE

Route End Date
CHANGE_LIFECYCLE_STATUS_ID NUMBER

Change lifecycle status
Query Text

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


SELECT ROW_ID
,      CHANGE_TYPE_ROUTE_ID
,      CHANGE_TYPE_ID
,      ROUTE_ID
,      ROUTE_NAME
,      ROUTE_DESCRIPTION
,      DEFAULT_ROUTE_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ROTUE_START_DATE
,      ROUTE_END_DATE
,      CHANGE_LIFECYCLE_STATUS_ID
FROM APPS.ENG_CHANGE_TYPE_ROUTES_V;

Dependencies

[top of page]

APPS.ENG_CHANGE_TYPE_ROUTES_V references the following:

SchemaAPPS
ViewENG_CHANGE_ROUTES_VL
SynonymENG_CHANGE_TYPE_ROUTES

APPS.ENG_CHANGE_TYPE_ROUTES_V is not referenced by any database object