VIEW: MSC.MSC_BIS_RES_SUMMARY#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, RESOURCE_DATE RESOURCE_DATE, REQUIRED_HOURS REQUIRED_HOURS, AVAILABLE_HOURS AVAILABLE_HOURS, UTILIZATION UTILIZATION, DEPARTMENT_CLASS DEPARTMENT_CLASS, RESOURCE_GROUP RESOURCE_GROUP, 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, OVERUTILIZATION_COST OVERUTILIZATION_COST, UTIL_BY_WT_VOL UTIL_BY_WT_VOL, BATCH_COUNT BATCH_COUNT, DETAIL_LEVEL DETAIL_LEVEL, PERIOD_TYPE PERIOD_TYPE, SETUP_HOURS SETUP_HOURS, RESOURCE_COST RESOURCE_COST from "MSC"."MSC_BIS_RES_SUMMARY"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, RESOURCE_DATE RESOURCE_DATE
, REQUIRED_HOURS REQUIRED_HOURS
, AVAILABLE_HOURS AVAILABLE_HOURS
, UTILIZATION UTILIZATION
, DEPARTMENT_CLASS DEPARTMENT_CLASS
, RESOURCE_GROUP RESOURCE_GROUP
, 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
, OVERUTILIZATION_COST OVERUTILIZATION_COST
, UTIL_BY_WT_VOL UTIL_BY_WT_VOL
, BATCH_COUNT BATCH_COUNT
, DETAIL_LEVEL DETAIL_LEVEL
, PERIOD_TYPE PERIOD_TYPE
, SETUP_HOURS SETUP_HOURS
, RESOURCE_COST RESOURCE_COST
FROM "MSC"."MSC_BIS_RES_SUMMARY"