VIEW: MTH.MTH_EQUIP_OUTPUT_STG#

Source

View Text - Preformatted

select EQUIPMENT_FK EQUIPMENT_FK, ITEM_FK ITEM_FK, SHIFT_WORKDAY_FK SHIFT_WORKDAY_FK, WORKORDER_FK WORKORDER_FK, READING_TIME READING_TIME, QTY_COMPLETED QTY_COMPLETED, QTY_SCRAP QTY_SCRAP, QTY_REJECTED QTY_REJECTED, QTY_REWORK QTY_REWORK, QTY_UOM QTY_UOM, QTY_GOOD QTY_GOOD, QTY_OUTPUT QTY_OUTPUT, SYSTEM_FK SYSTEM_FK, RECIPE_VERSION RECIPE_VERSION, RECIPE_NUM RECIPE_NUM, SEGMENT_FK SEGMENT_FK, USER_DIM1_FK USER_DIM1_FK, USER_DIM2_FK USER_DIM2_FK, USER_DIM3_FK USER_DIM3_FK, USER_DIM4_FK USER_DIM4_FK, USER_DIM5_FK USER_DIM5_FK, 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, PROCESSING_FLAG PROCESSING_FLAG, SCRAP_REASON_CODE SCRAP_REASON_CODE, ERR_CODE ERR_CODE from "MTH"."MTH_EQUIP_OUTPUT_STG"

View Text - HTML Formatted

SELECT EQUIPMENT_FK EQUIPMENT_FK
, ITEM_FK ITEM_FK
, SHIFT_WORKDAY_FK SHIFT_WORKDAY_FK
, WORKORDER_FK WORKORDER_FK
, READING_TIME READING_TIME
, QTY_COMPLETED QTY_COMPLETED
, QTY_SCRAP QTY_SCRAP
, QTY_REJECTED QTY_REJECTED
, QTY_REWORK QTY_REWORK
, QTY_UOM QTY_UOM
, QTY_GOOD QTY_GOOD
, QTY_OUTPUT QTY_OUTPUT
, SYSTEM_FK SYSTEM_FK
, RECIPE_VERSION RECIPE_VERSION
, RECIPE_NUM RECIPE_NUM
, SEGMENT_FK SEGMENT_FK
, USER_DIM1_FK USER_DIM1_FK
, USER_DIM2_FK USER_DIM2_FK
, USER_DIM3_FK USER_DIM3_FK
, USER_DIM4_FK USER_DIM4_FK
, USER_DIM5_FK USER_DIM5_FK
, 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
, PROCESSING_FLAG PROCESSING_FLAG
, SCRAP_REASON_CODE SCRAP_REASON_CODE
, ERR_CODE ERR_CODE
FROM "MTH"."MTH_EQUIP_OUTPUT_STG"