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_CHANGE_HDR_ITEM_SUBJECTS_V

Object Details

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

View Type

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

ENG_CHANGE_HDR_ITEM_SUBJECTS_V View stores information to display change header subject information.

[View Source]

Columns

Name	Datatype	Length	Comments
CHANGE_ID	NUMBER		Change internal identifier
ITEM_NUMBER	VARCHAR2	(40)	Item number
ITEM_REVISION	VARCHAR2	(80)	Item revision

Query Text

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


SELECT CHANGE_ID
,      ITEM_NUMBER
,      ITEM_REVISION
FROM APPS.ENG_CHANGE_HDR_ITEM_SUBJECTS_V;

Dependencies

[top of page]

APPS.ENG_CHANGE_HDR_ITEM_SUBJECTS_V references the following:

APPS: ENG_CHANGE_SUBJECTS; MTL_ITEM_REVISIONS_B; MTL_SYSTEM_ITEMS_KFV

APPS.ENG_CHANGE_HDR_ITEM_SUBJECTS_V is not referenced by any database object