VIEW: MSC.MSC_BIS_RES_INST_SUMMARY#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, RESOURCE_ID RESOURCE_ID, RES_INSTANCE_ID RES_INSTANCE_ID, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID, SERIAL_NUMBER SERIAL_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_INST_DATE RESOURCE_INST_DATE, REQUIRED_HOURS REQUIRED_HOURS, AVAILABLE_HOURS AVAILABLE_HOURS, UTILIZATION UTILIZATION, 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, UTIL_BY_WT_VOL UTIL_BY_WT_VOL, BATCH_COUNT BATCH_COUNT, DETAIL_LEVEL DETAIL_LEVEL, PERIOD_TYPE PERIOD_TYPE from "MSC"."MSC_BIS_RES_INST_SUMMARY"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, RESOURCE_ID RESOURCE_ID
, RES_INSTANCE_ID RES_INSTANCE_ID
, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID
, SERIAL_NUMBER SERIAL_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_INST_DATE RESOURCE_INST_DATE
, REQUIRED_HOURS REQUIRED_HOURS
, AVAILABLE_HOURS AVAILABLE_HOURS
, UTILIZATION UTILIZATION
, 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
, UTIL_BY_WT_VOL UTIL_BY_WT_VOL
, BATCH_COUNT BATCH_COUNT
, DETAIL_LEVEL DETAIL_LEVEL
, PERIOD_TYPE PERIOD_TYPE
FROM "MSC"."MSC_BIS_RES_INST_SUMMARY"