DBA Data[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_DEPARTMENT_RESOURCES

Object Details
Object Name: MSC_DEPARTMENT_RESOURCES
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_DEPARTMENT_RESOURCES
Subobject Name:
Status: VALID


This table stores the resources available for planning.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_DEPARTMENT_RESOURCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnDEPARTMENT_ID
ColumnRESOURCE_ID
ColumnNEW_PLAN_ID
ColumnSIMULATION_SET_ID
MSC_DEPARTMENT_RESOURCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_FLAG
ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
MSC_DEPARTMENT_RESOURCES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnRESOURCE_ID
MSC_DEPARTMENT_RESOURCES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnRESOURCE_GROUP_NAME
ColumnSR_INSTANCE_ID
ColumnRESOURCE_ID
ColumnDEPARTMENT_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
RESOURCE_ID NUMBER
Yes Source application resource identifier
DEPARTMENT_ID NUMBER
Yes Source application department identifier or line identifier
RESOURCE_CODE VARCHAR2 (16)
Resource code
RESOURCE_DESCRIPTION VARCHAR2 (240)
Resource description
DEPARTMENT_CODE VARCHAR2 (10)
Department code, also holds line code
DEPARTMENT_DESCRIPTION VARCHAR2 (240)
Department description, also hold line description
DEPARTMENT_CLASS VARCHAR2 (10)
Department class
LINE_FLAG NUMBER
Yes Flag to indicate whether or not this resource is a line
AGGREGATE_RESOURCE_ID NUMBER

Reference to aggregate resource, if aggregated
AGGREGATE_RESOURCE_FLAG NUMBER
Yes Yes/No flag to indicate whether or not this is an aggregated resource
RESOURCE_GROUP_NAME VARCHAR2 (30)
Name of the group of resource
RESOURCE_GROUP_CODE VARCHAR2 (10)
Resource group code
RESOURCE_SHORTAGE_TYPE NUMBER

Resource shortage type
RESOURCE_BALANCE_FLAG NUMBER

Flag to indicate if the resource needs to load balanced
RESOURCE_EXCESS_TYPE NUMBER

Resource excess type
RESOURCE_INCLUDE_FLAG NUMBER

Flag to indicae if we need to consider this resource when planning
CRITICAL_RESOURCE_FLAG NUMBER

Flag to indicate if this a critical resource. This is used by LP and HLS
OVERUTILIZED_PERCENT NUMBER

Overutilization tolerance
BOTTLENECK_FLAG NUMBER

Flag to indicate if the resource is a known bottleneck
UNDERUTILIZED_PERCENT NUMBER

Underutilization tolerance
OWNING_DEPARTMENT_ID NUMBER

Owning department identifier for share resources
CAPACITY_UNITS NUMBER

Resource capacity
UTILIZATION NUMBER

Resource utilization
EFFICIENCY NUMBER

Resource Efficiency
USER_TIME_FENCE NUMBER

Number of days within which planning will generate an exception message
RESOURCE_TYPE NUMBER

Resource type
DISABLE_DATE DATE

Date on which resource/line was disabled
AVAILABLE_24_HOURS_FLAG NUMBER
Yes Resource is available 24 hours or by shifts
MIN_RATE NUMBER

Hourly minimum rate of production line
MAX_RATE NUMBER

Hourly maximum rate of production line
START_TIME NUMBER

Start time of the line
STOP_TIME NUMBER

Stop time of the line
CTP_FLAG NUMBER

Flag indicating whether the department resource is used for ATP or not
REFRESH_NUMBER NUMBER

Refresh Number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
RESOURCE_COST NUMBER

Resource cost
RESOURCE_OVER_UTIL_COST NUMBER

Resource overutilization cost
DEPT_OVERHEAD_COST NUMBER

Department overhead cost
PLANNING_EXCEPTION_SET VARCHAR2 (10)
Planning Exception Set
BATCHABLE_FLAG NUMBER

Batchable Flag
BATCHING_WINDOW NUMBER

Batching Window
MIN_CAPACITY NUMBER

Min Capacity
MAX_CAPACITY NUMBER

Max Capacity
UNIT_OF_MEASURE VARCHAR2 (3)
Unit Of Measure
UOM_CLASS_TYPE NUMBER

Uom Class Type
ATP_RULE_ID NUMBER

Identifier of the available to promise rule used.
AVAIL_FACTOR NUMBER

Avail factor
CAPACITY_TOLERANCE NUMBER

Capacity tolerance in % (OPM)
CHARGEABLE_FLAG NUMBER

If checked then resource is chargeable (OPM)1 Yes, 2 No
LAST_KNOWN_SETUP NUMBER

Last know setup associated with this resource.
SCHEDULE_TO_INSTANCE NUMBER

Resource to be scheduled for instances. 1 Yes 2 =no
SDS_SCHEDULING_WINDOW NUMBER

Scheduling window for sds resource
IDLE_TIME_TOLERANCE NUMBER

For sds resource, what is the idle time ( in hours) resource can stay idle
BATCHING_PENALTY NUMBER

Batching Penalty = 0, if the activity is added on to a currently scheduled batch Batching Penalty = pb, if the activity is scheduled as a new batch
SETUP_TIME_PERCENT NUMBER

Threshold percentage for Resource performing excessive setup
UTILIZATION_CHANGE_PERCENT NUMBER

Threshold percentage for Resource utilization change exceeds threshold
SETUP_TIME_TYPE NUMBER

Exception horizon for Resource performing excessive setup
UTILIZATION_CHANGE_TYPE NUMBER

Exception horizon for Resource utilization change exceeds Threshold
APPLIED NUMBER

Applied
NEW_PLAN_ID NUMBER

New Plan Id
NEW_PLAN_LIST VARCHAR2 (256)
New Plan List
SIMULATION_SET_ID NUMBER

Simulation Set Id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_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
,      START_TIME
,      STOP_TIME
,      CTP_FLAG
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      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
,      APPLIED
,      NEW_PLAN_ID
,      NEW_PLAN_LIST
,      SIMULATION_SET_ID
FROM MSC.MSC_DEPARTMENT_RESOURCES;

Dependencies

[top of page]

MSC.MSC_DEPARTMENT_RESOURCES does not reference any database object

MSC.MSC_DEPARTMENT_RESOURCES is referenced by following:

SchemaAPPS
Materialized ViewMSC_PHUB_RESOURCES_MV
Materialized ViewMSC_RESOURCE_HIERARCHY_MV
SchemaMSC
ViewMSC_DEPARTMENT_RESOURCES#