MSC_DEPARTMENT_RESOURCESRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID ORGANIZATION_ID RESOURCE_ID DEPARTMENT_ID RESOURCE_CODE RESOURCE_DESCRIPTION DEPARTMENT_CODE DEPARTMENT_DESCRIPTION DEPARTMENT_CLASS LINE_FLAG AGGREGATE_RESOURCE_ID AGGREGATE_RESOURCE_FLAG RESOURCE_GROUP_NAME RESOURCE_GROUP_CODE RESOURCE_SHORTAGE_TYPE RESOURCE_BALANCE_FLAG RESOURCE_EXCESS_TYPE RESOURCE_INCLUDE_FLAG CRITICAL_RESOURCE_FLAG OVERUTILIZED_PERCENT BOTTLENECK_FLAG UNDERUTILIZED_PERCENT OWNING_DEPARTMENT_ID CAPACITY_UNITS UTILIZATION EFFICIENCY USER_TIME_FENCE RESOURCE_TYPE DISABLE_DATE AVAILABLE_24_HOURS_FLAG MIN_RATE MAX_RATE LINE_DISABLE_DATE START_TIME STOP_TIME CTP_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 REFRESH_NUMBER RESOURCE_COST RESOURCE_OVER_UTIL_COST DEPT_OVERHEAD_COST PLANNING_EXCEPTION_SET BATCHABLE_FLAG BATCHING_WINDOW MIN_CAPACITY MAX_CAPACITY UNIT_OF_MEASURE UOM_CLASS_TYPE ATP_RULE_ID AVAIL_FACTOR CAPACITY_TOLERANCE CHARGEABLE_FLAG LAST_KNOWN_SETUP SCHEDULE_TO_INSTANCE SDS_SCHEDULING_WINDOW IDLE_TIME_TOLERANCE BATCHING_PENALTY SETUP_TIME_PERCENT UTILIZATION_CHANGE_PERCENT SETUP_TIME_TYPE UTILIZATION_CHANGE_TYPE

Name

PLAN_ID

ORGANIZATION_ID

RESOURCE_ID

DEPARTMENT_ID

RESOURCE_CODE

RESOURCE_DESCRIPTION

DEPARTMENT_CODE

DEPARTMENT_DESCRIPTION

DEPARTMENT_CLASS

LINE_FLAG

AGGREGATE_RESOURCE_ID

AGGREGATE_RESOURCE_FLAG

RESOURCE_GROUP_NAME

RESOURCE_GROUP_CODE

RESOURCE_SHORTAGE_TYPE

RESOURCE_BALANCE_FLAG

RESOURCE_EXCESS_TYPE

RESOURCE_INCLUDE_FLAG

CRITICAL_RESOURCE_FLAG

OVERUTILIZED_PERCENT

BOTTLENECK_FLAG

UNDERUTILIZED_PERCENT

OWNING_DEPARTMENT_ID

CAPACITY_UNITS

UTILIZATION

EFFICIENCY

USER_TIME_FENCE

RESOURCE_TYPE

DISABLE_DATE

AVAILABLE_24_HOURS_FLAG

MIN_RATE

MAX_RATE

LINE_DISABLE_DATE

START_TIME

STOP_TIME

CTP_FLAG

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

REFRESH_NUMBER

RESOURCE_COST

RESOURCE_OVER_UTIL_COST

DEPT_OVERHEAD_COST

PLANNING_EXCEPTION_SET

BATCHABLE_FLAG

BATCHING_WINDOW

MIN_CAPACITY

MAX_CAPACITY

UNIT_OF_MEASURE

UOM_CLASS_TYPE

ATP_RULE_ID

AVAIL_FACTOR

CAPACITY_TOLERANCE

CHARGEABLE_FLAG

LAST_KNOWN_SETUP

SCHEDULE_TO_INSTANCE

SDS_SCHEDULING_WINDOW

IDLE_TIME_TOLERANCE

BATCHING_PENALTY

SETUP_TIME_PERCENT

UTILIZATION_CHANGE_PERCENT

SETUP_TIME_TYPE

UTILIZATION_CHANGE_TYPE

Query

