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: MSC.MSC_ROUTING_OPERATIONS#

Source

View Text - Preformatted


select PLAN_ID PLAN_ID, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, SR_INSTANCE_ID SR_INSTANCE_ID, OPERATION_DESCRIPTION OPERATION_DESCRIPTION, EFFECTIVITY_DATE EFFECTIVITY_DATE, DISABLE_DATE DISABLE_DATE, FROM_UNIT_NUMBER FROM_UNIT_NUMBER, TO_UNIT_NUMBER TO_UNIT_NUMBER, OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG, OPERATION_TYPE OPERATION_TYPE, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, YIELD YIELD, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT, CUMULATIVE_YIELD CUMULATIVE_YIELD, REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD, NET_PLANNING_PERCENT NET_PLANNING_PERCENT, SETUP_DURATION SETUP_DURATION, TEAR_DOWN_DURATION TEAR_DOWN_DURATION, UOM_CODE UOM_CODE, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE, REFRESH_NUMBER REFRESH_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, USE_IN_PLAN USE_IN_PLAN, ORGANIZATION_ID ORGANIZATION_ID, STEP_QUANTITY STEP_QUANTITY, STEP_QUANTITY_UOM STEP_QUANTITY_UOM, NEW_PLAN_ID NEW_PLAN_ID, NEW_PLAN_LIST NEW_PLAN_LIST, APPLIED APPLIED, SIMULATION_SET_ID SIMULATION_SET_ID from "MSC"."MSC_ROUTING_OPERATIONS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, SR_INSTANCE_ID SR_INSTANCE_ID
, OPERATION_DESCRIPTION OPERATION_DESCRIPTION
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, DISABLE_DATE DISABLE_DATE
, FROM_UNIT_NUMBER FROM_UNIT_NUMBER
, TO_UNIT_NUMBER TO_UNIT_NUMBER
, OPTION_DEPENDENT_FLAG OPTION_DEPENDENT_FLAG
, OPERATION_TYPE OPERATION_TYPE
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, YIELD YIELD
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, CUMULATIVE_YIELD CUMULATIVE_YIELD
, REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD
, NET_PLANNING_PERCENT NET_PLANNING_PERCENT
, SETUP_DURATION SETUP_DURATION
, TEAR_DOWN_DURATION TEAR_DOWN_DURATION
, UOM_CODE UOM_CODE
, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE
, REFRESH_NUMBER REFRESH_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, USE_IN_PLAN USE_IN_PLAN
, ORGANIZATION_ID ORGANIZATION_ID
, STEP_QUANTITY STEP_QUANTITY
, STEP_QUANTITY_UOM STEP_QUANTITY_UOM
, NEW_PLAN_ID NEW_PLAN_ID
, NEW_PLAN_LIST NEW_PLAN_LIST
, APPLIED APPLIED
, SIMULATION_SET_ID SIMULATION_SET_ID
FROM "MSC"."MSC_ROUTING_OPERATIONS"