VIEW: MTH.MTH_PRODUCTION_SCHEDULES_I_ST#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, WIP_ENTITY_NAME WIP_ENTITY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, ORGANIZATION_ID ORGANIZATION_ID, DB_GLOBAL_NAME DB_GLOBAL_NAME, 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, 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, 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 PARENT_WORKORDER, PARENT_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE, 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, RECIPE_NUM RECIPE_NUM, RECIPE_VERSION RECIPE_VERSION, FORMULA_NUM FORMULA_NUM, FORMULA_VERSION FORMULA_VERSION, BATCH_TYPE BATCH_TYPE, REQ_COMPLETION_DATE REQ_COMPLETION_DATE, TERMINATED_IND TERMINATED_IND from "MTH"."MTH_PRODUCTION_SCHEDULES_I_STG"

View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, DB_GLOBAL_NAME DB_GLOBAL_NAME
, 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
, 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
, 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 PARENT_WORKORDER
, PARENT_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM
, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE
, 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
, RECIPE_NUM RECIPE_NUM
, RECIPE_VERSION RECIPE_VERSION
, FORMULA_NUM FORMULA_NUM
, FORMULA_VERSION FORMULA_VERSION
, BATCH_TYPE BATCH_TYPE
, REQ_COMPLETION_DATE REQ_COMPLETION_DATE
, TERMINATED_IND TERMINATED_IND
FROM "MTH"."MTH_PRODUCTION_SCHEDULES_I_STG"