[Home] [Help] [Dependency Information]
Object Name: | MSC_SOLVER_GROUPS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Used for Production Schedule-solver-Solve Stages
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_SOLVER_GROUPS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
ORGANIZATION_ID SR_INSTANCE_ID SOLVER_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
SOLVER_GROUP_ID | NUMBER | |||
SOLVER_GROUP_NAME | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (250) | ||
GROUP_SEQUENCE | NUMBER | |||
USE_BREAK_POINT | NUMBER | |||
DEM_BUILD_STRATEGY | NUMBER | |||
USE_CRO | NUMBER | |||
IDEAL_SEQUENCE_BASE | NUMBER | |||
ENFORCE_CRO_CYCLE | NUMBER | |||
REM_CRO_RESI_PRODN | NUMBER | |||
INV_CC_SCALE_FACTOR | NUMBER | |||
INV_SOC_SCALE_FACTOR | NUMBER | |||
COC_SCALE_FACTOR | NUMBER | |||
SSVC_SCALE_FACTOR | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, SR_INSTANCE_ID
, ORGANIZATION_ID
, SOLVER_GROUP_ID
, SOLVER_GROUP_NAME
, DESCRIPTION
, GROUP_SEQUENCE
, USE_BREAK_POINT
, DEM_BUILD_STRATEGY
, USE_CRO
, IDEAL_SEQUENCE_BASE
, ENFORCE_CRO_CYCLE
, REM_CRO_RESI_PRODN
, INV_CC_SCALE_FACTOR
, INV_SOC_SCALE_FACTOR
, COC_SCALE_FACTOR
, SSVC_SCALE_FACTOR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM MSC.MSC_SOLVER_GROUPS;
MSC.MSC_SOLVER_GROUPS does not reference any database object
MSC.MSC_SOLVER_GROUPS is referenced by following:
|
|
|