VIEW: MSC.MSC_ST_ROUTINGS#

Source

View Text - Preformatted

select ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, ROUTING_TYPE ROUTING_TYPE, ROUTING_COMMENT ROUTING_COMMENT, PRIORITY PRIORITY, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, LINE_ID LINE_ID, UOM_CODE UOM_CODE, CFM_ROUTING_FLAG CFM_ROUTING_FLAG, CTP_FLAG CTP_FLAG, ROUTING_QUANTITY ROUTING_QUANTITY, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID, COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID, MIXED_MODEL_MAP_FLAG MIXED_MODEL_MAP_FLAG, TOTAL_PRODUCT_CYCLE_TIME TOTAL_PRODUCT_CYCLE_TIME, 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, FIRST_OP_SEQ_NUM FIRST_OP_SEQ_NUM, LAST_OP_SEQ_NUM LAST_OP_SEQ_NUM, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, BOM_NAME BOM_NAME, ROUTING_NAME ROUTING_NAME, BILL_SEQUENCE_ID BILL_SEQUENCE_ID, ORGANIZATION_CODE ORGANIZATION_CODE, ASSEMBLY_NAME ASSEMBLY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, LINE_CODE LINE_CODE, PROJECT_NUMBER PROJECT_NUMBER, TASK_NUMBER TASK_NUMBER, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, FIRST_OPERATION_SEQ_CODE FIRST_OPERATION_SEQ_CODE, LAST_OPERATION_SEQ_CODE LAST_OPERATION_SEQ_CODE, COMMON_ROUTING_NAME COMMON_ROUTING_NAME, ITEM_PROCESS_COST ITEM_PROCESS_COST, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ASSEMBLY_ITEM_ID SOURCE_ASSEMBLY_ITEM_ID, SOURCE_ROUTING_SEQUENCE_ID SOURCE_ROUTING_SEQUENCE_ID, SOURCE_TASK_ID SOURCE_TASK_ID, SOURCE_PROJECT_ID SOURCE_PROJECT_ID, SOURCE_BILL_SEQUENCE_ID SOURCE_BILL_SEQUENCE_ID, SOURCE_COMMON_ROUTING_SEQ_ID SOURCE_COMMON_ROUTING_SEQ_ID, SOURCE_LINE_ID SOURCE_LINE_ID, AUTO_STEP_QTY_FLAG AUTO_STEP_QTY_FLAG from "MSC"."MSC_ST_ROUTINGS"

View Text - HTML Formatted

SELECT ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID
, ROUTING_TYPE ROUTING_TYPE
, ROUTING_COMMENT ROUTING_COMMENT
, PRIORITY PRIORITY
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, LINE_ID LINE_ID
, UOM_CODE UOM_CODE
, CFM_ROUTING_FLAG CFM_ROUTING_FLAG
, CTP_FLAG CTP_FLAG
, ROUTING_QUANTITY ROUTING_QUANTITY
, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID
, COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID
, MIXED_MODEL_MAP_FLAG MIXED_MODEL_MAP_FLAG
, TOTAL_PRODUCT_CYCLE_TIME TOTAL_PRODUCT_CYCLE_TIME
, 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
, FIRST_OP_SEQ_NUM FIRST_OP_SEQ_NUM
, LAST_OP_SEQ_NUM LAST_OP_SEQ_NUM
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, BOM_NAME BOM_NAME
, ROUTING_NAME ROUTING_NAME
, BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, ORGANIZATION_CODE ORGANIZATION_CODE
, ASSEMBLY_NAME ASSEMBLY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, LINE_CODE LINE_CODE
, PROJECT_NUMBER PROJECT_NUMBER
, TASK_NUMBER TASK_NUMBER
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, FIRST_OPERATION_SEQ_CODE FIRST_OPERATION_SEQ_CODE
, LAST_OPERATION_SEQ_CODE LAST_OPERATION_SEQ_CODE
, COMMON_ROUTING_NAME COMMON_ROUTING_NAME
, ITEM_PROCESS_COST ITEM_PROCESS_COST
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ASSEMBLY_ITEM_ID SOURCE_ASSEMBLY_ITEM_ID
, SOURCE_ROUTING_SEQUENCE_ID SOURCE_ROUTING_SEQUENCE_ID
, SOURCE_TASK_ID SOURCE_TASK_ID
, SOURCE_PROJECT_ID SOURCE_PROJECT_ID
, SOURCE_BILL_SEQUENCE_ID SOURCE_BILL_SEQUENCE_ID
, SOURCE_COMMON_ROUTING_SEQ_ID SOURCE_COMMON_ROUTING_SEQ_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, AUTO_STEP_QTY_FLAG AUTO_STEP_QTY_FLAG
FROM "MSC"."MSC_ST_ROUTINGS"