VIEW: MSC.MSC_STD_OP_RESOURCES#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, RESOURCE_ID RESOURCE_ID, ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, RESOURCE_USAGE RESOURCE_USAGE, BASIS_TYPE BASIS_TYPE, RESOURCE_UNITS RESOURCE_UNITS, SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM, UOM_CODE UOM_CODE, SCHEDULE_FLAG SCHEDULE_FLAG, OPERATION_CODE OPERATION_CODE, 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_NUMBER REFRESH_NUMBER from "MSC"."MSC_STD_OP_RESOURCES"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, RESOURCE_ID RESOURCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, RESOURCE_USAGE RESOURCE_USAGE
, BASIS_TYPE BASIS_TYPE
, RESOURCE_UNITS RESOURCE_UNITS
, SUBSTITUTE_GROUP_NUM SUBSTITUTE_GROUP_NUM
, UOM_CODE UOM_CODE
, SCHEDULE_FLAG SCHEDULE_FLAG
, OPERATION_CODE OPERATION_CODE
, 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_NUMBER REFRESH_NUMBER
FROM "MSC"."MSC_STD_OP_RESOURCES"