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.ENG_WEB_REF_DESIG_V

Object Details

Object Name:	ENG_WEB_REF_DESIG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ENG.ENG_WEB_REF_DESIG_V
Subobject Name:
Status:	VALID

View Type

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

Revised Reference Designators are reference designators that are only
defined within an ECO. Designed for use in Oracle Self Service Web
Applications.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Foreign key to revised component
ACTION	VARCHAR2	(80)	Yes	Add or delete
COMPONENT_REFERENCE_DESIGNATOR	VARCHAR2	(15)	Yes	Reference Designator
REF_DESIGNATOR_COMMENT	VARCHAR2	(240)		Description of reference designator

Query Text

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


SELECT COMPONENT_SEQUENCE_ID
,      ACTION
,      COMPONENT_REFERENCE_DESIGNATOR
,      REF_DESIGNATOR_COMMENT
FROM APPS.ENG_WEB_REF_DESIG_V;

Dependencies

[top of page]

APPS.ENG_WEB_REF_DESIG_V references the following:

APPS: BOM_INVENTORY_COMPONENTS; BOM_REFERENCE_DESIGNATORS; ENG_REVISED_ITEMS; MFG_LOOKUPS

APPS.ENG_WEB_REF_DESIG_V is not referenced by any database object