CST_WD_OP_DEPENDENCIES
This table is used to indicate the dependencies between operations.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WD_OP_DEPENDENCIES_PK |
WD_OPERATION_DEPENDENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WD_OPERATION_DEPENDENCY_ID | NUMBER | 18 | Yes | The unique identifier of a work definition operation dependency. | |
| SCENARIO_ID | NUMBER | 18 | Yes | Indicates the unique identifier of the cost planning scenario for which the operation dependencies are being created. | |
| WORK_DEFINITION_ITEM_ID | NUMBER | 18 | Yes | Indicates the work definition item identifier. | |
| PREDECESSOR_WD_OPERATION_ID | NUMBER | 18 | Indicates the predecessor work definition operation identifier from manufacturing. | ||
| SUCCESSOR_WD_OPERATION_ID | NUMBER | 18 | Yes | Indicates the successor work definition operation identifier from manufacturing. | |
| PREDECESSOR_CST_OPERATION_ID | NUMBER | 18 | Indicates the predecessor work definition operation identifier from cost management rollup. | ||
| SUCCESSOR_CST_OPERATION_ID | NUMBER | 18 | Yes | Indicates the successor work definition operation identifier from cost management rollup. | |
| WIS_WD_OP_DEPENDENCY_ID | NUMBER | 18 | Indicates the manufacturing reference for work definition operation dependency. It is set to NULL for pseudo records created for work definitions that does not have enforce operation dependency set to yes. | ||
| CALCULATION_SEQUENCE | NUMBER | 18 | Indicates the sequence in which the rollup carry forward calculations are performed. | ||
| DEPENDENCY_TYPE | VARCHAR2 | 30 | Yes | Indicates the dependency between predecessor and successor operations. Valid Values are: FS, SS. | |
| TRANSFER_PERCENT | NUMBER | Yes | Indicates the percentage of transfer value between two operations. | ||
| OP_YIELD_FACTOR | NUMBER | Indicates the operation yield factor as indicated in manufacturing setup. | |||
| OP_CUM_YIELD_FACTOR | NUMBER | Indicates the cumulative operation yield calculated based on the operation yields of the various operations in a work definition. | |||
| OP_REV_YIELD_FACTOR | NUMBER | Indicates the reverse cumulative operation yield calculated based on the operation yields of the various operations in a work definition. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WD_OP_DEPENDENCIES_U1 | Unique | Default | WD_OPERATION_DEPENDENCY_ID |
| CST_WD_OP_DEPENDENCIES_U2 | Unique | Default | WORK_DEFINITION_ITEM_ID, PREDECESSOR_WD_OPERATION_ID, SUCCESSOR_WD_OPERATION_ID |
| CST_WD_OP_DEPENDENCIES_U3 | Unique | Default | WORK_DEFINITION_ITEM_ID, PREDECESSOR_CST_OPERATION_ID, SUCCESSOR_CST_OPERATION_ID |