VIEW: MSC.MSC_WO_OPERATION_REL#

Source

View Text - Preformatted

select SUPPLY_ID SUPPLY_ID, PRECEDENCE_CONSTRAINT PRECEDENCE_CONSTRAINT, MIN_SEPARATION MIN_SEPARATION, MIN_SEP_TIME_UNIT MIN_SEP_TIME_UNIT, MAX_SEPARATION MAX_SEPARATION, MAX_SEP_TIME_UNIT MAX_SEP_TIME_UNIT, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM, FROM_OP_RES_SEQ_NUM FROM_OP_RES_SEQ_NUM, FROM_OP_DESC FROM_OP_DESC, TO_OP_SEQ_NUM TO_OP_SEQ_NUM, TO_OP_RES_SEQ_NUM TO_OP_RES_SEQ_NUM, TO_OP_DESC TO_OP_DESC, SR_INSTANCE_ID SR_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, 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, REFRESH_ID REFRESH_ID, WORKORDER_ID WORKORDER_ID, WIP_ENTITY_ID WIP_ENTITY_ID from "MSC"."MSC_WO_OPERATION_REL"

View Text - HTML Formatted

SELECT SUPPLY_ID SUPPLY_ID
, PRECEDENCE_CONSTRAINT PRECEDENCE_CONSTRAINT
, MIN_SEPARATION MIN_SEPARATION
, MIN_SEP_TIME_UNIT MIN_SEP_TIME_UNIT
, MAX_SEPARATION MAX_SEPARATION
, MAX_SEP_TIME_UNIT MAX_SEP_TIME_UNIT
, FROM_OP_SEQ_NUM FROM_OP_SEQ_NUM
, FROM_OP_RES_SEQ_NUM FROM_OP_RES_SEQ_NUM
, FROM_OP_DESC FROM_OP_DESC
, TO_OP_SEQ_NUM TO_OP_SEQ_NUM
, TO_OP_RES_SEQ_NUM TO_OP_RES_SEQ_NUM
, TO_OP_DESC TO_OP_DESC
, SR_INSTANCE_ID SR_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, 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
, REFRESH_ID REFRESH_ID
, WORKORDER_ID WORKORDER_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
FROM "MSC"."MSC_WO_OPERATION_REL"