VIEW: MTH.MTH_EQUIP_PROD_PERF_DETAIL_F#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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