VIEW: MSC.MSC_ST_JOB_OPERATION_NETWORKS#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM, TO_OP_SEQ_NUM TO_OP_SEQ_NUM, FROM_OP_SEQ_ID FROM_OP_SEQ_ID, TO_OP_SEQ_ID TO_OP_SEQ_ID, RECOMMENDED RECOMMENDED, TRANSITION_TYPE TRANSITION_TYPE, PLANNING_PCT PLANNING_PCT, 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, DELETED_FLAG DELETED_FLAG, REFRESH_ID REFRESH_ID, COMPANY_NAME COMPANY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, WIP_ENTITY_NAME WIP_ENTITY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, FROM_OPERATION_SEQ_CODE FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE TO_OPERATION_SEQ_CODE, FROM_OP_EFFECTIVITY_DATE FROM_OP_EFFECTIVITY_DATE, TO_OP_EFFECTIVITY_DATE TO_OP_EFFECTIVITY_DATE, ROUTING_NAME ROUTING_NAME, ASSEMBLY_NAME ASSEMBLY_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, 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, ERROR_TEXT ERROR_TEXT, PROCESS_FLAG PROCESS_FLAG, TO_WIP_ENTITY_ID TO_WIP_ENTITY_ID, TOP_WIP_ENTITY_ID TOP_WIP_ENTITY_ID, TRANSFER_QTY TRANSFER_QTY, TRANSFER_UOM TRANSFER_UOM, TRANSFER_PCT TRANSFER_PCT, FROM_ITEM_ID FROM_ITEM_ID, MINIMUM_TRANSFER_QTY MINIMUM_TRANSFER_QTY, MINIMUM_TIME_OFFSET MINIMUM_TIME_OFFSET, MAXIMUM_TIME_OFFSET MAXIMUM_TIME_OFFSET, TO_WIP_ENTITY_NAME TO_WIP_ENTITY_NAME, FROM_ITEM_NAME FROM_ITEM_NAME, APPLY_TO_CHARGES APPLY_TO_CHARGES, DEPENDENCY_TYPE DEPENDENCY_TYPE from "MSC"."MSC_ST_JOB_OPERATION_NETWORKS"

View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM
, TO_OP_SEQ_NUM TO_OP_SEQ_NUM
, FROM_OP_SEQ_ID FROM_OP_SEQ_ID
, TO_OP_SEQ_ID TO_OP_SEQ_ID
, RECOMMENDED RECOMMENDED
, TRANSITION_TYPE TRANSITION_TYPE
, PLANNING_PCT PLANNING_PCT
, 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
, DELETED_FLAG DELETED_FLAG
, REFRESH_ID REFRESH_ID
, COMPANY_NAME COMPANY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, FROM_OPERATION_SEQ_CODE FROM_OPERATION_SEQ_CODE
, TO_OPERATION_SEQ_CODE TO_OPERATION_SEQ_CODE
, FROM_OP_EFFECTIVITY_DATE FROM_OP_EFFECTIVITY_DATE
, TO_OP_EFFECTIVITY_DATE TO_OP_EFFECTIVITY_DATE
, ROUTING_NAME ROUTING_NAME
, ASSEMBLY_NAME ASSEMBLY_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, 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
, ERROR_TEXT ERROR_TEXT
, PROCESS_FLAG PROCESS_FLAG
, TO_WIP_ENTITY_ID TO_WIP_ENTITY_ID
, TOP_WIP_ENTITY_ID TOP_WIP_ENTITY_ID
, TRANSFER_QTY TRANSFER_QTY
, TRANSFER_UOM TRANSFER_UOM
, TRANSFER_PCT TRANSFER_PCT
, FROM_ITEM_ID FROM_ITEM_ID
, MINIMUM_TRANSFER_QTY MINIMUM_TRANSFER_QTY
, MINIMUM_TIME_OFFSET MINIMUM_TIME_OFFSET
, MAXIMUM_TIME_OFFSET MAXIMUM_TIME_OFFSET
, TO_WIP_ENTITY_NAME TO_WIP_ENTITY_NAME
, FROM_ITEM_NAME FROM_ITEM_NAME
, APPLY_TO_CHARGES APPLY_TO_CHARGES
, DEPENDENCY_TYPE DEPENDENCY_TYPE
FROM "MSC"."MSC_ST_JOB_OPERATION_NETWORKS"