DBA Data[Home] [Help] [Dependency Information]

VIEW: MTH.MTH_EQUIP_PROD_PERF_DETAIL_F#

Object Details
Object Name: MTH_EQUIP_PROD_PERF_DETAIL_F#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EPP_DETAIL_PK_KEY NUMBER
Yes
EQUIP_PROD_PERF_FK_KEY NUMBER
Yes
EQUIPMENT_FK_KEY NUMBER
Yes
SYSTEM_FK_KEY NUMBER
Yes
STATUS VARCHAR2 (30) Yes
FROM_TIME DATE
Yes
TO_TIME DATE
Yes
WORKORDER_FK_KEY NUMBER

ITEM_FK_KEY NUMBER

SEGMENT_FK_KEY NUMBER

SHIFT_WORKDAY_FK_KEY NUMBER

HOUR_FK_KEY NUMBER

DURATION_IN_HOURS NUMBER

QTY_COMPLETED NUMBER

QTY_SCRAP NUMBER

QTY_REJECTED NUMBER

QTY_REWORK NUMBER

QTY_GOOD NUMBER

QTY_OUTPUT NUMBER

QTY_UOM VARCHAR2 (5)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_SYSTEM_ID NUMBER

LAST_UPDATE_SYSTEM_ID NUMBER

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

LAST_UDPATE_LOGIN NUMBER

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# references the following:

SchemaMTH
TableMTH_EQUIP_PROD_PERF_DETAIL_F
MTH.MTH_EQUIP_PROD_PERF_DETAIL_F# is referenced by following:

SchemaAPPS
SynonymMTH_EQUIP_PROD_PERF_DETAIL_F