SQL_Statement
select "PLAN_ID","ORGANIZATION_ID","RESOURCE_ID","DEPARTMENT_ID","RESOURCE_CODE","RESOURCE_DESCRIPTION","DEPARTMENT_CODE","DEPARTMENT_DESCRIPTION","DEPARTMENT_CLASS","LINE_FLAG","AGGREGATE_RESOURCE_ID","AGGREGATE_RESOURCE_FLAG","RESOURCE_GROUP_NAME","RESOURCE_GROUP_CODE","RESOURCE_SHORTAGE_TYPE","RESOURCE_BALANCE_FLAG","RESOURCE_EXCESS_TYPE","RESOURCE_INCLUDE_FLAG","CRITICAL_RESOURCE_FLAG","OVERUTILIZED_PERCENT","BOTTLENECK_FLAG","UNDERUTILIZED_PERCENT","OWNING_DEPARTMENT_ID","CAPACITY_UNITS","UTILIZATION","EFFICIENCY","USER_TIME_FENCE","RESOURCE_TYPE","DISABLE_DATE","AVAILABLE_24_HOURS_FLAG","MIN_RATE","MAX_RATE","LINE_DISABLE_DATE","START_TIME","STOP_TIME","CTP_FLAG","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","REFRESH_NUMBER","RESOURCE_COST","RESOURCE_OVER_UTIL_COST","DEPT_OVERHEAD_COST","PLANNING_EXCEPTION_SET","BATCHABLE_FLAG","BATCHING_WINDOW","MIN_CAPACITY","MAX_CAPACITY","UNIT_OF_MEASURE","UOM_CLASS_TYPE","ATP_RULE_ID","AVAIL_FACTOR","CAPACITY_TOLERANCE","CHARGEABLE_FLAG","LAST_KNOWN_SETUP","SCHEDULE_TO_INSTANCE","SDS_SCHEDULING_WINDOW","IDLE_TIME_TOLERANCE","BATCHING_PENALTY","SETUP_TIME_PERCENT","UTILIZATION_CHANGE_PERCENT","SETUP_TIME_TYPE","UTILIZATION_CHANGE_TYPE" from msc_department_resources as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "PLAN_ID","ORGANIZATION_ID","RESOURCE_ID","DEPARTMENT_ID","RESOURCE_CODE","RESOURCE_DESCRIPTION","DEPARTMENT_CODE","DEPARTMENT_DESCRIPTION","DEPARTMENT_CLASS","LINE_FLAG","AGGREGATE_RESOURCE_ID","AGGREGATE_RESOURCE_FLAG","RESOURCE_GROUP_NAME","RESOURCE_GROUP_CODE","RESOURCE_SHORTAGE_TYPE","RESOURCE_BALANCE_FLAG","RESOURCE_EXCESS_TYPE","RESOURCE_INCLUDE_FLAG","CRITICAL_RESOURCE_FLAG","OVERUTILIZED_PERCENT","BOTTLENECK_FLAG","UNDERUTILIZED_PERCENT","OWNING_DEPARTMENT_ID","CAPACITY_UNITS","UTILIZATION","EFFICIENCY","USER_TIME_FENCE","RESOURCE_TYPE","DISABLE_DATE","AVAILABLE_24_HOURS_FLAG","MIN_RATE","MAX_RATE","LINE_DISABLE_DATE","START_TIME","STOP_TIME","CTP_FLAG","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","REFRESH_NUMBER","RESOURCE_COST","RESOURCE_OVER_UTIL_COST","DEPT_OVERHEAD_COST","PLANNING_EXCEPTION_SET","BATCHABLE_FLAG","BATCHING_WINDOW","MIN_CAPACITY","MAX_CAPACITY","UNIT_OF_MEASURE","UOM_CLASS_TYPE","ATP_RULE_ID","AVAIL_FACTOR","CAPACITY_TOLERANCE","CHARGEABLE_FLAG","LAST_KNOWN_SETUP","SCHEDULE_TO_INSTANCE","SDS_SCHEDULING_WINDOW","IDLE_TIME_TOLERANCE","BATCHING_PENALTY","SETUP_TIME_PERCENT","UTILIZATION_CHANGE_PERCENT","SETUP_TIME_TYPE","UTILIZATION_CHANGE_TYPE" from msc_department_resources as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))