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

Object Details

Object Name:	MTH_ENTITY_SUSTAIN_PERFORM_V
Object Type:	VIEW
Owner:	APPS
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	Comments
ENTITY_FK_KEY	NUMBER		Reference to entity
SYSTEM_FK_KEY	NUMBER		Reference to system
WORKORDER_FK_KEY	NUMBER		Reference to workorder
SEGMENT_FK_KEY	NUMBER		Reference to operation
SHIFT_WORKDAY_FK_KEY	NUMBER		Reference to shift workday
HOUR_FK_KEY	NUMBER		Reference to hour
RUN_HOURS	NUMBER		Number of hours the equipment is running
IDLE_HOURS	NUMBER		Number of hours the equipment is idle
DOWN_HOURS	NUMBER		Number of hours the equipment is down
OFF_HOURS	NUMBER		Number of hours the equipment is turned off
QTY_COMPLETED	NUMBER		Completed Quantity
QTY_OUTPUT	NUMBER		Output Quantity
QTY_GOOD	NUMBER		Good Quantity
QTY_SCRAP	NUMBER		Scrap Quantity
QTY_REJECTED	NUMBER		Rejected Quantity
QTY_REWORK	NUMBER		Rework Quantity
SUSTAIN_ASPECT_CODE	VARCHAR2	(30)	Sustainability aspect code
SUSTAIN_ASPECT_UOM	VARCHAR2	(80)	Sustain Aspect Uom
SUSTAIN_ASPECT_CONSUMED	NUMBER		Sustain Aspect Consumed

Query Text

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


SELECT ENTITY_FK_KEY
,      SYSTEM_FK_KEY
,      WORKORDER_FK_KEY
,      SEGMENT_FK_KEY
,      SHIFT_WORKDAY_FK_KEY
,      HOUR_FK_KEY
,      RUN_HOURS
,      IDLE_HOURS
,      DOWN_HOURS
,      OFF_HOURS
,      QTY_COMPLETED
,      QTY_OUTPUT
,      QTY_GOOD
,      QTY_SCRAP
,      QTY_REJECTED
,      QTY_REWORK
,      SUSTAIN_ASPECT_CODE
,      SUSTAIN_ASPECT_UOM
,      SUSTAIN_ASPECT_CONSUMED
FROM APPS.MTH_ENTITY_SUSTAIN_PERFORM_V;

Dependencies

[top of page]

APPS.MTH_ENTITY_SUSTAIN_PERFORM_V references the following:

APPS: MTH_ENTITY_SUSTAIN_ASPECT; MTH_EQUIPMENTS_D; MTH_EQUIP_PROD_PERFORMANCE_F; MTH_EQUIP_PROD_SUSTAIN_F; MTH_SUSTAIN_ASPECTS

APPS.MTH_ENTITY_SUSTAIN_PERFORM_V is not referenced by any database object