VIEW: MSC.MSC_ST_ROUTING_OPERATIONS#

Source

View Text - Preformatted

select OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, 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, TEAR_DOWN_DURATION TEAR_DOWN_DURATION, SETUP_DURATION SETUP_DURATION, UOM_CODE UOM_CODE, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE, ORGANIZATION_ID ORGANIZATION_ID, DELETED_FLAG DELETED_FLAG, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, ROUTING_NAME ROUTING_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ORGANIZATION_CODE ORGANIZATION_CODE, ASSEMBLY_NAME ASSEMBLY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_OPERATION_SEQUENCE_ID SOURCE_OPERATION_SEQUENCE_ID, SOURCE_OPERATION_SEQ_NUM SOURCE_OPERATION_SEQ_NUM, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID, STEP_QUANTITY STEP_QUANTITY, STEP_QUANTITY_UOM STEP_QUANTITY_UOM from "MSC"."MSC_ST_ROUTING_OPERATIONS"

View Text - HTML Formatted

SELECT OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, 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
, TEAR_DOWN_DURATION TEAR_DOWN_DURATION
, SETUP_DURATION SETUP_DURATION
, UOM_CODE UOM_CODE
, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, DELETED_FLAG DELETED_FLAG
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, ROUTING_NAME ROUTING_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ORGANIZATION_CODE ORGANIZATION_CODE
, ASSEMBLY_NAME ASSEMBLY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_OPERATION_SEQUENCE_ID SOURCE_OPERATION_SEQUENCE_ID
, SOURCE_OPERATION_SEQ_NUM SOURCE_OPERATION_SEQ_NUM
, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID
, STEP_QUANTITY STEP_QUANTITY
, STEP_QUANTITY_UOM STEP_QUANTITY_UOM
FROM "MSC"."MSC_ST_ROUTING_OPERATIONS"