VIEW: MSC.MSC_ST_JOB_OPERATIONS#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, SR_INSTANCE_ID SR_INSTANCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RECOMMENDED RECOMMENDED, NETWORK_START_END NETWORK_START_END, RECO_START_DATE RECO_START_DATE, RECO_COMPLETION_DATE RECO_COMPLETION_DATE, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, ORGANIZATION_ID ORGANIZATION_ID, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE, DEPARTMENT_ID DEPARTMENT_ID, OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, EFFECTIVITY_DATE EFFECTIVITY_DATE, DISABLE_DATE DISABLE_DATE, OPERATION_TYPE OPERATION_TYPE, YIELD YIELD, CUMULATIVE_YIELD CUMULATIVE_YIELD, REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD, NET_PLANNING_PERCENT NET_PLANNING_PERCENT, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, DELETED_FLAG DELETED_FLAG, COMPANY_NAME COMPANY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, WIP_ENTITY_NAME WIP_ENTITY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, ROUTING_NAME ROUTING_NAME, ASSEMBLY_NAME ASSEMBLY_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, DEPARTMENT_CODE DEPARTMENT_CODE, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, OPERATION_CODE OPERATION_CODE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_END_DATE ACTUAL_END_DATE, OPERATION_DESC OPERATION_DESC from "MSC"."MSC_ST_JOB_OPERATIONS"

View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RECOMMENDED RECOMMENDED
, NETWORK_START_END NETWORK_START_END
, RECO_START_DATE RECO_START_DATE
, RECO_COMPLETION_DATE RECO_COMPLETION_DATE
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, STANDARD_OPERATION_CODE STANDARD_OPERATION_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, OPERATION_LEAD_TIME_PERCENT OPERATION_LEAD_TIME_PERCENT
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, DISABLE_DATE DISABLE_DATE
, OPERATION_TYPE OPERATION_TYPE
, YIELD YIELD
, CUMULATIVE_YIELD CUMULATIVE_YIELD
, REVERSE_CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD
, NET_PLANNING_PERCENT NET_PLANNING_PERCENT
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, DELETED_FLAG DELETED_FLAG
, COMPANY_NAME COMPANY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, ROUTING_NAME ROUTING_NAME
, ASSEMBLY_NAME ASSEMBLY_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, DEPARTMENT_CODE DEPARTMENT_CODE
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, OPERATION_CODE OPERATION_CODE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_END_DATE ACTUAL_END_DATE
, OPERATION_DESC OPERATION_DESC
FROM "MSC"."MSC_ST_JOB_OPERATIONS"