VIEW: MTH.MTH_PRODUCTION_SCHEDULES_ERR#

Source

View Text - Preformatted

select WORKORDER_PK WORKORDER_PK, SYSTEM_FK SYSTEM_FK, WORKORDER_TYPE WORKORDER_TYPE, STATUS STATUS, PLANNED_START_DATE PLANNED_START_DATE, PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE, DATE_RELEASED DATE_RELEASED, ERP_ACTUAL_START_DATE ERP_ACTUAL_START_DATE, ERP_ACTUAL_COMPLETION_DATE ERP_ACTUAL_COMPLETION_DATE, EBS_ENTITY_ID EBS_ENTITY_ID, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID, BOM_REVISION BOM_REVISION, ROUTING_REVISION ROUTING_REVISION, BOM_REVISION_DATE BOM_REVISION_DATE, ROUTING_REVISION_DATE ROUTING_REVISION_DATE, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID, DEMAND_CLASS DEMAND_CLASS, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, BUILD_SEQUENCE BUILD_SEQUENCE, WORKORDER_NAME WORKORDER_NAME, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, KANBAN_CARD_ID KANBAN_CARD_ID, LINE_CODE LINE_CODE, PARENT_WORKORDER_ID PARENT_WORKORDER_ID, PARENT_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM, SOURCE_ORG_CODE SOURCE_ORG_CODE, 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_ATTR6 USER_ATTR6, USER_ATTR7 USER_ATTR7, USER_ATTR8 USER_ATTR8, USER_ATTR9 USER_ATTR9, USER_ATTR10 USER_ATTR10, USER_ATTR11 USER_ATTR11, USER_ATTR12 USER_ATTR12, USER_ATTR13 USER_ATTR13, USER_ATTR14 USER_ATTR14, USER_ATTR15 USER_ATTR15, USER_ATTR16 USER_ATTR16, USER_ATTR17 USER_ATTR17, USER_ATTR18 USER_ATTR18, USER_ATTR19 USER_ATTR19, USER_ATTR20 USER_ATTR20, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, REPROCESS_READY_YN REPROCESS_READY_YN, 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, RECIPE_NUM RECIPE_NUM, RECIPE_VERSION RECIPE_VERSION, FORMULA_NUM FORMULA_NUM, FORMULA_VERSION FORMULA_VERSION, REQ_COMPLETION_DATE REQ_COMPLETION_DATE, BATCH_TYPE BATCH_TYPE, ERR_CODE ERR_CODE, TERMINATED_IND TERMINATED_IND from "MTH"."MTH_PRODUCTION_SCHEDULES_ERR"

View Text - HTML Formatted

SELECT WORKORDER_PK WORKORDER_PK
, SYSTEM_FK SYSTEM_FK
, WORKORDER_TYPE WORKORDER_TYPE
, STATUS STATUS
, PLANNED_START_DATE PLANNED_START_DATE
, PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE
, DATE_RELEASED DATE_RELEASED
, ERP_ACTUAL_START_DATE ERP_ACTUAL_START_DATE
, ERP_ACTUAL_COMPLETION_DATE ERP_ACTUAL_COMPLETION_DATE
, EBS_ENTITY_ID EBS_ENTITY_ID
, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID
, BOM_REVISION BOM_REVISION
, ROUTING_REVISION ROUTING_REVISION
, BOM_REVISION_DATE BOM_REVISION_DATE
, ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID
, DEMAND_CLASS DEMAND_CLASS
, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID
, BUILD_SEQUENCE BUILD_SEQUENCE
, WORKORDER_NAME WORKORDER_NAME
, DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, KANBAN_CARD_ID KANBAN_CARD_ID
, LINE_CODE LINE_CODE
, PARENT_WORKORDER_ID PARENT_WORKORDER_ID
, PARENT_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, 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_ATTR6 USER_ATTR6
, USER_ATTR7 USER_ATTR7
, USER_ATTR8 USER_ATTR8
, USER_ATTR9 USER_ATTR9
, USER_ATTR10 USER_ATTR10
, USER_ATTR11 USER_ATTR11
, USER_ATTR12 USER_ATTR12
, USER_ATTR13 USER_ATTR13
, USER_ATTR14 USER_ATTR14
, USER_ATTR15 USER_ATTR15
, USER_ATTR16 USER_ATTR16
, USER_ATTR17 USER_ATTR17
, USER_ATTR18 USER_ATTR18
, USER_ATTR19 USER_ATTR19
, USER_ATTR20 USER_ATTR20
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, REPROCESS_READY_YN REPROCESS_READY_YN
, 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
, RECIPE_NUM RECIPE_NUM
, RECIPE_VERSION RECIPE_VERSION
, FORMULA_NUM FORMULA_NUM
, FORMULA_VERSION FORMULA_VERSION
, REQ_COMPLETION_DATE REQ_COMPLETION_DATE
, BATCH_TYPE BATCH_TYPE
, ERR_CODE ERR_CODE
, TERMINATED_IND TERMINATED_IND
FROM "MTH"."MTH_PRODUCTION_SCHEDULES_ERR"