eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MTH.MTH_PRODUCTION_SCHEDULES_F#

Source

View Text - Preformatted


select WORKORDER_PK_KEY WORKORDER_PK_KEY, WORKORDER_PK WORKORDER_PK, WORKORDER_NAME WORKORDER_NAME, PLANT_FK_KEY PLANT_FK_KEY, WORKORDER_TYPE WORKORDER_TYPE, STATUS_CODE STATUS_CODE, SYSTEM_FK_KEY SYSTEM_FK_KEY, SOURCE_ORG_CODE SOURCE_ORG_CODE, 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, LINE_CODE LINE_CODE, 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, PARENT_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM, 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_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, 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_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, PARENT_WORKORDER_ID PARENT_WORKORDER_ID, 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, TERMINATED_IND TERMINATED_IND from "MTH"."MTH_PRODUCTION_SCHEDULES_F"

View Text - HTML Formatted

SELECT WORKORDER_PK_KEY WORKORDER_PK_KEY
, WORKORDER_PK WORKORDER_PK
, WORKORDER_NAME WORKORDER_NAME
, PLANT_FK_KEY PLANT_FK_KEY
, WORKORDER_TYPE WORKORDER_TYPE
, STATUS_CODE STATUS_CODE
, SYSTEM_FK_KEY SYSTEM_FK_KEY
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, 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
, LINE_CODE LINE_CODE
, 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
, PARENT_OPERATION_SEQ_NUM PARENT_OPERATION_SEQ_NUM
, 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_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
, 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_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, PARENT_WORKORDER_ID PARENT_WORKORDER_ID
, 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
, TERMINATED_IND TERMINATED_IND
FROM "MTH"."MTH_PRODUCTION_SCHEDULES_F"