VIEW: MSC.MSC_OPERATION_RESOURCE_SEQS#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, SCHEDULE_FLAG SCHEDULE_FLAG, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT, DEPARTMENT_ID DEPARTMENT_ID, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_NUMBER REFRESH_NUMBER, 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, CUMMULATIVE_PCT CUMMULATIVE_PCT, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, NEW_PLAN_ID NEW_PLAN_ID, NEW_PLAN_LIST NEW_PLAN_LIST, APPLIED APPLIED, SIMULATION_SET_ID SIMULATION_SET_ID from "MSC"."MSC_OPERATION_RESOURCE_SEQS"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, SCHEDULE_FLAG SCHEDULE_FLAG
, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT
, DEPARTMENT_ID DEPARTMENT_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_NUMBER REFRESH_NUMBER
, 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
, CUMMULATIVE_PCT CUMMULATIVE_PCT
, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, NEW_PLAN_ID NEW_PLAN_ID
, NEW_PLAN_LIST NEW_PLAN_LIST
, APPLIED APPLIED
, SIMULATION_SET_ID SIMULATION_SET_ID
FROM "MSC"."MSC_OPERATION_RESOURCE_SEQS"