[Home] [Help] [Dependency Information]
Object Name: | MTH_ENTITY_SUSTAIN_PERFORM_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.MTH_ENTITY_SUSTAIN_PERFORM_V is not referenced by any database object
|
|
|