VIEW: MTH.MTH_PRODUCTION_SEGMENTS_ERR#

Source

View Text - Preformatted

select WORKORDER_FK WORKORDER_FK, SEGMENT_PK SEGMENT_PK, ITEM_FK ITEM_FK, START_QUANTITY_G START_QUANTITY_G, START_QUANTITY_SG START_QUANTITY_SG, PRIMARY_UOM PRIMARY_UOM, SECONDARY_UOM SECONDARY_UOM, ACTUAL_COMP_QTY_G ACTUAL_COMP_QTY_G, ACTUAL_COMP_QTY_SG ACTUAL_COMP_QTY_SG, ACTUAL_REJECTED_QTY_G ACTUAL_REJECTED_QTY_G, ACTUAL_REWORKED_QTY_G ACTUAL_REWORKED_QTY_G, ACTUAL_SCRAP_QTY_G ACTUAL_SCRAP_QTY_G, ACTUAL_REJECTED_QTY_SG ACTUAL_REJECTED_QTY_SG, ACTUAL_REWORKED_QTY_SG ACTUAL_REWORKED_QTY_SG, ACTUAL_SCRAP_QTY_SG ACTUAL_SCRAP_QTY_SG, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE, SYSTEM_FK SYSTEM_FK, REPROCESS_READY_YN REPROCESS_READY_YN, 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, ERR$$$_AUDIT_RUN_ID ERR$$$_AUDIT_RUN_ID, ERR$$$_AUDIT_DETAIL_ID ERR$$$_AUDIT_DETAIL_ID, ERR$$$_ERROR_ID ERR$$$_ERROR_ID, ERR$$$_ERROR_REASON ERR$$$_ERROR_REASON, ERR$$$_SEVERITY ERR$$$_SEVERITY, ERR$$$_OPERATOR_NAME ERR$$$_OPERATOR_NAME, ERR$$$_ERROR_OBJECT_NAME ERR$$$_ERROR_OBJECT_NAME, SEGMENT_STATUS SEGMENT_STATUS, PLANNED_START_DATE PLANNED_START_DATE, PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE, REQ_COMPLETION_DATE REQ_COMPLETION_DATE, ERR_CODE ERR_CODE from "MTH"."MTH_PRODUCTION_SEGMENTS_ERR"

View Text - HTML Formatted

SELECT WORKORDER_FK WORKORDER_FK
, SEGMENT_PK SEGMENT_PK
, ITEM_FK ITEM_FK
, START_QUANTITY_G START_QUANTITY_G
, START_QUANTITY_SG START_QUANTITY_SG
, PRIMARY_UOM PRIMARY_UOM
, SECONDARY_UOM SECONDARY_UOM
, ACTUAL_COMP_QTY_G ACTUAL_COMP_QTY_G
, ACTUAL_COMP_QTY_SG ACTUAL_COMP_QTY_SG
, ACTUAL_REJECTED_QTY_G ACTUAL_REJECTED_QTY_G
, ACTUAL_REWORKED_QTY_G ACTUAL_REWORKED_QTY_G
, ACTUAL_SCRAP_QTY_G ACTUAL_SCRAP_QTY_G
, ACTUAL_REJECTED_QTY_SG ACTUAL_REJECTED_QTY_SG
, ACTUAL_REWORKED_QTY_SG ACTUAL_REWORKED_QTY_SG
, ACTUAL_SCRAP_QTY_SG ACTUAL_SCRAP_QTY_SG
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE
, SYSTEM_FK SYSTEM_FK
, REPROCESS_READY_YN REPROCESS_READY_YN
, 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
, ERR$$$_AUDIT_RUN_ID ERR$$$_AUDIT_RUN_ID
, ERR$$$_AUDIT_DETAIL_ID ERR$$$_AUDIT_DETAIL_ID
, ERR$$$_ERROR_ID ERR$$$_ERROR_ID
, ERR$$$_ERROR_REASON ERR$$$_ERROR_REASON
, ERR$$$_SEVERITY ERR$$$_SEVERITY
, ERR$$$_OPERATOR_NAME ERR$$$_OPERATOR_NAME
, ERR$$$_ERROR_OBJECT_NAME ERR$$$_ERROR_OBJECT_NAME
, SEGMENT_STATUS SEGMENT_STATUS
, PLANNED_START_DATE PLANNED_START_DATE
, PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE
, REQ_COMPLETION_DATE REQ_COMPLETION_DATE
, ERR_CODE ERR_CODE
FROM "MTH"."MTH_PRODUCTION_SEGMENTS_ERR"