eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AHL_ROUTE_MR_V

Object Details

Object Name:	AHL_ROUTE_MR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_ROUTE_MR_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROUTE_MR_ID	NUMBER		Yes
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence
MR_HEADER_ID	NUMBER		Yes	Primary Key for AHL_MR_HEADERS_B, unique identifier of a MR
EFFECTIVE_TO	DATE			Effective end date of this MR. Only one revision of MR can be effective at any time instance.
ROUTE_ID	NUMBER		Yes	Primary Key, unique identifier of a Route
ROUTE_NO	VARCHAR2	(30)	Yes	User defined attribute to identify a Route
REVISION_STATUS_CODE	VARCHAR2	(30)	Yes	This attribute indicates the status of the operation, Whether it is current, draft, or archived
STAGE	NUMBER			Stage number in which route is to be planned
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column

Query Text

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


SELECT ROUTE_MR_ID
,      OBJECT_VERSION_NUMBER
,      MR_HEADER_ID
,      EFFECTIVE_TO
,      ROUTE_ID
,      ROUTE_NO
,      REVISION_STATUS_CODE
,      STAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.AHL_ROUTE_MR_V;

Dependencies

[top of page]

APPS.AHL_ROUTE_MR_V references the following:

APPS: AHL_MR_HEADERS_B; AHL_MR_ROUTES; AHL_ROUTES_B; FND_PROFILE - show dependent code

APPS.AHL_ROUTE_MR_V is not referenced by any database object