VIEW: MSC.MSC_ST_OPERATION_RESOURCES#

Source

View Text - Preformatted

select ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, RESOURCE_TYPE RESOURCE_TYPE, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_ID RESOURCE_ID, ALTERNATE_NUMBER ALTERNATE_NUMBER, PRINCIPAL_FLAG PRINCIPAL_FLAG, BASIS_TYPE BASIS_TYPE, RESOURCE_USAGE RESOURCE_USAGE, MAX_RESOURCE_UNITS MAX_RESOURCE_UNITS, RESOURCE_UNITS RESOURCE_UNITS, UOM_CODE UOM_CODE, 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, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, ROUTING_NAME ROUTING_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ORGANIZATION_CODE ORGANIZATION_CODE, ASSEMBLY_NAME ASSEMBLY_NAME, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE, SR_INSTANCE_CODE SR_INSTANCE_CODE, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE RESOURCE_SEQ_CODE, DEPARTMENT_ID DEPARTMENT_ID, DEPARTMENT_CODE DEPARTMENT_CODE, RESOURCE_CODE RESOURCE_CODE, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID, SCHEDULE_FLAG SCHEDULE_FLAG, ORGANIZATION_ID ORGANIZATION_ID, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT, SOURCE_ROUTING_SEQUENCE_ID SOURCE_ROUTING_SEQUENCE_ID, SOURCE_OPERATION_SEQUENCE_ID SOURCE_OPERATION_SEQUENCE_ID, SOURCE_RESOURCE_SEQ_NUM SOURCE_RESOURCE_SEQ_NUM, SOURCE_RESOURCE_ID SOURCE_RESOURCE_ID, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SETUP_ID SETUP_ID, MINIMUM_CAPACITY MINIMUM_CAPACITY, MAXIMUM_CAPACITY MAXIMUM_CAPACITY, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM, BREAKABLE_ACTIVITY_FLAG BREAKABLE_ACTIVITY_FLAG, SETUP_CODE SETUP_CODE, ORIG_RESOURCE_SEQ_CODE ORIG_RESOURCE_SEQ_CODE from "MSC"."MSC_ST_OPERATION_RESOURCES"

View Text - HTML Formatted

SELECT ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, RESOURCE_TYPE RESOURCE_TYPE
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_ID RESOURCE_ID
, ALTERNATE_NUMBER ALTERNATE_NUMBER
, PRINCIPAL_FLAG PRINCIPAL_FLAG
, BASIS_TYPE BASIS_TYPE
, RESOURCE_USAGE RESOURCE_USAGE
, MAX_RESOURCE_UNITS MAX_RESOURCE_UNITS
, RESOURCE_UNITS RESOURCE_UNITS
, UOM_CODE UOM_CODE
, 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
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, ROUTING_NAME ROUTING_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ORGANIZATION_CODE ORGANIZATION_CODE
, ASSEMBLY_NAME ASSEMBLY_NAME
, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, RESOURCE_SEQ_CODE RESOURCE_SEQ_CODE
, DEPARTMENT_ID DEPARTMENT_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, RESOURCE_CODE RESOURCE_CODE
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID
, SCHEDULE_FLAG SCHEDULE_FLAG
, ORGANIZATION_ID ORGANIZATION_ID
, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT
, SOURCE_ROUTING_SEQUENCE_ID SOURCE_ROUTING_SEQUENCE_ID
, SOURCE_OPERATION_SEQUENCE_ID SOURCE_OPERATION_SEQUENCE_ID
, SOURCE_RESOURCE_SEQ_NUM SOURCE_RESOURCE_SEQ_NUM
, SOURCE_RESOURCE_ID SOURCE_RESOURCE_ID
, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SETUP_ID SETUP_ID
, MINIMUM_CAPACITY MINIMUM_CAPACITY
, MAXIMUM_CAPACITY MAXIMUM_CAPACITY
, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM
, BREAKABLE_ACTIVITY_FLAG BREAKABLE_ACTIVITY_FLAG
, SETUP_CODE SETUP_CODE
, ORIG_RESOURCE_SEQ_CODE ORIG_RESOURCE_SEQ_CODE
FROM "MSC"."MSC_ST_OPERATION_RESOURCES"