[Home] [Help] [Dependency Information]
Object Name: | MSC_OPERATION_RESOURCES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_OPERATION_RESOURCES |
Subobject Name: | |
Status: | VALID |
This table stores operation resources from a resource sequence. For each resource sequence, we have an alternative between different set of operation resources. This is described by the Alternate Number. Resources with the same Alternate Number are simultaneous. Different Alternate Number represent alternatives between group of resources.
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_OPERATION_RESOURCES_U1 | NORMAL | UNIQUE |
PLAN_ID
SR_INSTANCE_ID ROUTING_SEQUENCE_ID OPERATION_SEQUENCE_ID RESOURCE_SEQ_NUM RESOURCE_ID ALTERNATE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Plan identifier | |
ROUTING_SEQUENCE_ID | NUMBER | Yes | Routing sequence identifier from source application instance | |
OPERATION_SEQUENCE_ID | NUMBER | Yes | Operation sequence identifier | |
RESOURCE_SEQ_NUM | NUMBER | Yes | Resource sequence number | |
RESOURCE_ID | NUMBER | Yes | Resource identifier | |
ALTERNATE_NUMBER | NUMBER | Yes | Resources with the same number are simultaneous. Different numbers are represent alternatives between groups of resources | |
PRINCIPAL_FLAG | NUMBER | Yes | Flag to indicate whether the resource is the principal resource | |
BASIS_TYPE | NUMBER | Yes | Item(1), lot(2), resource units(3), resource value(4), total value(5), activity(6). | |
RESOURCE_USAGE | NUMBER | Yes | Alternate resource volume necessary for this operation resource | |
MAX_RESOURCE_UNITS | NUMBER | Maximum number of resource units consumed by this operation resource | ||
RESOURCE_UNITS | NUMBER | Operation resource units (capacity). This can be fixed by the user and used as constraint | ||
UOM_CODE | VARCHAR2 | (3) | Yes | Unit of measure code |
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||
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_TYPE | NUMBER | Resource type | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
SETUP_ID | NUMBER | Setup type to be used for this resource. | ||
MINIMUM_CAPACITY | NUMBER | |||
MAXIMUM_CAPACITY | NUMBER | Maximum Capacity of the Batchable resource | ||
ORIG_RESOURCE_SEQ_NUM | NUMBER | Resource Seq Number in source instance | ||
BREAKABLE_ACTIVITY_FLAG | NUMBER | 1= Activity is breakable, 2 Activity is non breakable |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, ROUTING_SEQUENCE_ID
, OPERATION_SEQUENCE_ID
, RESOURCE_SEQ_NUM
, RESOURCE_ID
, ALTERNATE_NUMBER
, PRINCIPAL_FLAG
, BASIS_TYPE
, RESOURCE_USAGE
, MAX_RESOURCE_UNITS
, RESOURCE_UNITS
, UOM_CODE
, SR_INSTANCE_ID
, 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_TYPE
, ORGANIZATION_ID
, SETUP_ID
, MINIMUM_CAPACITY
, MAXIMUM_CAPACITY
, ORIG_RESOURCE_SEQ_NUM
, BREAKABLE_ACTIVITY_FLAG
FROM MSC.MSC_OPERATION_RESOURCES;
MSC.MSC_OPERATION_RESOURCES does not reference any database object
MSC.MSC_OPERATION_RESOURCES is referenced by following:
|
|
|