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]

TABLE: MTH.MTH_EQUIP_PROD_PERF_DETAIL_F

Object Details

Object Name:	MTH_EQUIP_PROD_PERF_DETAIL_F
Object Type:	TABLE
Owner:	MTH
FND Design Data:	MTH.MTH_EQUIP_PROD_PERF_DETAIL_F
Subobject Name:
Status:	VALID

It contains similar information in equipment production performace with more granular status information.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTH_EQUIP_PROD_PERF_DTL_F_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EPP_DETAIL_PK_KEY
MTH_EQUIP_PROD_PERF_DTL_F_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EQUIPMENT_FK_KEY STATUS FROM_TIME TO_TIME

Columns

Name	Datatype	Length	Mandatory	Comments
EPP_DETAIL_PK_KEY	NUMBER		Yes	System generated surrogate key for Equipment Production Performance Detail identifier
EQUIP_PROD_PERF_FK_KEY	NUMBER		Yes	Reference to Equipment Production Performance
EQUIPMENT_FK_KEY	NUMBER		Yes	Reference to equipment
SYSTEM_FK_KEY	NUMBER		Yes	Reference to system
STATUS	VARCHAR2	(30)	Yes	Status
FROM_TIME	DATE		Yes	From time
TO_TIME	DATE		Yes	To time
WORKORDER_FK_KEY	NUMBER			Reference to workorder
ITEM_FK_KEY	NUMBER			Reference to item
SEGMENT_FK_KEY	NUMBER			Reference to segment
SHIFT_WORKDAY_FK_KEY	NUMBER			Reference to shift workday
HOUR_FK_KEY	NUMBER			Reference to hour
DURATION_IN_HOURS	NUMBER			Duration in hours
QTY_COMPLETED	NUMBER			Completed Quantity
QTY_SCRAP	NUMBER			Scrap Quantity
QTY_REJECTED	NUMBER			Rejected Quantity
QTY_REWORK	NUMBER			Rework Quantity
QTY_GOOD	NUMBER			Good Quantity
QTY_OUTPUT	NUMBER			Output Quantity
QTY_UOM	VARCHAR2	(5)		Quantity Unit of Measure
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATION_SYSTEM_ID	NUMBER			Standard who column
LAST_UPDATE_SYSTEM_ID	NUMBER			Standard who column
CREATED_BY	NUMBER			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column
LAST_UDPATE_LOGIN	NUMBER			Standard who column

Query Text

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


SELECT EPP_DETAIL_PK_KEY
,      EQUIP_PROD_PERF_FK_KEY
,      EQUIPMENT_FK_KEY
,      SYSTEM_FK_KEY
,      STATUS
,      FROM_TIME
,      TO_TIME
,      WORKORDER_FK_KEY
,      ITEM_FK_KEY
,      SEGMENT_FK_KEY
,      SHIFT_WORKDAY_FK_KEY
,      HOUR_FK_KEY
,      DURATION_IN_HOURS
,      QTY_COMPLETED
,      QTY_SCRAP
,      QTY_REJECTED
,      QTY_REWORK
,      QTY_GOOD
,      QTY_OUTPUT
,      QTY_UOM
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UDPATE_LOGIN
FROM MTH.MTH_EQUIP_PROD_PERF_DETAIL_F;

Dependencies

[top of page]

MTH.MTH_EQUIP_PROD_PERF_DETAIL_F does not reference any database object

MTH.MTH_EQUIP_PROD_PERF_DETAIL_F is referenced by following:

APPS: MTH_SHIFT_REFERENCE_MV
MTH: MTH_EQUIP_PROD_PERF_DETAIL_F#