VIEW: MTH.MTH_EQUIP_PROD_SCHEDULE_F#

Source

View Text - Preformatted

select EQUIP_SCHEDULE_PK_KEY EQUIP_SCHEDULE_PK_KEY, EQUIP_SCHEDULE_PK EQUIP_SCHEDULE_PK, EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY, WORKORDER_FK_KEY WORKORDER_FK_KEY, SEGMENT_FK_KEY SEGMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY, ITEM_FK_KEY ITEM_FK_KEY, SCHEDULE_FROM_DATE SCHEDULE_FROM_DATE, SCHEDULE_TO_DATE SCHEDULE_TO_DATE, PLANNED_QTY_G PLANNED_QTY_G, PLANNED_QTY_SG PLANNED_QTY_SG, PRIMARY_UOM PRIMARY_UOM, SECONDARY_UOM SECONDARY_UOM, SYSTEM_FK_KEY SYSTEM_FK_KEY, USER_DIM1_FK_KEY USER_DIM1_FK_KEY, USER_DIM2_FK_KEY USER_DIM2_FK_KEY, USER_DIM3_FK_KEY USER_DIM3_FK_KEY, USER_DIM4_FK_KEY USER_DIM4_FK_KEY, USER_DIM5_FK_KEY USER_DIM5_FK_KEY, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, 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_UPDATE_LOGIN LAST_UPDATE_LOGIN, ITEM_COST ITEM_COST, STANDARD_RATE_1 STANDARD_RATE_1, STATUS_CODE STATUS_CODE from "MTH"."MTH_EQUIP_PROD_SCHEDULE_F"

View Text - HTML Formatted

SELECT EQUIP_SCHEDULE_PK_KEY EQUIP_SCHEDULE_PK_KEY
, EQUIP_SCHEDULE_PK EQUIP_SCHEDULE_PK
, EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
, WORKORDER_FK_KEY WORKORDER_FK_KEY
, SEGMENT_FK_KEY SEGMENT_FK_KEY
, SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY
, ITEM_FK_KEY ITEM_FK_KEY
, SCHEDULE_FROM_DATE SCHEDULE_FROM_DATE
, SCHEDULE_TO_DATE SCHEDULE_TO_DATE
, PLANNED_QTY_G PLANNED_QTY_G
, PLANNED_QTY_SG PLANNED_QTY_SG
, PRIMARY_UOM PRIMARY_UOM
, SECONDARY_UOM SECONDARY_UOM
, SYSTEM_FK_KEY SYSTEM_FK_KEY
, USER_DIM1_FK_KEY USER_DIM1_FK_KEY
, USER_DIM2_FK_KEY USER_DIM2_FK_KEY
, USER_DIM3_FK_KEY USER_DIM3_FK_KEY
, USER_DIM4_FK_KEY USER_DIM4_FK_KEY
, USER_DIM5_FK_KEY USER_DIM5_FK_KEY
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, 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_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ITEM_COST ITEM_COST
, STANDARD_RATE_1 STANDARD_RATE_1
, STATUS_CODE STATUS_CODE
FROM "MTH"."MTH_EQUIP_PROD_SCHEDULE_F"